MySQL, This is a bug, isn't it?
mysql> select 798 between 75.2 and 999.1; +----------------------------+ | 798 between 75.2 and 999.1 | +----------------------------+ | 1 | +----------------------------+ 1 row in set (0.01 sec) mysql> select 798 between 75.2 and 1e30; +---------------------------+ | 798 between 75.2 and 1e30 | +---------------------------+ | 0 | <<<-------- Really? +---------------------------+ 1 row in set (0.00 sec) mysql> select 798.1 between 75.2 and 1e30; +-----------------------------+ | 798.1 between 75.2 and 1e30 | +-----------------------------+ | 1 | +-----------------------------+ 1 row in set (0.00 sec) (v3.23 on RH7.x) -- Best regards, James. --------------------------------------------------------------------- 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
