diff options
Diffstat (limited to 'mysql-test/main/distinct.test')
| -rw-r--r-- | mysql-test/main/distinct.test | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/mysql-test/main/distinct.test b/mysql-test/main/distinct.test index 06589495..fd0d4fdf 100644 --- a/mysql-test/main/distinct.test +++ b/mysql-test/main/distinct.test @@ -579,9 +579,10 @@ INSERT INTO t1(a, b, c) VALUES (1, 1, 1), (1, 2, 2), (1, 2, 3); -EXPLAIN SELECT DISTINCT a, b, d, c FROM t1; - SELECT DISTINCT a, b, d, c FROM t1; +EXPLAIN SELECT DISTINCT a, b, d, c FROM t1; +INSERT INTO t1 SELECT seq/10,seq/10,seq/10,seq/10,seq from seq_1_to_100; +EXPLAIN SELECT DISTINCT a, b, d, c FROM t1; DROP TABLE t1; |