diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2018-08-28 12:22:56 +0300 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2018-08-28 12:22:56 +0300 |
| commit | 7830fb7f45b3824c0375c00ae2cab357165904cf (patch) | |
| tree | 730521737fdc48e69f7650819e9a29da6487e1f4 /mysql-test/main/group_min_max.result | |
| parent | b805ebd7ed49868f83e6fd3fe72a11ddacdce452 (diff) | |
| parent | 55163ba1bdb1a05daadc66c41c959994231b361c (diff) | |
| download | mariadb-git-7830fb7f45b3824c0375c00ae2cab357165904cf.tar.gz | |
Merge 10.2 into 10.3
Diffstat (limited to 'mysql-test/main/group_min_max.result')
| -rw-r--r-- | mysql-test/main/group_min_max.result | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/main/group_min_max.result b/mysql-test/main/group_min_max.result index 36a44b05817..b3b660c4170 100644 --- a/mysql-test/main/group_min_max.result +++ b/mysql-test/main/group_min_max.result @@ -3893,5 +3893,22 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 index a a 13 NULL 2 Using where; Using index drop table t1; # +# MDEV-15433: Optimizer does not use group by optimization with distinct +# +CREATE TABLE t1 (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, a INT NOT NULL, KEY(a)); +OPTIMIZE TABLE t1; +Table Op Msg_type Msg_text +test.t1 optimize status OK +EXPLAIN SELECT DISTINCT a FROM t1; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 range NULL a 4 NULL 5 Using index for group-by +SELECT DISTINCT a FROM t1; +a +1 +2 +3 +4 +drop table t1; +# # End of 10.1 tests # |