diff options
| author | unknown <bell@sanja.is.com.ua> | 2002-10-13 14:25:16 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2002-10-13 14:25:16 +0300 |
| commit | a299a27021a7bdd65f93f99f9eb0003f082b305d (patch) | |
| tree | e50e70457b66196d793e32095a4bb48595e9bae3 /mysql-test | |
| parent | 102cec14653cf1bacbcff81eee9b726a85c145b1 (diff) | |
| download | mariadb-git-a299a27021a7bdd65f93f99f9eb0003f082b305d.tar.gz | |
fixed bug of multi-level EXPLAIN
mysql-test/r/subselect.result:
test of multi-level EXPLAIN
mysql-test/t/subselect.test:
test of multi-level EXPLAIN
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/subselect.result | 8 | ||||
| -rw-r--r-- | mysql-test/t/subselect.test | 3 |
2 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 6ea2a7ab3cf..b5b944583da 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -159,6 +159,14 @@ UNIQUE KEY `email` (`email`) INSERT INTO inscrit (pseudo,email) VALUES ('joce','test'); INSERT INTO inscrit (pseudo,email) VALUES ('joce1','test1'); INSERT INTO inscrit (pseudo,email) VALUES ('2joce1','2test1'); +EXPLAIN SELECT pseudo,(SELECT email FROM inscrit WHERE pseudo=(SELECT +pseudo FROM inscrit WHERE pseudo='joce')) FROM inscrit WHERE pseudo=(SELECT +pseudo FROM inscrit WHERE pseudo='joce'); +id select_type table type possible_keys key key_len ref rows Extra +1 PRIMARY inscrit const PRIMARY PRIMARY 35 const 1 +4 SUBSELECT inscrit const PRIMARY PRIMARY 35 const 1 +2 SUBSELECT inscrit const PRIMARY PRIMARY 35 const 1 +3 SUBSELECT inscrit const PRIMARY PRIMARY 35 const 1 SELECT pseudo FROM inscrit WHERE pseudo=(SELECT pseudo,email FROM inscrit WHERE pseudo='joce'); Subselect returns more than 1 field diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index 37f68a3c4cb..120cbcbc05f 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -82,6 +82,9 @@ CREATE TABLE `inscrit` ( INSERT INTO inscrit (pseudo,email) VALUES ('joce','test'); INSERT INTO inscrit (pseudo,email) VALUES ('joce1','test1'); INSERT INTO inscrit (pseudo,email) VALUES ('2joce1','2test1'); +EXPLAIN SELECT pseudo,(SELECT email FROM inscrit WHERE pseudo=(SELECT +pseudo FROM inscrit WHERE pseudo='joce')) FROM inscrit WHERE pseudo=(SELECT +pseudo FROM inscrit WHERE pseudo='joce'); -- error 1239 SELECT pseudo FROM inscrit WHERE pseudo=(SELECT pseudo,email FROM inscrit WHERE pseudo='joce'); |