Debian Codegraph @

mysql-test/suite/innodb/r/temporary_table.result

raw
1 # files in MYSQL_DATA_DIR
2 ibtmp1
3 create temporary table t1 (i int, f float, c char(100)) engine=innodb;
4 insert into t1 values (100, 1.1, 'pune');
5 insert into t1 values (99, 1.2, 'mumbai');
6 insert into t1 values (98, 1.3, 'jaipur');
7 insert into t1 values (97, 1.4, 'delhi');
8 insert into t1 values (96, 1.5, 'ahmedabad');
9 select * from t1;
10 i f c
11 100 1.1 pune
12 99 1.2 mumbai
13 98 1.3 jaipur
14 97 1.4 delhi
15 96 1.5 ahmedabad
16 select * from t1 where i = 98;
17 i f c
18 98 1.3 jaipur
19 select * from t1 where i < 100;
20 i f c
21 99 1.2 mumbai
22 98 1.3 jaipur
23 97 1.4 delhi
24 96 1.5 ahmedabad
25 explain select * from t1 where f > 1.29999;
26 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
27 1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 5 33.33 Using where
28 Warnings:
29 Note 1003 /* select#1 */ select `test`.`t1`.`i` AS `i`,`test`.`t1`.`f` AS `f`,`test`.`t1`.`c` AS `c` from `test`.`t1` where (`test`.`t1`.`f` > 1.29999)
30 alter table t1 add index sec_index(f);
31 explain select * from t1 where f > 1.29999;
32 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
33 1 SIMPLE t1 NULL range sec_index sec_index 5 NULL 3 100.00 Using index condition
34 Warnings:
35 Note 1003 /* select#1 */ select `test`.`t1`.`i` AS `i`,`test`.`t1`.`f` AS `f`,`test`.`t1`.`c` AS `c` from `test`.`t1` where (`test`.`t1`.`f` > 1.29999)
36 select * from t1 where f > 1.29999;
37 i f c
38 98 1.3 jaipur
39 97 1.4 delhi
40 96 1.5 ahmedabad
41 explain select * from t1 where i = 100;
42 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
43 1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 5 20.00 Using where
44 Warnings:
45 Note 1003 /* select#1 */ select `test`.`t1`.`i` AS `i`,`test`.`t1`.`f` AS `f`,`test`.`t1`.`c` AS `c` from `test`.`t1` where (`test`.`t1`.`i` = 100)
46 alter table t1 add unique index pri_index(i);
47 explain select * from t1 where i = 100;
48 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
49 1 SIMPLE t1 NULL const pri_index pri_index 5 const 1 100.00 NULL
50 Warnings:
51 Note 1003 /* select#1 */ select '100' AS `i`,'1.1' AS `f`,'pune' AS `c` from `test`.`t1` where true
52 select * from t1 where i = 100;
53 i f c
54 100 1.1 pune
55 delete from t1 where i < 97;
56 select * from t1;
57 i f c
58 100 1.1 pune
59 99 1.2 mumbai
60 98 1.3 jaipur
61 97 1.4 delhi
62 insert into t1 values (96, 1.5, 'kolkata');
63 select * from t1;
64 i f c
65 100 1.1 pune
66 99 1.2 mumbai
67 98 1.3 jaipur
68 97 1.4 delhi
69 96 1.5 kolkata
70 update t1 set f = 1.44 where c = 'delhi';
71 select * from t1;
72 i f c
73 100 1.1 pune
74 99 1.2 mumbai
75 98 1.3 jaipur
76 97 1.44 delhi
77 96 1.5 kolkata
78 truncate table t1;
79 insert into t1 values (100, 1.1, 'pune');
80 insert into t1 values (99, 1.2, 'mumbai');
81 insert into t1 values (98, 1.3, 'jaipur');
82 insert into t1 values (97, 1.4, 'delhi');
83 insert into t1 values (96, 1.5, 'ahmedabad');
84 select * from t1;
85 i f c
86 100 1.1 pune
87 99 1.2 mumbai
88 98 1.3 jaipur
89 97 1.4 delhi
90 96 1.5 ahmedabad
91 alter table t1 discard tablespace;
92 ERROR HY000: Cannot DISCARD/IMPORT tablespace associated with temporary table
93 alter table t1 import tablespace;
94 ERROR HY000: Cannot DISCARD/IMPORT tablespace associated with temporary table
95 drop table t1;
96 create temporary table t1
97 (i int, f float, c char(100)) engine = innodb row_format=dynamic;
98 show create table t1;
99 Table Create Table
100 t1 CREATE TEMPORARY TABLE `t1` (
101 `i` int DEFAULT NULL,
102 `f` float DEFAULT NULL,
103 `c` char(100) DEFAULT NULL
104 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
105 insert into t1 values (100, 1.1, 'pune');
106 insert into t1 values (99, 1.2, 'mumbai');
107 insert into t1 values (98, 1.3, 'jaipur');
108 insert into t1 values (97, 1.4, 'delhi');
109 insert into t1 values (96, 1.5, 'ahmedabad');
110 select * from t1;
111 i f c
112 100 1.1 pune
113 99 1.2 mumbai
114 98 1.3 jaipur
115 97 1.4 delhi
116 96 1.5 ahmedabad
117 select * from t1 where i = 98;
118 i f c
119 98 1.3 jaipur
120 select * from t1 where i < 100;
121 i f c
122 99 1.2 mumbai
123 98 1.3 jaipur
124 97 1.4 delhi
125 96 1.5 ahmedabad
126 explain select * from t1 where f > 1.29999;
127 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
128 1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 5 33.33 Using where
129 Warnings:
130 Note 1003 /* select#1 */ select `test`.`t1`.`i` AS `i`,`test`.`t1`.`f` AS `f`,`test`.`t1`.`c` AS `c` from `test`.`t1` where (`test`.`t1`.`f` > 1.29999)
131 alter table t1 add index sec_index(f);
132 explain select * from t1 where f > 1.29999;
133 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
134 1 SIMPLE t1 NULL range sec_index sec_index 5 NULL 3 100.00 Using index condition
135 Warnings:
136 Note 1003 /* select#1 */ select `test`.`t1`.`i` AS `i`,`test`.`t1`.`f` AS `f`,`test`.`t1`.`c` AS `c` from `test`.`t1` where (`test`.`t1`.`f` > 1.29999)
137 select * from t1 where f > 1.29999;
138 i f c
139 98 1.3 jaipur
140 97 1.4 delhi
141 96 1.5 ahmedabad
142 explain select * from t1 where i = 100;
143 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
144 1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 5 20.00 Using where
145 Warnings:
146 Note 1003 /* select#1 */ select `test`.`t1`.`i` AS `i`,`test`.`t1`.`f` AS `f`,`test`.`t1`.`c` AS `c` from `test`.`t1` where (`test`.`t1`.`i` = 100)
147 alter table t1 add unique index pri_index(i);
148 explain select * from t1 where i = 100;
149 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
150 1 SIMPLE t1 NULL const pri_index pri_index 5 const 1 100.00 NULL
151 Warnings:
152 Note 1003 /* select#1 */ select '100' AS `i`,'1.1' AS `f`,'pune' AS `c` from `test`.`t1` where true
153 select * from t1 where i = 100;
154 i f c
155 100 1.1 pune
156 delete from t1 where i < 97;
157 select * from t1;
158 i f c
159 100 1.1 pune
160 99 1.2 mumbai
161 98 1.3 jaipur
162 97 1.4 delhi
163 insert into t1 values (96, 1.5, 'kolkata');
164 select * from t1;
165 i f c
166 100 1.1 pune
167 99 1.2 mumbai
168 98 1.3 jaipur
169 97 1.4 delhi
170 96 1.5 kolkata
171 update t1 set f = 1.44 where c = 'delhi';
172 select * from t1;
173 i f c
174 100 1.1 pune
175 99 1.2 mumbai
176 98 1.3 jaipur
177 97 1.44 delhi
178 96 1.5 kolkata
179 truncate table t1;
180 insert into t1 values (100, 1.1, 'pune');
181 insert into t1 values (99, 1.2, 'mumbai');
182 insert into t1 values (98, 1.3, 'jaipur');
183 insert into t1 values (97, 1.4, 'delhi');
184 insert into t1 values (96, 1.5, 'ahmedabad');
185 select * from t1;
186 i f c
187 100 1.1 pune
188 99 1.2 mumbai
189 98 1.3 jaipur
190 97 1.4 delhi
191 96 1.5 ahmedabad
192 alter table t1 discard tablespace;
193 ERROR HY000: Cannot DISCARD/IMPORT tablespace associated with temporary table
194 drop table t1;
195 create temporary table t1
196 (keyc int, c1 char(100), c2 char(100),
197 primary key(keyc)) engine = innodb;
198 CREATE PROCEDURE populate_t1()
199 BEGIN
200 DECLARE i INT DEFAULT 1;
201 while (i <= 20000) DO
202 insert into t1 values (i, 'a', 'b');
203 SET i = i + 1;
204 END WHILE;
205 END|
206 set autocommit=0;
207 select count(*) from t1;
208 count(*)
209 0
210 call populate_t1();
211 select count(*) from t1;
212 count(*)
213 20000
214 select * from t1 limit 10;
215 keyc c1 c2
216 1 a b
217 2 a b
218 3 a b
219 4 a b
220 5 a b
221 6 a b
222 7 a b
223 8 a b
224 9 a b
225 10 a b
226 set autocommit=1;
227 truncate table t1;
228 select count(*) from t1;
229 count(*)
230 0
231 drop procedure populate_t1;
232 drop table t1;
233 create temporary table t1 (keyc int, c1 char(100), c2 char(100)) engine = innodb;
234 insert into t1 values (1, 'c', 'b');
235 select * from t1;
236 keyc c1 c2
237 1 c b
238 # restart
239 # files in MYSQL_DATA_DIR
240 ibtmp1
241 use test;
242 select * from t1;
243 ERROR 42S02: Table 'test.t1' doesn't exist
244 "testing temp-table creation in --innodb_read_only mode"
245 SET GLOBAL innodb_fast_shutdown = 0;
246 # restart: --innodb-read-only
247 use test;
248 show tables;
249 Tables_in_test
250 create temporary table t1 (keyc int, c1 char(100), c2 char(100)) engine = innodb;
251 ERROR HY000: InnoDB is in read only mode.
252 "testing system and temp tablespace name conflict"
253 Pattern "innodb_temporary and innodb_system file names seem to be the same" found
254 "restarting server in normal mode"
255 # restart
256 show tables;
257 Tables_in_test
258 create temporary table t1 (keyc int, c1 char(100), c2 char(100)) engine = innodb;
259 drop table t1;
260 # test condition of full-temp-tablespace
261 # restart: --innodb-rollback-segments=32 --innodb_temp_data_file_path=ibtmp1:64M
262 create temporary table t1
263 (keyc int, c1 char(250), c2 char(250), c3 char(250),
264 primary key(keyc, c1, c2, c3)) engine = innodb charset latin1;
265 CREATE PROCEDURE populate_t1()
266 BEGIN
267 DECLARE i INT DEFAULT 1;
268 while (i <= 20000) DO
269 insert into t1 values (i, repeat('a', 250), repeat('b', 250), repeat('c', 250));
270 SET i = i + 1;
271 END WHILE;
272 END|
273 set autocommit=0;
274 select count(*) from t1;
275 count(*)
276 0
277 call populate_t1();
278 drop procedure populate_t1;
279 drop table t1;
280 create temporary table t (
281 i int)
282 engine = innodb row_format = compressed;
283 ERROR HY000: CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
284 create temporary table t (
285 i int)
286 engine = innodb row_format = compressed key_block_size = 8;
287 ERROR HY000: CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
288 create temporary table t (
289 i int)
290 engine = innodb row_format = dynamic;
291 show warnings;
292 Level Code Message
293 drop table t;
294 set innodb_strict_mode = on;
295 create temporary table t (
296 i int)
297 engine = innodb row_format = dynamic;
298 show warnings;
299 Level Code Message
300 drop table t;
301 set innodb_strict_mode = off;
302 create temporary table t (
303 i int)
304 engine = innodb row_format = compressed key_block_size = 8;
305 Warnings:
306 Warning 1478 InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
307 Warning 1478 InnoDB: ROW_FORMAT=COMPRESSED is ignored for TEMPORARY TABLE.
308 Warning 1478 InnoDB: assuming ROW_FORMAT=DYNAMIC.
309 show warnings;
310 Level Code Message
311 Warning 1478 InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
312 Warning 1478 InnoDB: ROW_FORMAT=COMPRESSED is ignored for TEMPORARY TABLE.
313 Warning 1478 InnoDB: assuming ROW_FORMAT=DYNAMIC.
314 set innodb_strict_mode = default;
315 drop table t;
316 create temporary table t (
317 i int)
318 engine = innodb row_format = compressed;
319 ERROR HY000: CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
320 #files in MYSQL_TMP_DIR, expecting only default temporary tablespace file
321 ibtmp1
322 create temporary table t (
323 i int)
324 engine = innodb row_format = dynamic;
325 show warnings;
326 Level Code Message
327 drop table t;
328 set innodb_strict_mode = on;
329 create temporary table t (
330 i int)
331 engine = innodb row_format = dynamic;
332 show warnings;
333 Level Code Message
334 drop table t;
335 set innodb_strict_mode = off;
336 create temporary table t (
337 i int)
338 engine = innodb row_format = dynamic key_block_size = 4;
339 Warnings:
340 Warning 1478 InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
341 show warnings;
342 Level Code Message
343 Warning NUMBER InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
344 drop table t;
345 create temporary table t (
346 i int)
347 engine = innodb row_format = compact;
348 show warnings;
349 Level Code Message
350 drop table t;
351 create temporary table t (
352 i int)
353 engine = innodb key_block_size = 4;
354 Warnings:
355 Warning 1478 InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
356 show warnings;
357 Level Code Message
358 Warning NUMBER InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
359 drop table t;
360 CREATE TEMPORARY TABLE t1(
361 i INT
362 ) ENGINE = InnoDB ROW_FORMAT = REDUNDANT;
363 SELECT count(*) AS `Expect 1` FROM information_schema.innodb_temp_table_info;
364 Expect 1
365 1
366 CREATE TABLE space_id(
367 id INT UNSIGNED
368 ) ENGINE = InnoDB;
369 INSERT INTO space_id SELECT space FROM information_schema.innodb_temp_table_info;
370 SELECT count(*) AS `Expect 1` FROM space_id;
371 Expect 1
372 1
373 DROP TABLE t1;
374 CREATE TEMPORARY TABLE t1 (
375 i INT NOT NULL PRIMARY KEY,
376 c CHAR(10) NOT NULL
377 ) ENGINE = InnoDB KEY_BLOCK_SIZE = 4;
378 Warnings:
379 Warning 1478 InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
380 SHOW WARNINGS;
381 Level Code Message
382 Warning NUMBER InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
383 SHOW CREATE TABLE t1;
384 Table Create Table
385 t1 CREATE TEMPORARY TABLE `t1` (
386 `i` int NOT NULL,
387 `c` char(10) NOT NULL,
388 PRIMARY KEY (`i`)
389 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci KEY_BLOCK_SIZE=4
390 SELECT count(*) AS `Expect 1` FROM information_schema.innodb_temp_table_info;
391 Expect 1
392 1
393 SELECT count(*) AS `Expect 1` FROM space_id, information_schema.innodb_temp_table_info WHERE space_id.id = information_schema.innodb_temp_table_info.space;
394 Expect 1
395 1
396 DROP TABLE t1;
397 CREATE TEMPORARY TABLE t1 (
398 i INT NOT NULL PRIMARY KEY,
399 c CHAR(10) NOT NULL
400 ) ENGINE = InnoDB ROW_FORMAT = REDUNDANT;
401 SHOW WARNINGS;
402 Level Code Message
403 SHOW CREATE TABLE t1;
404 Table Create Table
405 t1 CREATE TEMPORARY TABLE `t1` (
406 `i` int NOT NULL,
407 `c` char(10) NOT NULL,
408 PRIMARY KEY (`i`)
409 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
410 SELECT count(*) AS `Expect 1` FROM information_schema.innodb_temp_table_info;
411 Expect 1
412 1
413 SELECT count(*) AS `Expect 1` FROM space_id, information_schema.innodb_temp_table_info WHERE space_id.id = information_schema.innodb_temp_table_info.space;
414 Expect 1
415 1
416 DROP TABLE t1;
417 CREATE TEMPORARY TABLE t1 (
418 i INT NOT NULL PRIMARY KEY,
419 c CHAR(10) NOT NULL
420 ) ENGINE = InnoDB ROW_FORMAT = COMPACT;
421 SHOW WARNINGS;
422 Level Code Message
423 SHOW CREATE TABLE t1;
424 Table Create Table
425 t1 CREATE TEMPORARY TABLE `t1` (
426 `i` int NOT NULL,
427 `c` char(10) NOT NULL,
428 PRIMARY KEY (`i`)
429 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
430 SELECT count(*) AS `Expect 1` FROM information_schema.innodb_temp_table_info;
431 Expect 1
432 1
433 SELECT count(*) AS `Expect 1` FROM space_id, information_schema.innodb_temp_table_info WHERE space_id.id = information_schema.innodb_temp_table_info.space;
434 Expect 1
435 1
436 DROP TABLE t1;
437 CREATE TEMPORARY TABLE t1 (
438 i INT NOT NULL PRIMARY KEY,
439 c CHAR(10) NOT NULL
440 ) ENGINE = InnoDB KEY_BLOCK_SIZE = 4;
441 Warnings:
442 Warning 1478 InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
443 SHOW WARNINGS;
444 Level Code Message
445 Warning NUMBER InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
446 SHOW CREATE TABLE t1;
447 Table Create Table
448 t1 CREATE TEMPORARY TABLE `t1` (
449 `i` int NOT NULL,
450 `c` char(10) NOT NULL,
451 PRIMARY KEY (`i`)
452 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci KEY_BLOCK_SIZE=4
453 SELECT count(*) AS `Expect 1` FROM information_schema.innodb_temp_table_info;
454 Expect 1
455 1
456 SELECT count(*) AS `Expect 1` FROM space_id, information_schema.innodb_temp_table_info WHERE space_id.id = information_schema.innodb_temp_table_info.space;
457 Expect 1
458 1
459 DROP TABLE t1;
460 CREATE TEMPORARY TABLE t1 (
461 i INT NOT NULL PRIMARY KEY,
462 c CHAR(10) NOT NULL
463 ) ENGINE = InnoDB ROW_FORMAT = COMPRESSED;
464 Warnings:
465 Warning 1478 InnoDB: ROW_FORMAT=COMPRESSED is ignored for TEMPORARY TABLE.
466 Warning 1478 InnoDB: assuming ROW_FORMAT=DYNAMIC.
467 SHOW WARNINGS;
468 Level Code Message
469 Warning NUMBER InnoDB: ROW_FORMAT=COMPRESSED is ignored for TEMPORARY TABLE.
470 Warning NUMBER InnoDB: assuming ROW_FORMAT=DYNAMIC.
471 SHOW CREATE TABLE t1;
472 Table Create Table
473 t1 CREATE TEMPORARY TABLE `t1` (
474 `i` int NOT NULL,
475 `c` char(10) NOT NULL,
476 PRIMARY KEY (`i`)
477 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED
478 SELECT count(*) AS `Expect 1` FROM information_schema.innodb_temp_table_info;
479 Expect 1
480 1
481 SELECT count(*) AS `Expect 1` FROM space_id, information_schema.innodb_temp_table_info WHERE space_id.id = information_schema.innodb_temp_table_info.space;
482 Expect 1
483 1
484 DROP TABLE t1;
485 CREATE TEMPORARY TABLE t1 (
486 i INT NOT NULL PRIMARY KEY,
487 c CHAR(10) NOT NULL
488 ) ENGINE = InnoDB ROW_FORMAT = COMPRESSED KEY_BLOCK_SIZE = 8;
489 Warnings:
490 Warning 1478 InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
491 Warning 1478 InnoDB: ROW_FORMAT=COMPRESSED is ignored for TEMPORARY TABLE.
492 Warning 1478 InnoDB: assuming ROW_FORMAT=DYNAMIC.
493 SHOW WARNINGS;
494 Level Code Message
495 Warning NUMBER InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
496 Warning NUMBER InnoDB: ROW_FORMAT=COMPRESSED is ignored for TEMPORARY TABLE.
497 Warning NUMBER InnoDB: assuming ROW_FORMAT=DYNAMIC.
498 SHOW CREATE TABLE t1;
499 Table Create Table
500 t1 CREATE TEMPORARY TABLE `t1` (
501 `i` int NOT NULL,
502 `c` char(10) NOT NULL,
503 PRIMARY KEY (`i`)
504 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8
505 SELECT count(*) AS `Expect 1` FROM information_schema.innodb_temp_table_info;
506 Expect 1
507 1
508 SELECT count(*) AS `Expect 1` FROM space_id, information_schema.innodb_temp_table_info WHERE space_id.id = information_schema.innodb_temp_table_info.space;
509 Expect 1
510 1
511 DROP TABLE t1;
512 CREATE TEMPORARY TABLE t1 (
513 i INT NOT NULL PRIMARY KEY,
514 c CHAR(10) NOT NULL
515 ) ENGINE = InnoDB ROW_FORMAT = DYNAMIC KEY_BLOCK_SIZE = 8;
516 Warnings:
517 Warning 1478 InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
518 SHOW WARNINGS;
519 Level Code Message
520 Warning NUMBER InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
521 SHOW CREATE TABLE t1;
522 Table Create Table
523 t1 CREATE TEMPORARY TABLE `t1` (
524 `i` int NOT NULL,
525 `c` char(10) NOT NULL,
526 PRIMARY KEY (`i`)
527 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=8
528 SELECT count(*) AS `Expect 1` FROM information_schema.innodb_temp_table_info;
529 Expect 1
530 1
531 SELECT count(*) AS `Expect 1` FROM space_id, information_schema.innodb_temp_table_info WHERE space_id.id = information_schema.innodb_temp_table_info.space;
532 Expect 1
533 1
534 DROP TABLE t1;
535 CREATE TEMPORARY TABLE t1 (
536 i INT NOT NULL PRIMARY KEY,
537 c CHAR(10) NOT NULL
538 ) ENGINE = InnoDB ROW_FORMAT = DYNAMIC;
539 SHOW WARNINGS;
540 Level Code Message
541 SHOW CREATE TABLE t1;
542 Table Create Table
543 t1 CREATE TEMPORARY TABLE `t1` (
544 `i` int NOT NULL,
545 `c` char(10) NOT NULL,
546 PRIMARY KEY (`i`)
547 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
548 SELECT count(*) AS `Expect 1` FROM information_schema.innodb_temp_table_info;
549 Expect 1
550 1
551 SELECT count(*) AS `Expect 1` FROM space_id, information_schema.innodb_temp_table_info WHERE space_id.id = information_schema.innodb_temp_table_info.space;
552 Expect 1
553 1
554 DROP TABLE t1;
555 CREATE TEMPORARY TABLE t1 (
556 i INT NOT NULL PRIMARY KEY
557 ) ENGINE = InnoDB ROW_FORMAT = REDUNDANT;
558 SELECT count(*) AS `Expect 1` FROM information_schema.innodb_temp_table_info;
559 Expect 1
560 1
561 SELECT count(*) AS `Expect 1` FROM space_id, information_schema.innodb_temp_table_info WHERE space_id.id = information_schema.innodb_temp_table_info.space;
562 Expect 1
563 1
564 ALTER TABLE t1 ROW_FORMAT = COMPRESSED;
565 Warnings:
566 Warning 1478 InnoDB: ROW_FORMAT=COMPRESSED is ignored for TEMPORARY TABLE.
567 Warning 1478 InnoDB: assuming ROW_FORMAT=DYNAMIC.
568 SHOW WARNINGS;
569 Level Code Message
570 Warning NUMBER InnoDB: ROW_FORMAT=COMPRESSED is ignored for TEMPORARY TABLE.
571 Warning NUMBER InnoDB: assuming ROW_FORMAT=DYNAMIC.
572 SHOW CREATE TABLE t1;
573 Table Create Table
574 t1 CREATE TEMPORARY TABLE `t1` (
575 `i` int NOT NULL,
576 PRIMARY KEY (`i`)
577 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED
578 SELECT count(*) AS `Expect 1` FROM information_schema.innodb_temp_table_info;
579 Expect 1
580 1
581 SELECT count(*) AS `Expect 1` FROM space_id, information_schema.innodb_temp_table_info WHERE space_id.id = information_schema.innodb_temp_table_info.space;
582 Expect 1
583 1
584 ALTER TABLE t1 KEY_BLOCK_SIZE = 4;
585 Warnings:
586 Warning 1478 InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
587 Warning 1478 InnoDB: ROW_FORMAT=COMPRESSED is ignored for TEMPORARY TABLE.
588 Warning 1478 InnoDB: assuming ROW_FORMAT=DYNAMIC.
589 SHOW WARNINGS;
590 Level Code Message
591 Warning NUMBER InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
592 Warning NUMBER InnoDB: ROW_FORMAT=COMPRESSED is ignored for TEMPORARY TABLE.
593 Warning NUMBER InnoDB: assuming ROW_FORMAT=DYNAMIC.
594 SHOW CREATE TABLE t1;
595 Table Create Table
596 t1 CREATE TEMPORARY TABLE `t1` (
597 `i` int NOT NULL,
598 PRIMARY KEY (`i`)
599 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4
600 SELECT count(*) AS `Expect 1` FROM information_schema.innodb_temp_table_info;
601 Expect 1
602 1
603 SELECT count(*) AS `Expect 1` FROM space_id, information_schema.innodb_temp_table_info WHERE space_id.id = information_schema.innodb_temp_table_info.space;
604 Expect 1
605 1
606 ALTER TABLE t1 KEY_BLOCK_SIZE = 4 ROW_FORMAT = COMPRESSED;
607 Warnings:
608 Warning 1478 InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
609 Warning 1478 InnoDB: ROW_FORMAT=COMPRESSED is ignored for TEMPORARY TABLE.
610 Warning 1478 InnoDB: assuming ROW_FORMAT=DYNAMIC.
611 SHOW WARNINGS;
612 Level Code Message
613 Warning NUMBER InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
614 Warning NUMBER InnoDB: ROW_FORMAT=COMPRESSED is ignored for TEMPORARY TABLE.
615 Warning NUMBER InnoDB: assuming ROW_FORMAT=DYNAMIC.
616 SHOW CREATE TABLE t1;
617 Table Create Table
618 t1 CREATE TEMPORARY TABLE `t1` (
619 `i` int NOT NULL,
620 PRIMARY KEY (`i`)
621 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4
622 SELECT count(*) AS `Expect 1` FROM information_schema.innodb_temp_table_info;
623 Expect 1
624 1
625 SELECT count(*) AS `Expect 1` FROM space_id, information_schema.innodb_temp_table_info WHERE space_id.id = information_schema.innodb_temp_table_info.space;
626 Expect 1
627 1
628 ALTER TABLE t1 ROW_FORMAT = DYNAMIC KEY_BLOCK_SIZE = 4;
629 Warnings:
630 Warning 1478 InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
631 SHOW WARNINGS;
632 Level Code Message
633 Warning NUMBER InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
634 SHOW CREATE TABLE t1;
635 Table Create Table
636 t1 CREATE TEMPORARY TABLE `t1` (
637 `i` int NOT NULL,
638 PRIMARY KEY (`i`)
639 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=4
640 SELECT count(*) AS `Expect 1` FROM information_schema.innodb_temp_table_info;
641 Expect 1
642 1
643 SELECT count(*) AS `Expect 1` FROM space_id, information_schema.innodb_temp_table_info WHERE space_id.id = information_schema.innodb_temp_table_info.space;
644 Expect 1
645 1
646 ALTER TABLE t1 ROW_FORMAT = DYNAMIC;
647 Warnings:
648 Warning 1478 InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
649 SHOW WARNINGS;
650 Level Code Message
651 Warning NUMBER InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
652 SHOW CREATE TABLE t1;
653 Table Create Table
654 t1 CREATE TEMPORARY TABLE `t1` (
655 `i` int NOT NULL,
656 PRIMARY KEY (`i`)
657 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=4
658 SELECT count(*) AS `Expect 1` FROM information_schema.innodb_temp_table_info;
659 Expect 1
660 1
661 SELECT count(*) AS `Expect 1` FROM space_id, information_schema.innodb_temp_table_info WHERE space_id.id = information_schema.innodb_temp_table_info.space;
662 Expect 1
663 1
664 DROP TABLE t1;
665 set innodb_strict_mode = ON;
666 CREATE TEMPORARY TABLE t1 (
667 i INT NOT NULL PRIMARY KEY,
668 c CHAR(10) NOT NULL
669 ) ENGINE = InnoDB KEY_BLOCK_SIZE = 4;
670 ERROR HY000: CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
671 SHOW WARNINGS;
672 Level Code Message
673 Error NUMBER CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
674 Error NUMBER Table storage engine for 't1' doesn't have this option
675 CREATE TEMPORARY TABLE t1 (
676 i INT NOT NULL PRIMARY KEY,
677 c CHAR(10) NOT NULL
678 ) ENGINE = InnoDB KEY_BLOCK_SIZE = 4, ROW_FORMAT = COMPACT;
679 ERROR HY000: CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
680 SHOW WARNINGS;
681 Level Code Message
682 Error NUMBER CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
683 Error NUMBER Table storage engine for 't1' doesn't have this option
684 CREATE TEMPORARY TABLE t1 (
685 i INT NOT NULL PRIMARY KEY,
686 c CHAR(10) NOT NULL
687 ) ENGINE = InnoDB ROW_FORMAT = REDUNDANT;
688 SHOW WARNINGS;
689 Level Code Message
690 SHOW CREATE TABLE t1;
691 Table Create Table
692 t1 CREATE TEMPORARY TABLE `t1` (
693 `i` int NOT NULL,
694 `c` char(10) NOT NULL,
695 PRIMARY KEY (`i`)
696 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
697 SELECT count(*) AS `Expect 1` FROM information_schema.innodb_temp_table_info;
698 Expect 1
699 1
700 SELECT count(*) AS `Expect 1` FROM space_id, information_schema.innodb_temp_table_info WHERE space_id.id = information_schema.innodb_temp_table_info.space;
701 Expect 1
702 1
703 DROP TABLE t1;
704 CREATE TEMPORARY TABLE t1 (
705 i INT NOT NULL PRIMARY KEY,
706 c CHAR(10) NOT NULL
707 ) ENGINE = InnoDB KEY_BLOCK_SIZE = 4;
708 ERROR HY000: CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
709 SHOW WARNINGS;
710 Level Code Message
711 Error NUMBER CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
712 Error NUMBER Table storage engine for 't1' doesn't have this option
713 CREATE TEMPORARY TABLE t1 (
714 i INT NOT NULL PRIMARY KEY,
715 c CHAR(10) NOT NULL
716 ) ENGINE = InnoDB ROW_FORMAT = COMPRESSED;
717 ERROR HY000: CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
718 SHOW WARNINGS;
719 Level Code Message
720 Error NUMBER CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
721 Error NUMBER Table storage engine for 't1' doesn't have this option
722 CREATE TEMPORARY TABLE t1 (
723 i INT NOT NULL PRIMARY KEY,
724 c CHAR(10) NOT NULL
725 ) ENGINE = InnoDB ROW_FORMAT = COMPRESSED KEY_BLOCK_SIZE = 8;
726 ERROR HY000: CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
727 SHOW WARNINGS;
728 Level Code Message
729 Error NUMBER CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
730 Error NUMBER Table storage engine for 't1' doesn't have this option
731 CREATE TEMPORARY TABLE t1 (
732 i INT NOT NULL PRIMARY KEY,
733 c CHAR(10) NOT NULL
734 ) ENGINE = InnoDB ROW_FORMAT = COMPRESSED KEY_BLOCK_SIZE = 7;
735 ERROR HY000: CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
736 SHOW WARNINGS;
737 Level Code Message
738 Error NUMBER CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
739 Error NUMBER Table storage engine for 't1' doesn't have this option
740 CREATE TEMPORARY TABLE t1 (
741 i INT NOT NULL PRIMARY KEY,
742 c CHAR(10) NOT NULL
743 ) ENGINE = InnoDB ROW_FORMAT = DYNAMIC;
744 SHOW WARNINGS;
745 Level Code Message
746 SHOW CREATE TABLE t1;
747 Table Create Table
748 t1 CREATE TEMPORARY TABLE `t1` (
749 `i` int NOT NULL,
750 `c` char(10) NOT NULL,
751 PRIMARY KEY (`i`)
752 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
753 SELECT count(*) AS `Expect 1` FROM information_schema.innodb_temp_table_info;
754 Expect 1
755 1
756 SELECT count(*) AS `Expect 1` FROM space_id, information_schema.innodb_temp_table_info WHERE space_id.id = information_schema.innodb_temp_table_info.space;
757 Expect 1
758 1
759 DROP TABLE t1;
760 CREATE TEMPORARY TABLE t1 (
761 i INT NOT NULL PRIMARY KEY
762 ) ENGINE = InnoDB ROW_FORMAT = REDUNDANT;
763 SELECT count(*) AS `Expect 1` FROM information_schema.innodb_temp_table_info;
764 Expect 1
765 1
766 SELECT count(*) AS `Expect 1` FROM space_id, information_schema.innodb_temp_table_info WHERE space_id.id = information_schema.innodb_temp_table_info.space;
767 Expect 1
768 1
769 ALTER TABLE t1 ROW_FORMAT = COMPRESSED;
770 ERROR HY000: CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
771 SHOW WARNINGS;
772 Level Code Message
773 Error NUMBER CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
774 Error NUMBER Table storage engine for '#sql<temporary>' doesn't have this option
775 ALTER TABLE t1 KEY_BLOCK_SIZE = 4;
776 ERROR HY000: CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
777 SHOW WARNINGS;
778 Level Code Message
779 Error NUMBER CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
780 Error NUMBER Table storage engine for '#sql<temporary>' doesn't have this option
781 ALTER TABLE t1 ROW_FORMAT = DYNAMIC KEY_BLOCK_SIZE = 4;
782 ERROR HY000: CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
783 SHOW WARNINGS;
784 Level Code Message
785 Error NUMBER CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
786 Error NUMBER Table storage engine for '#sql<temporary>' doesn't have this option
787 ALTER TABLE t1 ROW_FORMAT = DYNAMIC;
788 set innodb_strict_mode = OFF;
789 ALTER TABLE t1 ROW_FORMAT = COMPRESSED;
790 Warnings:
791 Warning 1478 InnoDB: ROW_FORMAT=COMPRESSED is ignored for TEMPORARY TABLE.
792 Warning 1478 InnoDB: assuming ROW_FORMAT=DYNAMIC.
793 SHOW WARNINGS;
794 Level Code Message
795 Warning NUMBER InnoDB: ROW_FORMAT=COMPRESSED is ignored for TEMPORARY TABLE.
796 Warning NUMBER InnoDB: assuming ROW_FORMAT=DYNAMIC.
797 set innodb_strict_mode = ON;
798 ALTER TABLE t1 ROW_FORMAT = DYNAMIC;
799 SHOW CREATE TABLE t1;
800 Table Create Table
801 t1 CREATE TEMPORARY TABLE `t1` (
802 `i` int NOT NULL,
803 PRIMARY KEY (`i`)
804 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
805 set innodb_strict_mode = OFF;
806 ALTER TABLE t1 ROW_FORMAT = COMPRESSED;
807 Warnings:
808 Warning 1478 InnoDB: ROW_FORMAT=COMPRESSED is ignored for TEMPORARY TABLE.
809 Warning 1478 InnoDB: assuming ROW_FORMAT=DYNAMIC.
810 SHOW WARNINGS;
811 Level Code Message
812 Warning NUMBER InnoDB: ROW_FORMAT=COMPRESSED is ignored for TEMPORARY TABLE.
813 Warning NUMBER InnoDB: assuming ROW_FORMAT=DYNAMIC.
814 ALTER TABLE t1 KEY_BLOCK_SIZE = 8;
815 Warnings:
816 Warning 1478 InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
817 Warning 1478 InnoDB: ROW_FORMAT=COMPRESSED is ignored for TEMPORARY TABLE.
818 Warning 1478 InnoDB: assuming ROW_FORMAT=DYNAMIC.
819 SHOW WARNINGS;
820 Level Code Message
821 Warning NUMBER InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
822 Warning NUMBER InnoDB: ROW_FORMAT=COMPRESSED is ignored for TEMPORARY TABLE.
823 Warning NUMBER InnoDB: assuming ROW_FORMAT=DYNAMIC.
824 set innodb_strict_mode = ON;
825 ALTER TABLE t1 ADD COLUMN j INT;
826 ERROR HY000: CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
827 SHOW WARNINGS;
828 Level Code Message
829 Error NUMBER CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
830 Error NUMBER Table storage engine for '#sql<temporary>' doesn't have this option
831 SHOW CREATE TABLE t1;
832 Table Create Table
833 t1 CREATE TEMPORARY TABLE `t1` (
834 `i` int NOT NULL,
835 PRIMARY KEY (`i`)
836 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8
837 set innodb_strict_mode = OFF;
838 ALTER TABLE t1 KEY_BLOCK_SIZE = 0;
839 Warnings:
840 Warning 1478 InnoDB: ROW_FORMAT=COMPRESSED is ignored for TEMPORARY TABLE.
841 Warning 1478 InnoDB: assuming ROW_FORMAT=DYNAMIC.
842 SHOW CREATE TABLE t1;
843 Table Create Table
844 t1 CREATE TEMPORARY TABLE `t1` (
845 `i` int NOT NULL,
846 PRIMARY KEY (`i`) KEY_BLOCK_SIZE=8
847 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED
848 ALTER TABLE t1 ROW_FORMAT = DYNAMIC;
849 set innodb_strict_mode = ON;
850 ALTER TABLE t1 ADD COLUMN j INT;
851 SHOW CREATE TABLE t1;
852 Table Create Table
853 t1 CREATE TEMPORARY TABLE `t1` (
854 `i` int NOT NULL,
855 `j` int DEFAULT NULL,
856 PRIMARY KEY (`i`) KEY_BLOCK_SIZE=8
857 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
858 DROP TABLE t1, space_id;
859 set innodb_strict_mode = OFF;
860 "testing temp tablespace non-support for raw device"
861 Pattern "support raw device" found
862 "testing temp tablespace non-support for raw device"
863 Pattern "support raw device" found
864 # restart
865 show tables;
866 Tables_in_test
867 create temporary table t1 (
868 keyc int, c1 char(100), c2 char(100)
869 ) engine = innodb;
870 drop table t1;
871 "try starting server with temp-tablespace size < min. threshold"
872 Pattern "Tablespace size must be at least" found
873 "try starting server with sys-tablespace size < min. threshold"
874 Pattern "Tablespace size must be at least" found
875 # restart
876 show tables;
877 Tables_in_test
878 create temporary table t1 (
879 keyc int, c1 char(100), c2 char(100)
880 ) engine = innodb;
881 drop table t1;
882 "try starting server with no file specified for temp-tablespace"
883 Pattern "init function returned error" found
884 # restart
885 show tables;
886 Tables_in_test
887 create temporary table t1 (
888 keyc int, c1 char(100), c2 char(100)
889 ) engine = innodb;
890 drop table t1;
891 SHOW CREATE TABLE information_schema.innodb_temp_table_info;
892 Table Create Table
893 INNODB_TEMP_TABLE_INFO CREATE TEMPORARY TABLE `INNODB_TEMP_TABLE_INFO` (
894 `TABLE_ID` bigint unsigned NOT NULL DEFAULT '0',
895 `NAME` varchar(64) DEFAULT NULL,
896 `N_COLS` int unsigned NOT NULL DEFAULT '0',
897 `SPACE` int unsigned NOT NULL DEFAULT '0'
898 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3
899 SELECT count(*) AS `Expect 0` FROM information_schema.innodb_temp_table_info;
900 Expect 0
901 0
902 CREATE TEMPORARY TABLE t1 (
903 i int,
904 f float
905 ) ENGINE = InnoDB;
906 CREATE TEMPORARY TABLE t2 (
907 i int,
908 f float
909 ) ENGINE = InnoDB;
910 SELECT count(*) AS `Expect 2` FROM information_schema.innodb_temp_table_info;
911 Expect 2
912 2
913 DROP TABLE t1, t2;