From 65e12f2ffe2fd6f93900eba6126d24bb8edaa66c Mon Sep 17 00:00:00 2001 From: unknown Date: Tue, 17 Dec 2002 23:18:19 +0200 Subject: 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; --- mysql-test/r/derived.result | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'mysql-test/r/derived.result') 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'); -- cgit v1.2.1