diff options
| author | bell@sanja.is.com.ua <> | 2002-11-28 20:12:14 +0200 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2002-11-28 20:12:14 +0200 |
| commit | fcb0b8815be29e4feb41f7bce015cefd8797d268 (patch) | |
| tree | ff655e477b0570f3c4aad9d7eeb3408e7dde97ec /mysql-test | |
| parent | c1527b6f4c55eb4e5455ac25912a96181dfd7a01 (diff) | |
| parent | ec3859569610b3711d5d3c80ab73cf13b7c5f9f9 (diff) | |
| download | mariadb-git-fcb0b8815be29e4feb41f7bce015cefd8797d268.tar.gz | |
merging
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/subselect.result | 27 | ||||
| -rw-r--r-- | mysql-test/t/subselect.test | 14 |
2 files changed, 41 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; diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index c9ab505bffb..a0375bb84f0 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -306,3 +306,17 @@ select * from t1; replace LOW_PRIORITY into t1 (x, y) VALUES ((SELECT a+1 FROM t2), (SELECT a FROM t2)); select * from t1; drop table t1, t2; + +-- error 1096 +SELECT * FROM (SELECT 1) WHERE 1 IN (SELECT *); +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); +EXPLAIN SELECT * FROM t WHERE id IN (SELECT 1); +SELECT * FROM t WHERE id IN (SELECT 1 UNION SELECT 3); +EXPLAIN SELECT * FROM t WHERE id IN (SELECT 1 UNION SELECT 3); +SELECT * FROM t WHERE id IN (SELECT 5 UNION SELECT 3); +SELECT * FROM t WHERE id IN (SELECT 5 UNION SELECT 2); +drop table if exists t; + |