diff options
| author | unknown <sasha@mysql.sashanet.com> | 2000-12-07 08:24:18 -0700 |
|---|---|---|
| committer | unknown <sasha@mysql.sashanet.com> | 2000-12-07 08:24:18 -0700 |
| commit | af803cc9452f07ab49327e496de91be094f1ef35 (patch) | |
| tree | 4517329dba0196227d0ab67cb180f66a799e3aad /mysql-test/t/mrg000001.test | |
| parent | 02e033434c99266f80449e57fc54555b3c55f87c (diff) | |
| download | mariadb-git-af803cc9452f07ab49327e496de91be094f1ef35.tar.gz | |
mrg000001.dummy.result Rename: mysql-test/r/3.23/mrg000001.dummy.result -> mysql-test/r/mrg000001.dummy.result
mrg000001.result Rename: mysql-test/r/3.23/mrg000001.result -> mysql-test/r/mrg000001.result
mrg000001.test Rename: mysql-test/t/3.23/mrg000001.test -> mysql-test/t/mrg000001.test
mysql-test/t/mrg000001.test:
Rename: mysql-test/t/3.23/mrg000001.test -> mysql-test/t/mrg000001.test
mysql-test/r/mrg000001.dummy.result:
Rename: mysql-test/r/3.23/mrg000001.dummy.result -> mysql-test/r/mrg000001.dummy.result
mysql-test/r/mrg000001.result:
Rename: mysql-test/r/3.23/mrg000001.result -> mysql-test/r/mrg000001.result
Diffstat (limited to 'mysql-test/t/mrg000001.test')
| -rw-r--r-- | mysql-test/t/mrg000001.test | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/t/mrg000001.test b/mysql-test/t/mrg000001.test new file mode 100644 index 00000000000..ded3ecc8898 --- /dev/null +++ b/mysql-test/t/mrg000001.test @@ -0,0 +1,17 @@ +DROP TABLE IF EXISTS test1; +DROP TABLE IF EXISTS test2; +DROP TABLE IF EXISTS test3; + +CREATE TABLE test1 (incr int not null, othr int not null, primary key(incr)); +CREATE TABLE test2 (incr int not null, othr int not null, primary key(incr)); +CREATE TABLE test3 (incr int not null, othr int not null, primary key(incr)) +TYPE=MERGE UNION=(test1,test2); + +@r/3.23/mrg000001.dummy.result SELECT * from test3; + +INSERT INTO test1 VALUES ( 1,10),( 3,53),( 5,21),( 7,12),( 9,17); +INSERT INTO test2 VALUES ( 2,24),( 4,33),( 6,41),( 8,26),( 0,32); +INSERT INTO test1 VALUES (11,20),(13,43),(15,11),(17,22),(19,37); +INSERT INTO test2 VALUES (12,25),(14,31),(16,42),(18,27),(10,30); + +@r/3.23/mrg000001.result SELECT * from test3 where incr in (1,2,3,4) order by othr; |