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
---------------------------------------------------------------------
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
