Re: concated comparisons stopped working properly

[Gerald Clark]

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