enterprise-support team mailing list archive

Thread
Date

[Bug 897970] Re: BIGINT for comparing is error

To: enterprise-support@xxxxxxxxxxxxxxxxxxx
From: Alexey Kopytov <alexey.kopytov@xxxxxxxxxxx>
Date: Tue, 31 Jan 2012 15:03:41 -0000
Reply-to: Bug 897970 <897970@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx

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