MariaDB

  1. Bug #694450
  2. Comment #2

Comment 2 for bug 694450

Revision history for this message
Philip Stoev (philip-stoev) wrote :

Yes, there are two distinct issues:

A. ONLY_FULL_GROUP_BY does not prevent a query with sub-standard ORDER BY from running. I think this bug has been there since the dawn of time. I will report it to MySQL when I have a chance.

B. Wrong result from the query. Here are the results I am getting:
- mysql-5.1.53 from binary - bug is present
- mysql-5.5.8 from binary - bug is present, also generates extra warnings
- maria-5.3 ./BUILD/compile-pentium-debug-max-no-ndb - bug is present
- maria-5.2 ./BUILD/compile-pentium-debug-max-no-ndb - bug is present
- maria-5.1 ./BUILD/compile-pentium-debug-max-no-ndb - bug is present