[OpenSER-Devel] FUNCTION ser.bitand does not exist

[Juha Heinanen]

Juha Heinanen writes:

 > while testing usrloc db_mode=3, i'm getting these kind of errors:
 > 
 > May 13 00:31:25 Etch-3 /usr/sbin/openser[3985]:
 > ERROR:db_mysql:db_mysql_submit_query: driver error on query: FUNCTION
 > ser.bitand does not exist 

the query looks like this:

select received, contact, socket, cflags, path from location where expires > '2008-05-13 00:48:32' and bitand(cflags, 2) = 2 and mod(id, 20) = 12

and when i test it manually, i get the same error:

mysql> select received, contact, socket, cflags, path from location where expires > '2008-05-13 00:48:32' and bitand(cflags, 2) = 2 and mod(id, 20) = 12;
ERROR 1305 (42000): FUNCTION ser.bitand does not exist

according to mysql 5.0 manual:

BIT_AND(expr)

Returns the bitwise AND of all bits in expr. The calculation is
performed with 64-bit (BIGINT) precision.

This function returns 18446744073709551615 if there were no matching
rows. (This is the value of an unsigned BIGINT value with all bits set
to 1.) 

i.e., there is a typo in name of the function.

-- juha