diff options
Diffstat (limited to 'mysql-test/main/having.test')
| -rw-r--r-- | mysql-test/main/having.test | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/having.test b/mysql-test/main/having.test index e39d824d3a2..ce86c99865a 100644 --- a/mysql-test/main/having.test +++ b/mysql-test/main/having.test @@ -892,8 +892,8 @@ CREATE TABLE t1 (t INT, u INT, KEY(t)); INSERT INTO t1 VALUES(10, 10), (11, 11), (12, 12), (12, 13),(14, 15), (15, 16), (16, 17), (17, 17); ANALYZE TABLE t1; -SELECT t, next_seq_value() r FROM t1 FORCE INDEX(t) - GROUP BY t HAVING r = 1 ORDER BY t1.u; +explain SELECT t, next_seq_value() r FROM t1 FORCE INDEX(t) GROUP BY t HAVING r = 1 ORDER BY t1.u; +SELECT t, next_seq_value() r FROM t1 FORCE INDEX(t) GROUP BY t HAVING r = 1 ORDER BY t1.u; DROP TABLE t1; DROP FUNCTION next_seq_value; |