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