In addition to the previous I just want to say that the problem is most likely with the unsigned columns - I altered the integer column to remove the 'unsigned' property and now it is working properly
Regards Dobromir Velev [EMAIL PROTECTED] ----- Original Message ----- From: "Dobromir Velev" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 14, 2003 21:37 Subject: May be bug in MySQL 4 > Hi, > There might be a bug in mysql 4 (tested on 4.0.8-gamma and 4.0.9-gamma) when > combining simple arithmetic operations and date conversion > > I have a table with the following structure > date_col date 0000-00-00 > int_col tinyint(3) unsigned > > This is what happens when I try to run a query like the one below. > > mysql> select to_days(Now())-to_days(data_col)-int_col > from table_name where to_days(Now())-to_days(data_col)<int_col; > > +-----------------------------------+ > | to_days(Now())-to_days(date_col)-int_col | > +-----------------------------------+ > | 18446744073709551607 | > | 18446744073709551609 | > | 18446744073709551607 | > | 18446744073709551609 | > | 18446744073709551607 | > | 18446744073709551615 | > > > Tested on Linux Redhat 7.3 and on a Slackware 7.0.0 > > TIA > Dobromir Velev > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php