MySQL Bugs: #21456: SELECT DISTINCT(x) produces incorrect results when using order by – Version 4.1.21 has an error in the query optimizer where SELECT DISTINCT doesn’t work when using ORDER BY. Guess which version of MySQL I was using when I found this out.
Tags: mysql bug sql
Categories