possible BUG in 'between' comparisons

2005-07-11 Thread tallen
>Description: There appears to be a type promotion problem involving sql statements which include a 'between' comparison and a decimal type field is one of the operands. >How-To-Repeat: CREATE TABLE `foo1` ( `test1` decimal(7,2) NOT NULL default '0.00', `test2` decimal(7,2) NOT NULL defau

Re: possible BUG in 'between' comparisons

2005-07-10 Thread Lester Hightower
I have confirmed that this problem exhibits itself on the Mysql AB compiled binaries that are compiled with gcc, both Standard and Max, but does _not_ exhibit itself on the Mysql AB binary built with the Intel C++ Compiler 8.1 (mysql-standard-4.1.12-pc-linux-gnu-i686-icc-glibc23.tar.gz). I have al