diff options
Diffstat (limited to 'mysql-test/t/func_group_innodb.test')
-rw-r--r-- | mysql-test/t/func_group_innodb.test | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/mysql-test/t/func_group_innodb.test b/mysql-test/t/func_group_innodb.test index 06405808d79..c62d3d08496 100644 --- a/mysql-test/t/func_group_innodb.test +++ b/mysql-test/t/func_group_innodb.test @@ -180,7 +180,12 @@ SET storage_engine=@old_engine; CREATE TABLE t1(a BLOB, b VARCHAR(255) CHARSET LATIN1, c INT, KEY(b, c, a(765))) ENGINE=INNODB; -INSERT INTO t1(a, b, c) VALUES ('', 'a', 0), ('', 'a', null), ('', 'a', 0); +INSERT INTO t1(a, b, c) VALUES +('', 'a', 0), ('', 'a', null), ('', 'a', 0), ('', 'a', null), ('', 'a', 0); + +-- disable_result_log +ANALYZE TABLE t1; +-- enable_result_log SELECT MIN(c) FROM t1 GROUP BY b; EXPLAIN SELECT MIN(c) FROM t1 GROUP BY b; |