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
[EMAIL PROTECTED]
---------------------------------------------------------------------
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