diff options
| author | Sinisa@sinisa.nasamreza.org <> | 2002-03-19 14:23:11 +0200 |
|---|---|---|
| committer | Sinisa@sinisa.nasamreza.org <> | 2002-03-19 14:23:11 +0200 |
| commit | b226bad64aae0ccaba22f507a7011e7b2fee11c7 (patch) | |
| tree | 2e1df94f212f8dfa95332622cf43ae67760bbbfd /mysql-test/t | |
| parent | d8b085b92bb0ef4b76eecda8604157227030144f (diff) | |
| download | mariadb-git-b226bad64aae0ccaba22f507a7011e7b2fee11c7.tar.gz | |
Some changes from 4.0.
Take a look their for details
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; |