diff options
author | unknown <bell@sanja.is.com.ua> | 2002-11-24 11:18:32 +0200 |
---|---|---|
committer | unknown <bell@sanja.is.com.ua> | 2002-11-24 11:18:32 +0200 |
commit | 4587dddab92fc96764f190b8dc1d74461846f47d (patch) | |
tree | b8fe5e2cad9e102188cdf97a580d5c2801b4dd55 /mysql-test/t/subselect.test | |
parent | fc528393d9252717b1d804339d12aa73c7c55555 (diff) | |
download | mariadb-git-4587dddab92fc96764f190b8dc1d74461846f47d.tar.gz |
fix of selfreference bug
mysql-test/r/subselect.result:
test of selfreference
mysql-test/t/subselect.test:
test of selfreference
Diffstat (limited to 'mysql-test/t/subselect.test')
-rw-r--r-- | mysql-test/t/subselect.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index 02d85dd60a1..f838a27e7ff 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -6,6 +6,8 @@ SELECT (SELECT 1 FROM (SELECT 1) HAVING a=1) as a; -- error 1245 SELECT (SELECT 1 FROM (SELECT 1) HAVING b=1) as a,(SELECT 1 FROM (SELECT 1) HAVING a=1) as b; SELECT (SELECT 1),MAX(1) FROM (SELECT 1); +-- error 1245 +SELECT (SELECT a) as a; drop table if exists t1,t2,t3,t4,t5,attend,clinic,inscrit; create table t1 (a int); create table t2 (a int, b int); |