List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:June 14 2001 1:32pm
Subject:Re: concated comparisons stopped working properly
View as plain text  

nsabbi wrote:

> mysql> select (1 < 5 < 3);
> +-------------+
> | (1 < 5 < 3) |
> +-------------+
> | 1           |
> +-------------+
> 1 row in set (0.00 sec)
> 
> 
> mysql> select (1 < 5 and 5 < 3);
> +--------------------+
> | (1 < 5 and 5 < 3)  |
> +--------------------+
> | 0 		     |
> +--------------------+
> 1 row in set (0.00 sec)
> 
> 
> This is really strange, and I remember that in 3.23.38 it worked
> correctly (1 < 5 < 3  returned 0)
> 
> My table is InnoDB.
> 
> Thanks
> 		Nico
> 
> 
> ---------------------------------------------------------------------
And why do you think it should return 0 ?

( 1 < 5 ) returns 1.
( 1 < 3 ) returns 1.
( 1 < 5 < 3 ) should then return 1.

Or am I missing something?


-- 
Gerald L. Clark
gerald_clark@stripped

Thread
LEFT JOIN in MySQL Version 3.22.32Holger Böhnke11 Jun
  • Re: LEFT JOIN in MySQL Version 3.22.32Tim11 Jun
    • RE: LEFT JOIN in MySQL Version 3.22.32Jeff Brewer11 Jun
      • concated comparisons stopped working properlynsabbi14 Jun
        • Re: concated comparisons stopped working properlyGerald Clark14 Jun
  • RE: LEFT JOIN in MySQL Version 3.22.32John Correa11 Jun
    • Re: LEFT JOIN in MySQL Version 3.22.32Holger Böhnke12 Jun
RE: concated comparisons stopped working properlyJon Haworth14 Jun
  • RE: concated comparisons stopped working properlyRich Duzenbury14 Jun