Re[2]: Numeric Type Inconsistency ?Bug [not!]

2002-07-12 Thread mysql-readers
mysql select 798 between 75.2 and 999.1; ++ | 1 | ++ mysql select 798 between 75.2 and 1e30; +---+ | 0 | Really? +---+ mysql

Re: Re[2]: Numeric Type Inconsistency ?Bug [not!]

2002-07-12 Thread Keith C. Ivey
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