In the last episode (Jan 30), [EMAIL PROTECTED] said:
> >Description:
> Instead of ordering rows, ORDER BY may remove rows
...
> mysql> SELECT Id3 FROM T WHERE Id2=2 AND Val BETWEEN -30 AND 20 ORDER BY Id3;
> +-----+
> | Id3 |
> +-----+
> | 3 |
> +-----+
> 1 row in set (0.01 sec)
>
> Note: both indices Key2 and Key3 must be present for the bug to occur.
I see this too. Even more fun:
mysql> SELECT Id3 FROM T WHERE Id2=2 AND Val BETWEEN -30 AND 20 ORDER BY Id3 DESC;
Empty set (0.00 sec)
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
