diff options
| author | Sinisa@sinisa.nasamreza.org <> | 2003-07-02 01:24:05 +0300 |
|---|---|---|
| committer | Sinisa@sinisa.nasamreza.org <> | 2003-07-02 01:24:05 +0300 |
| commit | fb39821e94b7f921000a40c42efdcdb8c4f28d6d (patch) | |
| tree | 184e63c12f9a193dd78b7bc697ff5ea96bb66fcc /mysql-test/t/union.test | |
| parent | b7644c92121946ecbfd747e2ecb9963073f048bf (diff) | |
| download | mariadb-git-fb39821e94b7f921000a40c42efdcdb8c4f28d6d.tar.gz | |
Some fixes for CREATE / INSERT FROM UNIO >..
Diffstat (limited to 'mysql-test/t/union.test')
| -rw-r--r-- | mysql-test/t/union.test | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test index 5f7eba83755..dcf2f79e5bf 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -164,9 +164,9 @@ insert into t1 values(1,'a'),(2,'b'),(3,'c'),(3,'c'); CREATE TABLE t2 (a int not null, b char (10) not null); insert into t2 values (3,'c'),(4,'d'),(5,'f'),(6,'e'); create table t3 select a,b from t1 union select a,b from t2; -create table t4 (select a,b from t1) union (select a,b from t2) limit 2; +create table t4 (select a,b from t1) union (select a,b from t2); insert into t4 select a,b from t1 union select a,b from t2; -insert into t3 (select a,b from t1) union (select a,b from t2) limit 2; +insert into t3 (select a,b from t1) union (select a,b from t2); select * from t3; select * from t4; drop table t1,t2,t3,t4; |