diff options
| author | unknown <bell@sanja.is.com.ua> | 2002-10-23 23:36:11 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2002-10-23 23:36:11 +0300 |
| commit | 4aef2862965978b6bc4168c349757aa5fd23bc48 (patch) | |
| tree | 49ea1e25de8e73e07e157831b2800cdf36c73e8d /mysql-test | |
| parent | efe61a86bf5039cd5b07b838680fdfbb17c8c42a (diff) | |
| download | mariadb-git-4aef2862965978b6bc4168c349757aa5fd23bc48.tar.gz | |
fixed DISTINCT in subselect bug
small Item_ref fix
mysql-test/r/subselect.result:
DISTINCT in subselect test
mysql-test/t/subselect.test:
DISTINCT in subselect test
sql/sql_class.cc:
fixed DISTINCT in subselect bug
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/subselect.result | 6 | ||||
| -rw-r--r-- | mysql-test/t/subselect.test | 2 |
2 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 2dcafe2c9cb..3f89f546ca3 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -198,4 +198,10 @@ EXPLAIN SELECT (SELECT DISTINCT date FROM searchconthardwarefr3 WHERE date='2002 id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY No tables used 2 SUBSELECT searchconthardwarefr3 index NULL PRIMARY 41 NULL 2 where used; Using index +SELECT DISTINCT date FROM searchconthardwarefr3 WHERE date='2002-08-03'; +date +2002-08-03 +SELECT (SELECT DISTINCT date FROM searchconthardwarefr3 WHERE date='2002-08-03'); +(SELECT DISTINCT date FROM searchconthardwarefr3 WHERE date='2002-08-03') +2002-08-03 drop table searchconthardwarefr3; diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index 518ade7fcf7..6e585883f1c 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -108,4 +108,6 @@ 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'); +SELECT DISTINCT date FROM searchconthardwarefr3 WHERE date='2002-08-03'; +SELECT (SELECT DISTINCT date FROM searchconthardwarefr3 WHERE date='2002-08-03'); drop table searchconthardwarefr3;
\ No newline at end of file |