Debian Codegraph @

mysql-test/suite/merge/merge_mmap.result

raw
1 SET GLOBAL default_storage_engine = MyISAM;
2 SET SESSION default_storage_engine = MyISAM;
3 DROP TABLE IF EXISTS t1, t2, m1, m2;
4 CREATE TABLE t1 (c1 INT);
5 CREATE TABLE t2 (c1 INT);
6 CREATE TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
7 INSERT_METHOD=LAST;
8 CREATE TABLE m2 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
9 INSERT_METHOD=LAST;
10 INSERT INTO t1 VALUES (1);
11 INSERT INTO t2 VALUES (2), (3), (4);
12 INSERT INTO m2 SELECT * FROM m1;
13 SELECT * FROM m2;
14 c1
15 1
16 2
17 3
18 4
19 1
20 2
21 3
22 4
23 SELECT * FROM t2;
24 c1
25 2
26 3
27 4
28 1
29 2
30 3
31 4
32 DROP TABLE m2, m1, t2, t1;
33 CREATE TABLE t1 (c1 INT);
34 CREATE TABLE t2 (c1 INT);
35 CREATE TEMPORARY TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
36 INSERT_METHOD=LAST;
37 CREATE TABLE m2 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
38 INSERT_METHOD=LAST;
39 INSERT INTO t1 VALUES (1);
40 INSERT INTO t2 VALUES (2), (3), (4);
41 INSERT INTO m2 SELECT * FROM m1;
42 SELECT * FROM m2;
43 c1
44 1
45 2
46 3
47 4
48 1
49 2
50 3
51 4
52 DROP TABLE m2, m1, t2, t1;
53 CREATE TABLE t1 (c1 INT);
54 CREATE TABLE t2 (c1 INT);
55 CREATE TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
56 INSERT_METHOD=LAST;
57 CREATE TEMPORARY TABLE m2 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
58 INSERT_METHOD=LAST;
59 INSERT INTO t1 VALUES (1);
60 INSERT INTO t2 VALUES (2), (3), (4);
61 INSERT INTO m2 SELECT * FROM m1;
62 SELECT * FROM m2;
63 c1
64 1
65 2
66 3
67 4
68 1
69 2
70 3
71 4
72 DROP TABLE m2, m1, t2, t1;
73 CREATE TABLE t1 (c1 INT);
74 CREATE TABLE t2 (c1 INT);
75 CREATE TEMPORARY TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
76 INSERT_METHOD=LAST;
77 CREATE TEMPORARY TABLE m2 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
78 INSERT_METHOD=LAST;
79 INSERT INTO t1 VALUES (1);
80 INSERT INTO t2 VALUES (2), (3), (4);
81 INSERT INTO m2 SELECT * FROM m1;
82 SELECT * FROM m2;
83 c1
84 1
85 2
86 3
87 4
88 1
89 2
90 3
91 4
92 DROP TABLE m2, m1, t2, t1;
93 CREATE TABLE t1 (c1 INT);
94 CREATE TABLE t2 (c1 INT);
95 CREATE TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
96 INSERT_METHOD=LAST;
97 CREATE TABLE m2 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
98 INSERT_METHOD=LAST;
99 LOCK TABLE m1 WRITE, m2 WRITE;
100 INSERT INTO t1 VALUES (1);
101 INSERT INTO t2 VALUES (2), (3), (4);
102 INSERT INTO m2 SELECT * FROM m1;
103 SELECT * FROM m2;
104 c1
105 1
106 2
107 3
108 4
109 1
110 2
111 3
112 4
113 SELECT * FROM t2;
114 c1
115 2
116 3
117 4
118 1
119 2
120 3
121 4
122 UNLOCK TABLES;
123 DROP TABLE m2, m1, t2, t1;
124 CREATE TABLE t1 (c1 INT);
125 CREATE TABLE t2 (c1 INT);
126 CREATE TEMPORARY TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
127 INSERT_METHOD=LAST;
128 CREATE TABLE m2 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
129 INSERT_METHOD=LAST;
130 LOCK TABLE m1 WRITE, m2 WRITE;
131 INSERT INTO t1 VALUES (1);
132 INSERT INTO t2 VALUES (2), (3), (4);
133 INSERT INTO m2 SELECT * FROM m1;
134 SELECT * FROM m2;
135 c1
136 1
137 2
138 3
139 4
140 1
141 2
142 3
143 4
144 UNLOCK TABLES;
145 DROP TABLE m2, m1, t2, t1;
146 CREATE TABLE t1 (c1 INT);
147 CREATE TABLE t2 (c1 INT);
148 CREATE TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
149 INSERT_METHOD=LAST;
150 CREATE TEMPORARY TABLE m2 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
151 INSERT_METHOD=LAST;
152 LOCK TABLE m1 WRITE, m2 WRITE;
153 INSERT INTO t1 VALUES (1);
154 INSERT INTO t2 VALUES (2), (3), (4);
155 INSERT INTO m2 SELECT * FROM m1;
156 SELECT * FROM m2;
157 c1
158 1
159 2
160 3
161 4
162 1
163 2
164 3
165 4
166 UNLOCK TABLES;
167 DROP TABLE m2, m1, t2, t1;
168 CREATE TABLE t1 (c1 INT);
169 CREATE TABLE t2 (c1 INT);
170 CREATE TEMPORARY TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
171 INSERT_METHOD=LAST;
172 CREATE TEMPORARY TABLE m2 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2)
173 INSERT_METHOD=LAST;
174 LOCK TABLE m1 WRITE, m2 WRITE;
175 INSERT INTO t1 VALUES (1);
176 INSERT INTO t2 VALUES (2), (3), (4);
177 INSERT INTO m2 SELECT * FROM m1;
178 SELECT * FROM m2;
179 c1
180 1
181 2
182 3
183 4
184 1
185 2
186 3
187 4
188 UNLOCK TABLES;
189 DROP TABLE m2, m1, t2, t1;
190 End of 6.0 tests