diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2003-07-02 01:24:05 +0300 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2003-07-02 01:24:05 +0300 |
| commit | 1c0ea4db5060ece61ee54118185dfefb5c8d1127 (patch) | |
| tree | 184e63c12f9a193dd78b7bc697ff5ea96bb66fcc /mysql-test/t/union.test | |
| parent | 1e4b46ba0c277d9d28a81d5744400f73901fade7 (diff) | |
| download | mariadb-git-1c0ea4db5060ece61ee54118185dfefb5c8d1127.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; |