diff options
| author | unknown <gkodinov/kgeorge@macbook.gmz> | 2007-01-31 10:18:26 +0200 |
|---|---|---|
| committer | unknown <gkodinov/kgeorge@macbook.gmz> | 2007-01-31 10:18:26 +0200 |
| commit | d01ec5e72704513ce0e13fe5dd924c088757507e (patch) | |
| tree | d89cb0e43cd03774723d33becca1cac5b580ab63 /myisammrg | |
| parent | c6d4b94dd452d31f49430321a16690f7bec06d5c (diff) | |
| download | mariadb-git-d01ec5e72704513ce0e13fe5dd924c088757507e.tar.gz | |
Bug #25551: inconsistent behaviour in grouping NULL, depending on index type
The optimizer takes away columns from GROUP BY/DISTINCT if they constitute
all the parts of an unique index.
However if some of the columns can contain NULLs this cannot be done
(because an UNIQUE index can have multiple rows with NULL values).
Fixed by not using UNIQUE indexes with nullable columns to remove
grouping columns from GROUP BY/DISTINCT.
mysql-test/r/distinct.result:
Bug #25551: inconsistent behaviour in grouping NULL, depending on index type
- test case
mysql-test/t/distinct.test:
Bug #25551: inconsistent behaviour in grouping NULL, depending on index type
- test case
sql/sql_select.cc:
Bug #25551: inconsistent behaviour in grouping NULL, depending on index type
- UNIQUE NULL indices don't guarantee GROUP BY/DISTINCT.
Diffstat (limited to 'myisammrg')
0 files changed, 0 insertions, 0 deletions