diff options
Diffstat (limited to 'mysql-test/t/union.test')
| -rw-r--r-- | mysql-test/t/union.test | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test index 5c4a62d5c41..dc7e036e258 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -16,6 +16,9 @@ select 0,'#' union select a,b from t1 union all select a,b from t2 union select select a,b from t1 union select a,b from t1; select 't1',b,count(*) from t1 group by b UNION select 't2',b,count(*) from t2 group by b; +#test alternate syntax for unions +(select a,b from t1 limit 2) union all (select a,b from t2 order by a) limit 4; + # Test some error conditions with UNION explain select a,b from t1 union all select a,b from t2; |