diff options
Diffstat (limited to 'mysql-test/main/derived.test')
-rw-r--r-- | mysql-test/main/derived.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/main/derived.test b/mysql-test/main/derived.test index 799de90d30e..904114e33b9 100644 --- a/mysql-test/main/derived.test +++ b/mysql-test/main/derived.test @@ -475,8 +475,10 @@ CREATE TABLE t1 (a INT) ENGINE=MyISAM; INSERT INTO t1 VALUES (8); CREATE TABLE t2 (b INT) ENGINE=MyISAM; INSERT INTO t2 VALUES (1),(7); +--enable_prepare_warnings EXPLAIN SELECT * FROM (SELECT * FROM t1) AS table1, (SELECT DISTINCT * FROM t2) AS table2 WHERE b = a AND a <> ANY (SELECT 9); +--disable_prepare_warnings DROP TABLE t1, t2; set optimizer_switch=@save_derived_optimizer_switch_bug; |