diff options
Diffstat (limited to 'mysql-test/t/union.test')
| -rw-r--r-- | mysql-test/t/union.test | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test index 58e4c22e168..6045d8e3c30 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -499,6 +499,10 @@ select count(*) from t1 where b=13 union select count(*) from t1 where a=7; show status like 'Slow_queries'; select count(*) from t1 where a=7 union select count(*) from t1 where b=13; show status like 'Slow_queries'; +# additional test for examined rows +flush status; +select a from t1 where b not in (1,2,3) union select a from t1 where b not in (4,5,6); +show status like 'Slow_queries'; drop table t1; # |