Debian Codegraph @

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

raw
1 #
2 # Bug #22306581 VALGRIND FAILURE IN INNODB.TEMPORARY_TABLE
3 #
4 create temporary table t (i int) COMPRESSION = "ZLIB" ENGINE = InnoDB;
5 ERROR HY000: Table storage engine for 't' doesn't have this option
6 SHOW WARNINGS;
7 Level Code Message
8 Warning 138 InnoDB: Page Compression is not supported for temporary tables
9 Error 1031 Table storage engine for 't' doesn't have this option
10 create table t1(i INT) COMPRESSION="ZLIB" ENGINE=InnoDB TABLESPACE=innodb_system;
11 ERROR HY000: Table storage engine for 't1' doesn't have this option
12 SHOW WARNINGS;
13 Level Code Message
14 Warning 138 InnoDB: Page Compression is not supported for the system tablespace
15 Error 1031 Table storage engine for 't1' doesn't have this option
16 SET DEBUG ='+d, simulate_max_char_col';
17 create table t1(f1 varchar(1000))engine=innodb;
18 Got one of the listed errors
19 SET DEBUG ='-d, simulate_max_char_col';
20 #
21 # Bug #27361662 ERROR NOT THROWN ON CREATING TEMPORARY TABLE IN
22 # INNODB_FILE_PER_TABLE TABLESPACE
23 #
24 # Try creating temporary table with innodb_file_per_table option with STRICT mode
25 SET innodb_strict_mode = ON;
26 CREATE TEMPORARY TABLE t1(c1 int) TABLESPACE innodb_file_per_table;
27 ERROR HY000: InnoDB: TABLESPACE=innodb_file_per_table option is disallowed for temporary tables with INNODB_STRICT_MODE=ON. This option is deprecated and will be removed in a future release
28 SELECT COUNT(*) FROM t1;
29 ERROR 42S02: Table 'test.t1' doesn't exist
30 # Try creating temporary table with innodb_file_per_table option without STRICT mode
31 SET innodb_strict_mode = OFF;
32 CREATE TEMPORARY TABLE t1(c1 int) TABLESPACE innodb_file_per_table;
33 Warnings:
34 Warning 1478 InnoDB: TABLESPACE=innodb_file_per_table option is ignored. All temporary tables are created in a session temporary tablespace. This option is deprecated and will be removed in a future release.
35 SHOW WARNINGS;
36 Level Code Message
37 Warning 1478 InnoDB: TABLESPACE=innodb_file_per_table option is ignored. All temporary tables are created in a session temporary tablespace. This option is deprecated and will be removed in a future release.
38 SELECT COUNT(*) FROM t1;
39 COUNT(*)
40 0
41 # Try to create a table name that has the form of an FTS auxilliary table name.
42 CREATE TABLE fts_0000000000000424_config (id int);
43 ERROR 42000: Incorrect table name 'fts_0000000000000424_config'
44 SHOW WARNINGS;
45 Level Code Message
46 Warning 1103 Invalid table name. `test/fts_0000000000000424_config` has the form of an FTS auxiliary table name
47 Error 1103 Incorrect table name 'fts_0000000000000424_config'
48 SET innodb_strict_mode = default;