diff options
| author | unknown <bell@sanja.is.com.ua> | 2002-12-17 23:18:19 +0200 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2002-12-17 23:18:19 +0200 |
| commit | 65e12f2ffe2fd6f93900eba6126d24bb8edaa66c (patch) | |
| tree | 36dbf9cf2c7d6431b85482d2df307420e7b85ca3 /mysql-test/t/derived.test | |
| parent | fddbc989a4c42a58f5986fb158145763ce47107a (diff) | |
| download | mariadb-git-65e12f2ffe2fd6f93900eba6126d24bb8edaa66c.tar.gz | |
fixed derived table visibility scope for derived tables with union
mysql-test/r/derived.result:
test of error messages
mysql-test/t/derived.test:
SELECT 1 as a FROM (SELECT 1 UNION SELECT a) b;
Diffstat (limited to 'mysql-test/t/derived.test')
| -rw-r--r-- | mysql-test/t/derived.test | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/t/derived.test b/mysql-test/t/derived.test index 5f63cea3c11..b9c9ab8a718 100644 --- a/mysql-test/t/derived.test +++ b/mysql-test/t/derived.test @@ -1,3 +1,7 @@ +-- error 1054 +SELECT 1 as a FROM (SELECT 1 UNION SELECT a) b; +-- error 1054 +SELECT 1 as a FROM (SELECT a UNION SELECT 1) b; drop table if exists t1,t2,t3; CREATE TABLE t1 (a int not null, b char (10) not null); insert into t1 values(1,'a'),(2,'b'),(3,'c'),(3,'c'); |