summaryrefslogtreecommitdiff
path: root/mysql-test/t/union.test
diff options
context:
space:
mode:
authoracurtis@pcgem.rdg.cyberkinetica.com <>2005-02-13 22:35:52 +0000
committeracurtis@pcgem.rdg.cyberkinetica.com <>2005-02-13 22:35:52 +0000
commit4957c4850d34dfd3b66d7e8c130e321d33bf15ab (patch)
tree8166a91c79593f9015c764e76b75588c02f949ff /mysql-test/t/union.test
parent961d8b0ebf427ff4a3a4d2f32c06579198642303 (diff)
downloadmariadb-git-4957c4850d34dfd3b66d7e8c130e321d33bf15ab.tar.gz
Bug#2435
Alter handling for UNION syntax Tests for UNION and parentheses
Diffstat (limited to 'mysql-test/t/union.test')
-rw-r--r--mysql-test/t/union.test12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test
index 90b2197603b..82f26f63254 100644
--- a/mysql-test/t/union.test
+++ b/mysql-test/t/union.test
@@ -699,3 +699,15 @@ union
order by sdate;
show columns from t4;
drop table t1, t2, t3, t4;
+
+#
+# Bug #2435 UNION with parentheses not supported
+#
+create table t1 (a int not null, b char (10) not null);
+insert into t1 values(1,'a'),(2,'b'),(3,'c'),(3,'c');
+select * from ((select * from t1 limit 1)) a;
+select * from ((select * from t1 limit 1) union (select * from t1 limit 1)) a;
+select * from ((select * from t1 limit 1) union (select * from t1 limit 1) union (select * from t1 limit 1)) a;
+select * from ((((select * from t1))) union (select * from t1) union (select * from t1)) a;
+select * from ((select * from t1) union (((select * from t1))) union (select * from t1)) a;
+drop table t1;