diff options
| author | unknown <bell@sanja.is.com.ua> | 2002-11-28 22:59:35 +0200 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2002-11-28 22:59:35 +0200 |
| commit | 4078d0deffb7720c2732be4bfea5fec107d40779 (patch) | |
| tree | 1bd98cb6906e5a3ff269fb43300b7cec3cfeafea /mysql-test | |
| parent | 53a81804e9140a0bc3a047fd8df0a2e105e09413 (diff) | |
| download | mariadb-git-4078d0deffb7720c2732be4bfea5fec107d40779.tar.gz | |
fixed bug IN subselect with ORDER
mysql-test/r/subselect.result:
test of IN subselect with ORDER
mysql-test/t/subselect.test:
test of IN subselect with ORDER
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/subselect.result | 3 | ||||
| -rw-r--r-- | mysql-test/t/subselect.test | 2 |
2 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 6d922201618..ea771938286 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -32,6 +32,9 @@ a 1 SELECT 1 FROM (SELECT (SELECT a)); Unknown column 'a' in 'field list' +SELECT * FROM (SELECT 1 as id) WHERE id IN (SELECT * FROM (SELECT 1 as id) ORDER BY id LIMIT 1); +id +1 drop table if exists t1,t2,t3,t4,t5,t6,t7,t8; create table t1 (a int); create table t2 (a int, b int); diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index a0375bb84f0..3db1402ba90 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -15,6 +15,8 @@ SELECT (SELECT 1), a; SELECT 1 as a FROM (SELECT 1) HAVING (SELECT a)=1; -- error 1054 SELECT 1 FROM (SELECT (SELECT a)); +SELECT * FROM (SELECT 1 as id) WHERE id IN (SELECT * FROM (SELECT 1 as id) ORDER BY id LIMIT 1); + drop table if exists t1,t2,t3,t4,t5,t6,t7,t8; create table t1 (a int); create table t2 (a int, b int); |