On 12 Jul 2002, at 14:25, [EMAIL PROTECTED] wrote: > When the integer comparison is performed, the min & max are parsed as > integers and anything after the first non-digit is ignored, and that > works okay-ish for the decimal point for obvious reasons, but of > course the exponential syntax doesn't truncate so well!
It looks like the min and max are rounded to integers. Try "SELECT 2 BETWEEN 2.1 AND 5" or "SELECT 3 BETWEEN 2 AND 2.8". Also, the exponential numbers are converted to integers, not truncated at the "e". It's just that your 1e30 is too big for an integer. Try it with 1e18 instead. I don't know what 1e30 is being converted to, though -- apparently not the max BIGINT. [Filter fodder: SQL] -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org --------------------------------------------------------------------- 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
