> -----Original Message----- > From: Ephraim Dan [mailto:[EMAIL PROTECTED] > Sent: 27 February 2005 15:44 > To: mysql@lists.mysql.com > Subject: select ... where bigint_col = 'big_value' doesn't work? > > > Hi, > > We are migrating to mysql 4.1 (from 4.0). We have lots of BIGINT > columns, and lots of application code that have queries like the > following: > > select ... where bigint_col = '64-bit int value'
I personally have never bothered using the quotes around int numbers but I know someone who had to change every single MySQL query to fix the problem (taking out the quotes). I personally like the old MySQL 4.0xx > In 4.0, this worked fine. In 4.1 it does not work. The query only > works if you take the single-quotes away. > I could not find an explanation in the docs. Is this a bug or expected > behavior? Is there a workaround besides changing all our code? > Thanks, > Ephraim Dan Chris -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 266.5.0 - Release Date: 25/02/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
