diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2002-03-22 13:26:13 +0200 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2002-03-22 13:26:13 +0200 |
| commit | f34e7d709b4126b7d0bc41e07873ffc0b47d3e56 (patch) | |
| tree | f22df3327341cfcd016876fcdc66c1ddd6e22036 /mysql-test | |
| parent | d62d98de7c0a930e27889885351cdf2591f146f9 (diff) | |
| download | mariadb-git-f34e7d709b4126b7d0bc41e07873ffc0b47d3e56.tar.gz | |
Fixes for offset bug in UNION's and making UNION's obey
SELECT_DEFAULT_LIMIT
Docs/manual.texi:
Monty forced me to do this
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/union.result | 10 | ||||
| -rw-r--r-- | mysql-test/t/union.test | 4 |
2 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/union.result b/mysql-test/r/union.result index 113f6680167..ef82b414420 100644 --- a/mysql-test/r/union.result +++ b/mysql-test/r/union.result @@ -177,4 +177,14 @@ a 11 12 13 +(select * from t1 limit 2) union (select * from t2 limit 20,3); +a +1 +2 +set SQL_SELECT_LIMIT=2; +(select * from t1 limit 2) union (select * from t2 limit 3); +a +1 +2 +set SQL_SELECT_LIMIT=DEFAULT; drop table t1,t2; diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test index f648ebfd48c..086351e9da1 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -84,4 +84,8 @@ insert into t1 values (1),(2),(3),(4),(5); insert into t2 values (11),(12),(13),(14),(15); (select * from t1 limit 2) union (select * from t2 limit 3) limit 4; (select * from t1 limit 2) union (select * from t2 limit 3); +(select * from t1 limit 2) union (select * from t2 limit 20,3); +set SQL_SELECT_LIMIT=2; +(select * from t1 limit 2) union (select * from t2 limit 3); +set SQL_SELECT_LIMIT=DEFAULT; drop table t1,t2; |