Bug#397597: select query incorrectly returns empty dataset if order by is present, but works after dumping and restoring the database

forwarded 397597 http://bugs.mysql.com/bug.php?id=24778 tags 397597 + confirmed upstream stop On 2006-11-08 Enrico Zini wrote: This one is weird, but I can regularly reproduce it in my machine. I can reproduce it, too, and opened a bug report at mysql. bye, -christian- -- To UNSUBSCRIBE,

Bug#397597: select query incorrectly returns empty dataset if order by is present, but works after dumping and restoring the database

Package: mysql-server-5.0 Version: 5.0.26-2 Severity: normal Hello, thanks for maintaining mysql. This one is weird, but I can regularly reproduce it in my machine. Here is how: 1. Create the database test, on InnoDB 2. zcat intial-build.gz | mysql test 3. mysql test 4. SELECT pa.lat,