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