diff options
Diffstat (limited to 'mysql-test/r/subselect.result')
| -rw-r--r-- | mysql-test/r/subselect.result | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index ea5482405af..6d922201618 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -513,3 +513,30 @@ x y 4 2 2 1 drop table t1, t2; +SELECT * FROM (SELECT 1) WHERE 1 IN (SELECT *); +No tables used +drop table if exists t; +CREATE TABLE t (id int(11) default NULL, KEY id (id)) TYPE=MyISAM CHARSET=latin1; +INSERT INTO t VALUES (1),(2); +SELECT * FROM t WHERE id IN (SELECT 1); +id +1 +EXPLAIN SELECT * FROM t WHERE id IN (SELECT 1); +id select_type table type possible_keys key key_len ref rows Extra +1 PRIMARY t ref id id 5 const 1 Using where; Using index +Warnings: +Note 1246 Select 2 was reduced during optimisation +SELECT * FROM t WHERE id IN (SELECT 1 UNION SELECT 3); +id +1 +EXPLAIN SELECT * FROM t WHERE id IN (SELECT 1 UNION SELECT 3); +id select_type table type possible_keys key key_len ref rows Extra +1 PRIMARY t index NULL id 5 NULL 2 Using where; Using index +2 DEPENDENT SUBSELECT No tables used +3 UNION No tables used +SELECT * FROM t WHERE id IN (SELECT 5 UNION SELECT 3); +id +SELECT * FROM t WHERE id IN (SELECT 5 UNION SELECT 2); +id +2 +drop table if exists t; |