Debian Codegraph @

mysql-test/suite/stress/r/ddl_innodb.result

raw
1 SET @@session.sql_mode = 'NO_ENGINE_SUBSTITUTION';
2 PREPARE stmt_start FROM "SELECT UNIX_TIMESTAMP() INTO @start";
3 SET @runtime = <intended_runtime>;
4 PREPARE stmt_break FROM "SELECT UNIX_TIMESTAMP() - @start > @runtime - 1";
5 connect con2,localhost,root,,;
6 connection default;
7 DROP TABLE IF EXISTS t1;
8 # Subtest 1A (one connection, no PREPARE/EXECUTE)
9 # connection action
10 # default: CREATE TABLE t1 (f1 BIGINT,f2 BIGINT,UNIQUE(f1),UNIQUE(f2))
11 ENGINE = InnoDB
12 # default: INSERT INTO t1 VALUES (1,1), (2,2), (3,3)
13 # default: DROP TABLE t1
14 # Subtest 1B (one connection, use PREPARE/EXECUTE)
15 # connection action
16 # default: CREATE TABLE t1 (f1 BIGINT,f2 BIGINT,UNIQUE(f1),UNIQUE(f2))
17 ENGINE = InnoDB
18 # default: INSERT INTO t1 VALUES (1,1), (2,2), (3,3)
19 # default: DROP TABLE t1
20 # Subtest 1C (two connections, no PREPARE/EXECUTE)
21 # connection action
22 # default: CREATE TABLE t1 (f1 BIGINT,f2 BIGINT,UNIQUE(f1),UNIQUE(f2))
23 ENGINE = InnoDB
24 # con2: INSERT INTO t1 VALUES (1,1), (2,2), (3,3)
25 # con2: DROP TABLE t1
26 # Subtest 1D (two connections, use PREPARE/EXECUTE)
27 # connection action
28 # default: CREATE TABLE t1 (f1 BIGINT,f2 BIGINT,UNIQUE(f1),UNIQUE(f2))
29 ENGINE = InnoDB
30 # con2: INSERT INTO t1 VALUES (1,1), (2,2), (3,3)
31 # con2: DROP TABLE t1
32 # Subtest 2A (one connection, no PREPARE/EXECUTE)
33 # connection action
34 # default: CREATE TABLE t1 ENGINE = InnoDB AS SELECT 1 AS f1
35 # default: SELECT COUNT(*) <> 1 FROM t1 WHERE f1 = 1
36 # default: DROP TABLE t1
37 # default: SELECT COUNT(*) <> 1 FROM t1 WHERE f1 = 1 (expect to get ER_NO_SUCH_TABLE)
38 # Subtest 2B (one connection, use PREPARE/EXECUTE)
39 # connection action
40 # default: CREATE TABLE t1 ENGINE = InnoDB AS SELECT 1 AS f1
41 # default: SELECT COUNT(*) <> 1 FROM t1 WHERE f1 = 1
42 # default: DROP TABLE t1
43 # default: SELECT COUNT(*) <> 1 FROM t1 WHERE f1 = 1 (expect to get ER_NO_SUCH_TABLE)
44 # Subtest 2C (two connections, no PREPARE/EXECUTE)
45 # connection action
46 # default: CREATE TABLE t1 ENGINE = InnoDB AS SELECT 1 AS f1
47 # con2: SELECT COUNT(*) <> 1 FROM t1 WHERE f1 = 1
48 # default: DROP TABLE t1
49 # con2: SELECT COUNT(*) <> 1 FROM t1 WHERE f1 = 1 (expect to get ER_NO_SUCH_TABLE)
50 # Subtest 2D (two connections, use PREPARE/EXECUTE)
51 # connection action
52 # default: CREATE TABLE t1 ENGINE = InnoDB AS SELECT 1 AS f1
53 # con2: SELECT COUNT(*) <> 1 FROM t1 WHERE f1 = 1
54 # default: DROP TABLE t1
55 # con2: SELECT COUNT(*) <> 1 FROM t1 WHERE f1 = 1 (expect to get ER_NO_SUCH_TABLE)
56 # Subtest 3A (one connection, no PREPARE/EXECUTE)
57 # connection action
58 # default: CREATE TABLE t1 (f1 BIGINT NOT NULL) ENGINE=InnoDB
59 # default: CREATE TABLE t1 (f1 BIGINT NOT NULL) ENGINE=InnoDB (expect to get ER_TABLE_EXISTS_ERROR)
60 # default: DROP TABLE t1
61 # default: DROP TABLE t1 (expect to get ER_BAD_TABLE_ERROR)
62 # Subtest 3B (one connection, use PREPARE/EXECUTE)
63 # connection action
64 # default: CREATE TABLE t1 (f1 BIGINT NOT NULL) ENGINE=InnoDB
65 # default: CREATE TABLE t1 (f1 BIGINT NOT NULL) ENGINE=InnoDB (expect to get ER_TABLE_EXISTS_ERROR)
66 # default: DROP TABLE t1
67 # default: DROP TABLE t1 (expect to get ER_BAD_TABLE_ERROR)
68 # Subtest 3C (two connections, no PREPARE/EXECUTE)
69 # connection action
70 # default: CREATE TABLE t1 (f1 BIGINT NOT NULL) ENGINE=InnoDB
71 # con2: CREATE TABLE t1 (f1 BIGINT NOT NULL) ENGINE=InnoDB (expect to get ER_TABLE_EXISTS_ERROR)
72 # default: DROP TABLE t1
73 # con2: DROP TABLE t1 (expect to get ER_BAD_TABLE_ERROR)
74 # Subtest 3D (two connections, use PREPARE/EXECUTE)
75 # connection action
76 # default: CREATE TABLE t1 (f1 BIGINT NOT NULL) ENGINE=InnoDB
77 # con2: CREATE TABLE t1 (f1 BIGINT NOT NULL) ENGINE=InnoDB (expect to get ER_TABLE_EXISTS_ERROR)
78 # default: DROP TABLE t1
79 # con2: DROP TABLE t1 (expect to get ER_BAD_TABLE_ERROR)
80 CREATE TABLE t1 (f1 BIGINT, f2 BIGINT, UNIQUE(f1), UNIQUE (f2)) ENGINE=InnoDB;
81 DROP TABLE t1;
82 CREATE TABLE t1 (f1 BIGINT) ENGINE=InnoDB;
83 DROP TABLE t1;
84 # Subtest 4A (one connection, no PREPARE/EXECUTE)
85 # connection action
86 # default: CREATE TABLE t1 (f1 BIGINT, f2 BIGINT, UNIQUE(f1), UNIQUE (f2)) ENGINE=InnoDB
87 # default: SHOW CREATE TABLE t1
88 # default: DROP TABLE t1
89 # default: SHOW CREATE TABLE t1 (expect to get ER_NO_SUCH_TABLE)
90 # default: CREATE TABLE t1 (f1 BIGINT) ENGINE=InnoDB
91 # default: SHOW CREATE TABLE t1
92 # default: DROP TABLE t1
93 # Subtest 4B (one connection, use PREPARE/EXECUTE)
94 # connection action
95 # default: CREATE TABLE t1 (f1 BIGINT, f2 BIGINT, UNIQUE(f1), UNIQUE (f2)) ENGINE=InnoDB
96 # default: SHOW CREATE TABLE t1
97 # default: DROP TABLE t1
98 # default: SHOW CREATE TABLE t1 (expect to get ER_NO_SUCH_TABLE)
99 # default: CREATE TABLE t1 (f1 BIGINT) ENGINE=InnoDB
100 # default: SHOW CREATE TABLE t1
101 # default: DROP TABLE t1
102 # Subtest 4C (two connections, no PREPARE/EXECUTE)
103 # connection action
104 # default: CREATE TABLE t1 (f1 BIGINT, f2 BIGINT, UNIQUE(f1), UNIQUE (f2)) ENGINE=InnoDB
105 # con2: SHOW CREATE TABLE t1
106 # default: DROP TABLE t1
107 # con2: SHOW CREATE TABLE t1 (expect to get ER_NO_SUCH_TABLE)
108 # default: CREATE TABLE t1 (f1 BIGINT) ENGINE=InnoDB
109 # con2: SHOW CREATE TABLE t1
110 # default: DROP TABLE t1
111 # Subtest 4D (two connections, use PREPARE/EXECUTE)
112 # connection action
113 # default: CREATE TABLE t1 (f1 BIGINT, f2 BIGINT, UNIQUE(f1), UNIQUE (f2)) ENGINE=InnoDB
114 # con2: SHOW CREATE TABLE t1
115 # default: DROP TABLE t1
116 # con2: SHOW CREATE TABLE t1 (expect to get ER_NO_SUCH_TABLE)
117 # default: CREATE TABLE t1 (f1 BIGINT) ENGINE=InnoDB
118 # con2: SHOW CREATE TABLE t1
119 # default: DROP TABLE t1
120 # Subtest 5A (one connection, no PREPARE/EXECUTE)
121 # connection action
122 # default: CREATE TABLE t1 (f1 MEDIUMINT NOT NULL AUTO_INCREMENT,f2 BIGINT, UNIQUE(f1)) ENGINE = InnoDB
123 # default: INSERT INTO t1 SET f2 = 9
124 # default: SELECT f1 <> 1 OR f1 IS NULL FROM t1 WHERE f2 = 9
125 # default: DROP TABLE t1
126 # Subtest 5B (one connection, use PREPARE/EXECUTE)
127 # connection action
128 # default: CREATE TABLE t1 (f1 MEDIUMINT NOT NULL AUTO_INCREMENT,f2 BIGINT, UNIQUE(f1)) ENGINE = InnoDB
129 # default: INSERT INTO t1 SET f2 = 9
130 # default: SELECT f1 <> 1 OR f1 IS NULL FROM t1 WHERE f2 = 9
131 # default: DROP TABLE t1
132 # Subtest 5C (two connections, no PREPARE/EXECUTE)
133 # connection action
134 # default: CREATE TABLE t1 (f1 MEDIUMINT NOT NULL AUTO_INCREMENT,f2 BIGINT, UNIQUE(f1)) ENGINE = InnoDB
135 # con2: INSERT INTO t1 SET f2 = 9
136 # default: SELECT f1 <> 1 OR f1 IS NULL FROM t1 WHERE f2 = 9
137 # con2: DROP TABLE t1
138 # Subtest 5D (two connections, use PREPARE/EXECUTE)
139 # connection action
140 # default: CREATE TABLE t1 (f1 MEDIUMINT NOT NULL AUTO_INCREMENT,f2 BIGINT, UNIQUE(f1)) ENGINE = InnoDB
141 # con2: INSERT INTO t1 SET f2 = 9
142 # default: SELECT f1 <> 1 OR f1 IS NULL FROM t1 WHERE f2 = 9
143 # con2: DROP TABLE t1
144 CREATE TABLE t1 (f1 BIGINT, f2 BIGINT, UNIQUE(f1)) ENGINE=InnoDB;
145 # Subtest 6A (one connection, no PREPARE/EXECUTE)
146 # connection action
147 # default: CREATE INDEX IDX1 ON t1 (f2)
148 # default: CREATE INDEX IDX1 ON t1 (f2) (expect to get ER_DUP_KEYNAME)
149 # default: DROP INDEX IDX1 ON t1
150 # default: DROP INDEX IDX1 ON t1 (expect to get ER_CANT_DROP_FIELD_OR_KEY)
151 # default: CREATE INDEX IDX1 ON t1 (f2)
152 # default: DROP INDEX IDX1 ON t1
153 # Subtest 6B (one connection, use PREPARE/EXECUTE)
154 # connection action
155 # default: CREATE INDEX IDX1 ON t1 (f2)
156 # default: CREATE INDEX IDX1 ON t1 (f2) (expect to get ER_DUP_KEYNAME)
157 # default: DROP INDEX IDX1 ON t1
158 # default: DROP INDEX IDX1 ON t1 (expect to get ER_CANT_DROP_FIELD_OR_KEY)
159 # default: CREATE INDEX IDX1 ON t1 (f2)
160 # default: DROP INDEX IDX1 ON t1
161 # Subtest 6C (two connections, no PREPARE/EXECUTE)
162 # connection action
163 # default: CREATE INDEX IDX1 ON t1 (f2)
164 # con2: CREATE INDEX IDX1 ON t1 (f2) (expect to get ER_DUP_KEYNAME)
165 # default: DROP INDEX IDX1 ON t1
166 # con2: DROP INDEX IDX1 ON t1 (expect to get ER_CANT_DROP_FIELD_OR_KEY)
167 # default: CREATE INDEX IDX1 ON t1 (f2)
168 # con2: DROP INDEX IDX1 ON t1
169 # Subtest 6D (two connections, use PREPARE/EXECUTE)
170 # connection action
171 # default: CREATE INDEX IDX1 ON t1 (f2)
172 # con2: CREATE INDEX IDX1 ON t1 (f2) (expect to get ER_DUP_KEYNAME)
173 # default: DROP INDEX IDX1 ON t1
174 # con2: DROP INDEX IDX1 ON t1 (expect to get ER_CANT_DROP_FIELD_OR_KEY)
175 # default: CREATE INDEX IDX1 ON t1 (f2)
176 # con2: DROP INDEX IDX1 ON t1
177 DROP TABLE t1;
178 CREATE TABLE t1 (f1 BIGINT, f2 BIGINT, PRIMARY KEY(f1)) ENGINE=InnoDB;
179 INSERT INTO t1 VALUES(0,1);
180 # Subtest 7A (one connection, no PREPARE/EXECUTE)
181 # connection action
182 # default: CREATE UNIQUE INDEX IDX1 ON t1 (f2)
183 # default: INSERT INTO t1 VALUES(1,1) (expect to get ER_DUP_ENTRY)
184 # default: DROP INDEX IDX1 ON t1
185 # default: INSERT INTO t1 VALUES(1,1)
186 # default: CREATE UNIQUE INDEX IDX1 ON t1 (f2) (expect to get ER_DUP_ENTRY)
187 # default: DELETE FROM t1 WHERE f1 = 1
188 # Subtest 7B (one connection, use PREPARE/EXECUTE)
189 # connection action
190 # default: CREATE UNIQUE INDEX IDX1 ON t1 (f2)
191 # default: INSERT INTO t1 VALUES(1,1) (expect to get ER_DUP_ENTRY)
192 # default: DROP INDEX IDX1 ON t1
193 # default: INSERT INTO t1 VALUES(1,1)
194 # default: CREATE UNIQUE INDEX IDX1 ON t1 (f2) (expect to get ER_DUP_ENTRY)
195 # default: DELETE FROM t1 WHERE f1 = 1
196 # Subtest 7C (two connections, no PREPARE/EXECUTE)
197 # connection action
198 # default: CREATE UNIQUE INDEX IDX1 ON t1 (f2)
199 # default: INSERT INTO t1 VALUES(1,1) (expect to get ER_DUP_ENTRY)
200 # con2: DROP INDEX IDX1 ON t1
201 # default: INSERT INTO t1 VALUES(1,1)
202 # con2: CREATE UNIQUE INDEX IDX1 ON t1 (f2) (expect to get ER_DUP_ENTRY)
203 # con2: DELETE FROM t1 WHERE f1 = 1
204 # Subtest 7D (two connections, use PREPARE/EXECUTE)
205 # connection action
206 # default: CREATE UNIQUE INDEX IDX1 ON t1 (f2)
207 # default: INSERT INTO t1 VALUES(1,1) (expect to get ER_DUP_ENTRY)
208 # con2: DROP INDEX IDX1 ON t1
209 # default: INSERT INTO t1 VALUES(1,1)
210 # con2: CREATE UNIQUE INDEX IDX1 ON t1 (f2) (expect to get ER_DUP_ENTRY)
211 # con2: DELETE FROM t1 WHERE f1 = 1
212 DROP TABLE t1;
213 CREATE TABLE t1 (f1 BIGINT, f2 BIGINT, UNIQUE(f1)) ENGINE=InnoDB;
214 INSERT INTO t1 VALUES(1,1);
215 CREATE INDEX IDX ON t1 (f2);
216 DROP INDEX IDX ON t1;
217 CREATE UNIQUE INDEX IDX ON t1 (f2);
218 DROP INDEX IDX ON t1;
219 # Subtest 8A (one connection, no PREPARE/EXECUTE)
220 # connection action
221 # default: CREATE INDEX IDX ON t1 (f2)
222 # default: SHOW CREATE TABLE t1
223 # default: DROP INDEX IDX ON t1
224 # default: CREATE UNIQUE INDEX IDX ON t1 (f2)
225 # default: SHOW CREATE TABLE t1
226 # default: DROP INDEX IDX ON t1
227 # Subtest 8B (one connection, use PREPARE/EXECUTE)
228 # connection action
229 # default: CREATE INDEX IDX ON t1 (f2)
230 # default: SHOW CREATE TABLE t1
231 # default: DROP INDEX IDX ON t1
232 # default: CREATE UNIQUE INDEX IDX ON t1 (f2)
233 # default: SHOW CREATE TABLE t1
234 # default: DROP INDEX IDX ON t1
235 # Subtest 8C (two connections, no PREPARE/EXECUTE)
236 # connection action
237 # default: CREATE INDEX IDX ON t1 (f2)
238 # con2: SHOW CREATE TABLE t1
239 # default: DROP INDEX IDX ON t1
240 # default: CREATE UNIQUE INDEX IDX ON t1 (f2)
241 # con2: SHOW CREATE TABLE t1
242 # default: DROP INDEX IDX ON t1
243 # Subtest 8D (two connections, use PREPARE/EXECUTE)
244 # connection action
245 # default: CREATE INDEX IDX ON t1 (f2)
246 # con2: SHOW CREATE TABLE t1
247 # default: DROP INDEX IDX ON t1
248 # default: CREATE UNIQUE INDEX IDX ON t1 (f2)
249 # con2: SHOW CREATE TABLE t1
250 # default: DROP INDEX IDX ON t1
251 DROP TABLE t1;
252 disconnect con2;
253 DEALLOCATE PREPARE stmt_start;
254 DEALLOCATE PREPARE stmt_break;