diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2002-03-19 14:07:52 +0200 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2002-03-19 14:07:52 +0200 |
| commit | 7fc36355bc9b3678109b53209b84fe718da498ce (patch) | |
| tree | 767475bf73bc5e960912ea2923dda9f65b5cebf6 /mysql-test/t | |
| parent | ef38d5c3a9b393abe5276a64e5137a5be025264a (diff) | |
| download | mariadb-git-7fc36355bc9b3678109b53209b84fe718da498ce.tar.gz | |
fix for the limit bug in UNION's and some additional syntax
checkings
mysql-test/r/union.result:
fix for the limit bug in UNION's
mysql-test/t/union.test:
fix for the limit bug in UNION's
sql/sql_union.cc:
fix for the limit bug in UNION's
sql/sql_yacc.yy:
Syntax checking for options that should appear in main select only.
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/union.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test index f782c61d97a..f648ebfd48c 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -77,3 +77,11 @@ SELECT pseudo1 FROM t1 WHERE pseudo='joce' UNION SELECT pseudo FROM t1 WHERE pse SELECT pseudo1 FROM t1 WHERE pseudo='joce' UNION ALL SELECT pseudo FROM t1 WHERE pseudo1='joce'; SELECT pseudo1 FROM t1 WHERE pseudo='joce' UNION SELECT 1; drop table t1; +drop table if exists t1,t2; +create table t1 (a int); +create table t2 (a int); +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); +drop table t1,t2; |