diff options
| author | bell@sanja.is.com.ua <> | 2002-11-28 22:59:35 +0200 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2002-11-28 22:59:35 +0200 |
| commit | 8e8678be9ecc8ed6a8b2360e360016f4436600ef (patch) | |
| tree | 1bd98cb6906e5a3ff269fb43300b7cec3cfeafea /mysql-test | |
| parent | 0b8054ac8c23af3345df00f7b3304df92eec2a36 (diff) | |
| download | mariadb-git-8e8678be9ecc8ed6a8b2360e360016f4436600ef.tar.gz | |
fixed bug 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); |