CALL mtr.add_suppression("default_tmp_storage_engine is set to a disabled storage engine .*"); # # Verifying that temporary tables are handled the same way after # bug#29899151 # # Verify that creating temporary tables in NDB is rejected CREATE TEMPORARY TABLE t1(a int PRIMARY KEY, b varchar(255)) ENGINE=NDBCLUSTER; ERROR HY000: Table storage engine 'ndbcluster' does not support the create option 'TEMPORARY' CREATE TABLE t1 (a int PRIMARY KEY, b varchar(255)) ENGINE=NDBCLUSTER; CREATE TEMPORARY TABLE tt1 AS SELECT * FROM t1; SHOW CREATE TABLE tt1; Table Create Table tt1 CREATE TEMPORARY TABLE `tt1` ( `a` int NOT NULL, `b` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci # CREATE LIKE without engine should fall back to default temp engine # but is rejected earlier due to another condition. (dtjeldvo FIXME) CREATE TEMPORARY TABLE tt1 LIKE t1; ERROR HY000: Cannot create temporary table with partitions # Verify that substitution is not done if the default temp engine is set # to NDB (silly configuration) SET default_tmp_storage_engine=NDBCLUSTER; CREATE TEMPORARY TABLE tt1 LIKE t1; ERROR HY000: Table storage engine 'ndbcluster' does not support the create option 'TEMPORARY' # Verify that substitution is not done if default temp engine is # disabled SET default_tmp_storage_engine=MEMORY; CREATE TEMPORARY TABLE tt1 LIKE t1; ERROR HY000: Table storage engine 'ndbcluster' does not support the create option 'TEMPORARY' SET default_tmp_storage_engine=default; DROP TABLE t1; CREATE TEMPORARY TABLE t1 (a int KEY) ENGINE=MYISAM; ALTER TABLE t1 ENGINE=NDB; ERROR HY000: Cannot create temporary table with partitions DROP TABLE t1;