summaryrefslogtreecommitdiff
path: root/mysql-test/t/derived.test
diff options
context:
space:
mode:
authorunknown <Sinisa@sinisa.nasamreza.org>2002-12-17 22:36:23 +0200
committerunknown <Sinisa@sinisa.nasamreza.org>2002-12-17 22:36:23 +0200
commiteb377d06b60955f544c2b8f1b80d2255bae91061 (patch)
tree6604c63afe11b81d7937be5463754df31cd630fd /mysql-test/t/derived.test
parentf8601aa2c7fff7d3bb2c01517da22123a7761816 (diff)
downloadmariadb-git-eb377d06b60955f544c2b8f1b80d2255bae91061.tar.gz
Fix for fix_fields in derived tables with UNION's ....
Diffstat (limited to 'mysql-test/t/derived.test')
-rw-r--r--mysql-test/t/derived.test4
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/t/derived.test b/mysql-test/t/derived.test
index 8f4ab57d6e5..daa364db931 100644
--- a/mysql-test/t/derived.test
+++ b/mysql-test/t/derived.test
@@ -45,3 +45,7 @@ SELECT * FROM (SELECT (SELECT * FROM (SELECT 1 as a) as a )) as b;
select * from (select 1 as a) b left join (select 2 as a) c using(a);
--error 1054
SELECT * FROM (SELECT 1 UNION SELECT a) b;
+--error 1054
+SELECT 1 as a FROM (SELECT a UNION SELECT 1) b;
+--error 1054
+SELECT 1 as a FROM (SELECT 1 UNION SELECT a) b;