diff options
author | Alexander Barkov <bar@mariadb.com> | 2019-03-21 13:43:17 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.com> | 2019-03-22 07:28:59 +0400 |
commit | f4484dfdbf2d78b0f357916ebd8ade024dd73c09 (patch) | |
tree | 680aca6e1cf1290efd65fa5fa53e936169394422 /mysql-test/main/func_debug.test | |
parent | 482710b20c28e2cdc598dc37468cc5dc06c53ac1 (diff) | |
download | mariadb-git-f4484dfdbf2d78b0f357916ebd8ade024dd73c09.tar.gz |
MDEV-19008 Slow EXPLAIN SELECT ... WHERE col IN (const1,const2,(subquery))
Diffstat (limited to 'mysql-test/main/func_debug.test')
-rw-r--r-- | mysql-test/main/func_debug.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/main/func_debug.test b/mysql-test/main/func_debug.test index e0960f736cb..8dd01650ed3 100644 --- a/mysql-test/main/func_debug.test +++ b/mysql-test/main/func_debug.test @@ -475,3 +475,16 @@ SELECT SET SESSION debug_dbug="-d,Predicant_to_list_comparator"; SET SESSION debug_dbug="-d,Item_func_in"; + + +--echo # +--echo # MDEV-19008 Slow EXPLAIN SELECT ... WHERE col IN (const1,const2,(subquery)) +--echo # + +SET SESSION debug_dbug="+d,Item_subselect"; +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); +EXPLAIN SELECT * FROM t1 WHERE a IN (1,2,(SELECT MAX(a) FROM t1)); +SELECT * FROM t1 WHERE a IN (1,2,(SELECT MAX(a) FROM t1)); +DROP TABLE t1; +SET SESSION debug_dbug="-d,Item_subselect"; |