1#
2# Bug #22306581	VALGRIND FAILURE IN INNODB.TEMPORARY_TABLE
3#
4create temporary table t (i int) COMPRESSION = "ZLIB" ENGINE = InnoDB;
5ERROR HY000: Table storage engine for 't' doesn't have this option
6SHOW WARNINGS;
7Level	Code	Message
8Warning	138	InnoDB: Page Compression is not supported for temporary tables
9Error	1031	Table storage engine for 't' doesn't have this option
10create table t1(i INT) COMPRESSION="ZLIB" ENGINE=InnoDB TABLESPACE=innodb_system;
11ERROR HY000: Table storage engine for 't1' doesn't have this option
12SHOW WARNINGS;
13Level	Code	Message
14Warning	138	InnoDB: Page Compression is not supported for the system tablespace
15Error	1031	Table storage engine for 't1' doesn't have this option
16SET DEBUG ='+d, simulate_max_char_col';
17create table t1(f1 varchar(1000))engine=innodb;
18ERROR HY000: Got error 1005 from storage engine
19SET 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"
25SET innodb_strict_mode = ON;
26CREATE TEMPORARY TABLE t1(c1 int) TABLESPACE innodb_file_per_table;
27ERROR HY000: InnoDB: TABLESPACE=innodb_file_per_table option is disallowed for temporary tables with INNODB_STRICT_NODE=ON. This option is deprecated and will be removed in a future release
28SELECT COUNT(*) FROM t1;
29ERROR 42S02: Table 'test.t1' doesn't exist
30"Try creating temporary table with innodb_file_per_table option without STRICT mode"
31SET innodb_strict_mode = OFF;
32CREATE TEMPORARY TABLE t1(c1 int) TABLESPACE innodb_file_per_table;
33Warnings:
34Warning	1478	InnoDB: TABLESPACE=innodb_file_per_table option is ignored. This option is deprecated and will be removed in a future release.
35SHOW WARNINGS;
36Level	Code	Message
37Warning	1478	InnoDB: TABLESPACE=innodb_file_per_table option is ignored. This option is deprecated and will be removed in a future release.
38SELECT COUNT(*) FROM t1;
39COUNT(*)
400
41DROP TABLE t1;
42SET innodb_strict_mode = default;
43