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 _______________________________________________ Devel mailing list Devel@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/devel
