diff options
Diffstat (limited to 'mysql-test/r/merge_mmap.result')
-rw-r--r-- | mysql-test/r/merge_mmap.result | 190 |
1 files changed, 0 insertions, 190 deletions
diff --git a/mysql-test/r/merge_mmap.result b/mysql-test/r/merge_mmap.result deleted file mode 100644 index e8014259a4a..00000000000 --- a/mysql-test/r/merge_mmap.result +++ /dev/null @@ -1,190 +0,0 @@ -SET GLOBAL storage_engine = MyISAM; -SET SESSION storage_engine = MyISAM; -DROP TABLE IF EXISTS t1, t2, m1, m2; -CREATE TABLE t1 (c1 INT); -CREATE TABLE t2 (c1 INT); -CREATE TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2) -INSERT_METHOD=LAST; -CREATE TABLE m2 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2) -INSERT_METHOD=LAST; -INSERT INTO t1 VALUES (1); -INSERT INTO t2 VALUES (2), (3), (4); -INSERT INTO m2 SELECT * FROM m1; -SELECT * FROM m2; -c1 -1 -2 -3 -4 -1 -2 -3 -4 -SELECT * FROM t2; -c1 -2 -3 -4 -1 -2 -3 -4 -DROP TABLE m2, m1, t2, t1; -CREATE TABLE t1 (c1 INT); -CREATE TABLE t2 (c1 INT); -CREATE TEMPORARY TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2) -INSERT_METHOD=LAST; -CREATE TABLE m2 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2) -INSERT_METHOD=LAST; -INSERT INTO t1 VALUES (1); -INSERT INTO t2 VALUES (2), (3), (4); -INSERT INTO m2 SELECT * FROM m1; -SELECT * FROM m2; -c1 -1 -2 -3 -4 -1 -2 -3 -4 -DROP TABLE m2, m1, t2, t1; -CREATE TABLE t1 (c1 INT); -CREATE TABLE t2 (c1 INT); -CREATE TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2) -INSERT_METHOD=LAST; -CREATE TEMPORARY TABLE m2 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2) -INSERT_METHOD=LAST; -INSERT INTO t1 VALUES (1); -INSERT INTO t2 VALUES (2), (3), (4); -INSERT INTO m2 SELECT * FROM m1; -SELECT * FROM m2; -c1 -1 -2 -3 -4 -1 -2 -3 -4 -DROP TABLE m2, m1, t2, t1; -CREATE TABLE t1 (c1 INT); -CREATE TABLE t2 (c1 INT); -CREATE TEMPORARY TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2) -INSERT_METHOD=LAST; -CREATE TEMPORARY TABLE m2 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2) -INSERT_METHOD=LAST; -INSERT INTO t1 VALUES (1); -INSERT INTO t2 VALUES (2), (3), (4); -INSERT INTO m2 SELECT * FROM m1; -SELECT * FROM m2; -c1 -1 -2 -3 -4 -1 -2 -3 -4 -DROP TABLE m2, m1, t2, t1; -CREATE TABLE t1 (c1 INT); -CREATE TABLE t2 (c1 INT); -CREATE TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2) -INSERT_METHOD=LAST; -CREATE TABLE m2 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2) -INSERT_METHOD=LAST; -LOCK TABLE m1 WRITE, m2 WRITE; -INSERT INTO t1 VALUES (1); -INSERT INTO t2 VALUES (2), (3), (4); -INSERT INTO m2 SELECT * FROM m1; -SELECT * FROM m2; -c1 -1 -2 -3 -4 -1 -2 -3 -4 -SELECT * FROM t2; -c1 -2 -3 -4 -1 -2 -3 -4 -UNLOCK TABLES; -DROP TABLE m2, m1, t2, t1; -CREATE TABLE t1 (c1 INT); -CREATE TABLE t2 (c1 INT); -CREATE TEMPORARY TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2) -INSERT_METHOD=LAST; -CREATE TABLE m2 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2) -INSERT_METHOD=LAST; -LOCK TABLE m1 WRITE, m2 WRITE; -INSERT INTO t1 VALUES (1); -INSERT INTO t2 VALUES (2), (3), (4); -INSERT INTO m2 SELECT * FROM m1; -SELECT * FROM m2; -c1 -1 -2 -3 -4 -1 -2 -3 -4 -UNLOCK TABLES; -DROP TABLE m2, m1, t2, t1; -CREATE TABLE t1 (c1 INT); -CREATE TABLE t2 (c1 INT); -CREATE TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2) -INSERT_METHOD=LAST; -CREATE TEMPORARY TABLE m2 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2) -INSERT_METHOD=LAST; -LOCK TABLE m1 WRITE, m2 WRITE; -INSERT INTO t1 VALUES (1); -INSERT INTO t2 VALUES (2), (3), (4); -INSERT INTO m2 SELECT * FROM m1; -SELECT * FROM m2; -c1 -1 -2 -3 -4 -1 -2 -3 -4 -UNLOCK TABLES; -DROP TABLE m2, m1, t2, t1; -CREATE TABLE t1 (c1 INT); -CREATE TABLE t2 (c1 INT); -CREATE TEMPORARY TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2) -INSERT_METHOD=LAST; -CREATE TEMPORARY TABLE m2 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2) -INSERT_METHOD=LAST; -LOCK TABLE m1 WRITE, m2 WRITE; -INSERT INTO t1 VALUES (1); -INSERT INTO t2 VALUES (2), (3), (4); -INSERT INTO m2 SELECT * FROM m1; -SELECT * FROM m2; -c1 -1 -2 -3 -4 -1 -2 -3 -4 -UNLOCK TABLES; -DROP TABLE m2, m1, t2, t1; -End of 6.0 tests |