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/r/derived.result | |
| 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/r/derived.result')
| -rw-r--r-- | mysql-test/r/derived.result | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/r/derived.result b/mysql-test/r/derived.result index 03e00b206b2..06d2e663221 100644 --- a/mysql-test/r/derived.result +++ b/mysql-test/r/derived.result @@ -1,3 +1,7 @@ +SELECT 1 as a FROM (SELECT 1 UNION SELECT a) b; +Unknown column 'a' in 'field list' +SELECT 1 as a FROM (SELECT a UNION SELECT 1) b; +Unknown column 'a' in 'field list' 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'); |