diff options
| author | unknown <bell@sanja.is.com.ua> | 2002-10-16 00:42:59 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2002-10-16 00:42:59 +0300 |
| commit | 103330a3c03bb7c2652129bb87ec085e566aa67a (patch) | |
| tree | 06722c62ecc5ff2e613a75ad9fa796774797c7d7 /mysql-test/t | |
| parent | 5dcaaf4e04f19f9dc6a4ae4e1ef9746a3ff3cf6b (diff) | |
| download | mariadb-git-103330a3c03bb7c2652129bb87ec085e566aa67a.tar.gz | |
fixed subselect explain bug
mysql-test/r/subselect.result:
test for subselect explain bug
mysql-test/t/subselect.test:
test for subselect explain bug
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/subselect.test | 20 |
1 files changed, 16 insertions, 4 deletions
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index dbf45262a1e..518ade7fcf7 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -83,9 +83,7 @@ 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'); +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'); @@ -96,4 +94,18 @@ SELECT pseudo FROM inscrit WHERE pseudo=(SELECT pseudo FROM inscrit WHERE pseudo -- error 1240 SELECT pseudo FROM inscrit WHERE pseudo=(SELECT pseudo FROM inscrit WHERE pseudo LIKE '%joce%'); -drop table if exists t1,t2,t3,t4,t5,attend,clinic,inscrit;
\ No newline at end of file +drop table if exists t1,t2,t3,t4,t5,attend,clinic,inscrit; + +drop table if exists searchconthardwarefr3; +CREATE TABLE `searchconthardwarefr3` ( + `topic` mediumint(8) unsigned NOT NULL default '0', + `date` date NOT NULL default '0000-00-00', + `pseudo` varchar(35) character set latin1 NOT NULL default '', + PRIMARY KEY (`pseudo`,`date`,`topic`), + KEY `topic` (`topic`) +) TYPE=MyISAM ROW_FORMAT=DYNAMIC; +INSERT INTO searchconthardwarefr3 (topic,date,pseudo) VALUES +('43506','2002-10-02','joce'),('40143','2002-08-03','joce'); +EXPLAIN SELECT DISTINCT date FROM searchconthardwarefr3 WHERE date='2002-08-03'; +EXPLAIN SELECT (SELECT DISTINCT date FROM searchconthardwarefr3 WHERE date='2002-08-03'); +drop table searchconthardwarefr3;
\ No newline at end of file |