Debian Codegraph @

mysql-test/suite/merge/merge_mmap.test

raw
1 #
2 # Test of MERGE TABLES with MyISAM memory mapping enabled (--myisam-use-mmap)
3 #
4
5 # MERGE tables require MyISAM tables
6 --let $default=`SELECT @@global.default_storage_engine`
7 SET GLOBAL default_storage_engine = MyISAM;
8 SET SESSION default_storage_engine = MyISAM;
9
10 # Clean up resources used in this test case.
11 --disable_warnings
12 DROP TABLE IF EXISTS t1, t2, m1, m2;
13 --enable_warnings
14
15 ####################
16 ## No locked tables.
17 ####################
18 #
19 # INSERT-SELECT with no TEMPORARY table.
20 #
21 CREATE TABLE t1 (c1 INT);
22 CREATE TABLE t2 (c1 INT);
23 CREATE TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
24 INSERT_METHOD=LAST;
25 CREATE TABLE m2 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
26 INSERT_METHOD=LAST;
27 INSERT INTO t1 VALUES (1);
28 INSERT INTO t2 VALUES (2), (3), (4);
29 INSERT INTO m2 SELECT * FROM m1;
30 SELECT * FROM m2;
31 SELECT * FROM t2;
32 DROP TABLE m2, m1, t2, t1;
33 #
34 # INSERT-SELECT with TEMPORARY select table.
35 #
36 CREATE TABLE t1 (c1 INT);
37 CREATE TABLE t2 (c1 INT);
38 CREATE TEMPORARY TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
39 INSERT_METHOD=LAST;
40 CREATE TABLE m2 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
41 INSERT_METHOD=LAST;
42 INSERT INTO t1 VALUES (1);
43 INSERT INTO t2 VALUES (2), (3), (4);
44 INSERT INTO m2 SELECT * FROM m1;
45 SELECT * FROM m2;
46 DROP TABLE m2, m1, t2, t1;
47 #
48 # INSERT-SELECT with TEMPORARY insert table.
49 #
50 CREATE TABLE t1 (c1 INT);
51 CREATE TABLE t2 (c1 INT);
52 CREATE TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
53 INSERT_METHOD=LAST;
54 CREATE TEMPORARY TABLE m2 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
55 INSERT_METHOD=LAST;
56 INSERT INTO t1 VALUES (1);
57 INSERT INTO t2 VALUES (2), (3), (4);
58 INSERT INTO m2 SELECT * FROM m1;
59 SELECT * FROM m2;
60 DROP TABLE m2, m1, t2, t1;
61 #
62 # INSERT-SELECT with TEMPORARY both tables.
63 #
64 CREATE TABLE t1 (c1 INT);
65 CREATE TABLE t2 (c1 INT);
66 CREATE TEMPORARY TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
67 INSERT_METHOD=LAST;
68 CREATE TEMPORARY TABLE m2 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
69 INSERT_METHOD=LAST;
70 INSERT INTO t1 VALUES (1);
71 INSERT INTO t2 VALUES (2), (3), (4);
72 INSERT INTO m2 SELECT * FROM m1;
73 SELECT * FROM m2;
74 DROP TABLE m2, m1, t2, t1;
75
76 ####################
77 ## With LOCK TABLES.
78 ####################
79 #
80 # INSERT-SELECT with no TEMPORARY table.
81 #
82 --disable_service_connection
83 CREATE TABLE t1 (c1 INT);
84 CREATE TABLE t2 (c1 INT);
85 CREATE TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
86 INSERT_METHOD=LAST;
87 CREATE TABLE m2 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
88 INSERT_METHOD=LAST;
89 LOCK TABLE m1 WRITE, m2 WRITE;
90 INSERT INTO t1 VALUES (1);
91 INSERT INTO t2 VALUES (2), (3), (4);
92 INSERT INTO m2 SELECT * FROM m1;
93 SELECT * FROM m2;
94 SELECT * FROM t2;
95 UNLOCK TABLES;
96 DROP TABLE m2, m1, t2, t1;
97 #
98 # INSERT-SELECT with TEMPORARY select table.
99 #
100 CREATE TABLE t1 (c1 INT);
101 CREATE TABLE t2 (c1 INT);
102 CREATE TEMPORARY TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
103 INSERT_METHOD=LAST;
104 CREATE TABLE m2 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
105 INSERT_METHOD=LAST;
106 LOCK TABLE m1 WRITE, m2 WRITE;
107 INSERT INTO t1 VALUES (1);
108 INSERT INTO t2 VALUES (2), (3), (4);
109 INSERT INTO m2 SELECT * FROM m1;
110 SELECT * FROM m2;
111 UNLOCK TABLES;
112 DROP TABLE m2, m1, t2, t1;
113 #
114 # INSERT-SELECT with TEMPORARY insert table.
115 #
116 CREATE TABLE t1 (c1 INT);
117 CREATE TABLE t2 (c1 INT);
118 CREATE TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
119 INSERT_METHOD=LAST;
120 CREATE TEMPORARY TABLE m2 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
121 INSERT_METHOD=LAST;
122 LOCK TABLE m1 WRITE, m2 WRITE;
123 INSERT INTO t1 VALUES (1);
124 INSERT INTO t2 VALUES (2), (3), (4);
125 INSERT INTO m2 SELECT * FROM m1;
126 SELECT * FROM m2;
127 UNLOCK TABLES;
128 DROP TABLE m2, m1, t2, t1;
129 #
130 # INSERT-SELECT with TEMPORARY both tables.
131 #
132 CREATE TABLE t1 (c1 INT);
133 CREATE TABLE t2 (c1 INT);
134 CREATE TEMPORARY TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
135 INSERT_METHOD=LAST;
136 CREATE TEMPORARY TABLE m2 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
137 INSERT_METHOD=LAST;
138 LOCK TABLE m1 WRITE, m2 WRITE;
139 INSERT INTO t1 VALUES (1);
140 INSERT INTO t2 VALUES (2), (3), (4);
141 INSERT INTO m2 SELECT * FROM m1;
142 SELECT * FROM m2;
143 UNLOCK TABLES;
144 DROP TABLE m2, m1, t2, t1;
145 --enable_service_connection
146
147 --echo End of 6.0 tests
148
149 --disable_result_log
150 --disable_query_log
151 eval SET GLOBAL default_storage_engine = $default;
152 --enable_result_log
153 --enable_query_log