diff options
Diffstat (limited to 'mysql-test/main/group_by.result')
| -rw-r--r-- | mysql-test/main/group_by.result | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/mysql-test/main/group_by.result b/mysql-test/main/group_by.result index 6f1887290c0..5cf79b0de4e 100644 --- a/mysql-test/main/group_by.result +++ b/mysql-test/main/group_by.result @@ -2429,7 +2429,11 @@ a int, b varchar(1), KEY (b,a) ); -INSERT INTO t1 VALUES (1,NULL),(0,'a'),(1,NULL),(0,'a'); +INSERT INTO t1 VALUES +(1,NULL),(0,'a'),(1,NULL),(0,'a'), (1,'a'),(0,'a'),(2,'a'),(1,'a'); +ANALYZE TABLE t1; +Table Op Msg_type Msg_text +test.t1 analyze status OK EXPLAIN SELECT SQL_BUFFER_RESULT MIN(a), b FROM t1 WHERE t1.b = 'a' GROUP BY b; id select_type table type possible_keys key key_len ref rows Extra |