diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2004-05-03 19:15:26 +0300 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2004-05-03 19:15:26 +0300 |
| commit | 19c91b79203ebaa1f5ac557bf3684d1f48c0a90e (patch) | |
| tree | fe523909dc9847c894ba088b73e2c731d8a7ae18 /mysql-test/t/union.test | |
| parent | 4bde9b834af10823f5d13f2c22c571e318474277 (diff) | |
| download | mariadb-git-19c91b79203ebaa1f5ac557bf3684d1f48c0a90e.tar.gz | |
Fix for a bug involving UNION's and SET SQL_SELECT_LIMIT
mysql-test/r/union.result:
Results for a test case for bug involving UNION's and
SET SQL_SELECT_LIMIT
mysql-test/t/union.test:
Test case for bug involving UNION's and
SET SQL_SELECT_LIMIT
sql/sql_union.cc:
Patch for a bug involving UNION's and SET SQL_SELECT_LIMIT
Diffstat (limited to 'mysql-test/t/union.test')
| -rw-r--r-- | mysql-test/t/union.test | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test index 9866b867427..6b76ceea65a 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -498,4 +498,8 @@ select * from t1 UNION ALL select * from t1; 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; +set sql_select_limit=1; +select 1 union select 2; +(select 1) union (select 2); +(select 1) union (select 2) union (select 3) limit 2; |