diff options
| author | monty@hundin.mysql.fi <> | 2001-12-13 02:31:19 +0200 |
|---|---|---|
| committer | monty@hundin.mysql.fi <> | 2001-12-13 02:31:19 +0200 |
| commit | 87fd219d67dc6a0630e882d4be6ced589bd3f0f6 (patch) | |
| tree | 47a4c1a60e94a3e70ea5564124a296f7cd71605e /mysql-test/t/union.test | |
| parent | 8bef3771f4bf0880e0bbb2f4f526903f8e72082c (diff) | |
| download | mariadb-git-87fd219d67dc6a0630e882d4be6ced589bd3f0f6.tar.gz | |
Fixed sleep time in mysql-test-run
Fixed bug in query cache.
Cleaned up des_crypt code.
Diffstat (limited to 'mysql-test/t/union.test')
| -rw-r--r-- | mysql-test/t/union.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test index 0d391f6f37b..8d98e6e0389 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -18,6 +18,8 @@ select 't1',b,count(*) from t1 group by b UNION select 't2',b,count(*) from t2 g #test alternate syntax for unions (select a,b from t1 limit 2) union all (select a,b from t2 order by a) limit 4; +(select a,b from t1 limit 2) union all (select a,b from t2 order by a limit 1); +(select a,b from t1 limit 2) union all (select a,b from t2 order by a limit 1) order by b desc; # Test some error conditions with UNION explain select a,b from t1 union all select a,b from t2; |