diff options
| author | unknown <serg@serg.mylan> | 2004-03-23 14:43:24 +0100 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2004-03-23 14:43:24 +0100 |
| commit | c0a9df1aaedc4a44299398b858021d49ccbfd2ea (patch) | |
| tree | 303d154fcdcdeb732e85c89c418f9b45836d801e /mysql-test/t/union.test | |
| parent | 78b4ba746b79ea7d89044e3eecd56338a8f4eb6f (diff) | |
| download | mariadb-git-c0a9df1aaedc4a44299398b858021d49ccbfd2ea.tar.gz | |
correct support for a mix of UNION/UNION ALL in the same query.
Bug#1428
Diffstat (limited to 'mysql-test/t/union.test')
| -rw-r--r-- | mysql-test/t/union.test | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test index 06110474992..b744610ce3d 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -493,6 +493,7 @@ create table t1 (i int); insert into t1 values (1); select * from t1 UNION select * from t1; select * from t1 UNION ALL select * from t1; -# The following should return 2 lines select * from t1 UNION select * from t1 UNION ALL select * from t1; drop table t1; +select 1 as a union all select 1 union all select 2 union select 1 union all select 2; + |