diff options
| author | mhansson/martin@linux-st28.site <> | 2007-08-27 17:33:41 +0200 |
|---|---|---|
| committer | mhansson/martin@linux-st28.site <> | 2007-08-27 17:33:41 +0200 |
| commit | a4d5d9204dcf82b45f86008f3f2a9e2414732329 (patch) | |
| tree | 471fede21d51804a73054250f11c2a6995683515 /client/completion_hash.cc | |
| parent | c40fe57fb544a57d3a2897f61deb7e04cb500e3b (diff) | |
| download | mariadb-git-a4d5d9204dcf82b45f86008f3f2a9e2414732329.tar.gz | |
Bug #30596 GROUP BY optimization gives wrong result order
The optimization that uses a unique index to remove GROUP BY, did not
ensure that the index was actually used, thus violating the ORDER BY
that is impled by GROUP BY.
Fixed by replacing GROUP BY with ORDER BY if the GROUP BY clause contains
a unique index. In case GROUP BY ... ORDER BY null is used, GROUP BY is
simply removed.
Diffstat (limited to 'client/completion_hash.cc')
0 files changed, 0 insertions, 0 deletions