Debian Codegraph @

mysql-test/suite/ndb/r/ndb_temporary.result

raw
1 create temporary table t1 (a int key) engine=ndb;
2 ERROR HY000: Table storage engine 'ndbcluster' does not support the create option 'TEMPORARY'
3 create temporary table t1 (a int key) engine=myisam;
4 alter table t1 engine=ndb;
5 ERROR HY000: Cannot create temporary table with partitions
6 alter table t1 algorithm=copy, engine=ndb;
7 ERROR HY000: Cannot create temporary table with partitions
8 drop table t1;
9 CREATE TABLE bar ( id TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY ) ENGINE=NDBCluster ;
10 Warnings:
11 Warning 1063 Max value for column id in table test.bar is less than autoincrement prefetch size. Please decrease ndb_autoincrement_prefetch_sz
12 CREATE TEMPORARY TABLE foo LIKE bar ;
13 ERROR HY000: Cannot create temporary table with partitions
14 DROP TABLE bar;
15 SET SESSION default_storage_engine=NDBCLUSTER;
16 create table t1 (a int key);
17 select engine from information_schema.tables where table_name = 't1';
18 ENGINE
19 ndbcluster
20 drop table t1;
21 create temporary table t1 (a int key);
22 show create table t1;
23 Table Create Table
24 t1 CREATE TEMPORARY TABLE `t1` (
25 `a` int NOT NULL,
26 PRIMARY KEY (`a`)
27 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
28 drop table t1;