1DROP TABLE IF EXISTS t1; 2create temporary table t1 (a int key) engine=ndb; 3ERROR HY000: Table storage engine 'ndbcluster' does not support the create option 'TEMPORARY' 4create temporary table t1 (a int key) engine=myisam; 5alter table t1 engine=ndb; 6ERROR HY000: Table storage engine 'ndbcluster' does not support the create option 'TEMPORARY' 7drop table t1; 8CREATE TABLE bar ( id TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY ) ENGINE=NDBCluster ; 9CREATE TEMPORARY TABLE foo LIKE bar ; 10ERROR HY000: Cannot create temporary table with partitions 11DROP TABLE bar; 12SET SESSION default_storage_engine=NDBCLUSTER; 13create table t1 (a int key); 14select engine from information_schema.tables where table_name = 't1'; 15engine 16ndbcluster 17drop table t1; 18create temporary table t1 (a int key); 19show create table t1; 20Table Create Table 21t1 CREATE TEMPORARY TABLE `t1` ( 22 `a` int(11) NOT NULL, 23 PRIMARY KEY (`a`) 24) ENGINE=MyISAM DEFAULT CHARSET=latin1 25drop table t1; 26