Will be fixed in MySQL 5.5.21: " Expressions that compared a BIGINT column with any non-integer constant were performed using integers rather than decimal or float values, with the result that the constant could be truncated. This could lead to any such comparison that used <, >, <=, >=, =, !=/<>, IN, or BETWEEN yielding false positive or negative results. (Bug #13463415, Bug #11758543, Bug #63502, Bug #50756) "
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-21.html ** Changed in: percona-server Status: Confirmed => Fix Released -- You received this bug notification because you are a member of Ubuntu Server/Client Support Team, which is subscribed to MySQL. Matching subscriptions: Ubuntu Server/Client Support Team https://bugs.launchpad.net/bugs/897970 Title: BIGINT for comparing is error To manage notifications about this bug go to: https://bugs.launchpad.net/mysql-server/+bug/897970/+subscriptions -- Mailing list: https://launchpad.net/~enterprise-support Post to : [email protected] Unsubscribe : https://launchpad.net/~enterprise-support More help : https://help.launchpad.net/ListHelp
