summaryrefslogtreecommitdiff
path: root/mysql-test/r/merge_mmap.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/merge_mmap.result')
-rw-r--r--mysql-test/r/merge_mmap.result190
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