1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
|
ALTER TABLE t1
ENGINE=MyISAM;
select TABLE_SCHEMA, TABLE_NAME, ENGINE
from information_schema.tables
where TABLE_SCHEMA = 'ndb_ddl_test'
order by TABLE_SCHEMA, TABLE_NAME;
TABLE_SCHEMA TABLE_NAME ENGINE
ndb_ddl_test t1 MyISAM
ndb_ddl_test t2 ndbcluster
ndb_ddl_test t3 ndbcluster
ndb_ddl_test t4 ndbcluster
ndb_ddl_test t5 ndbcluster
ndb_ddl_test t6 ndbcluster
ndb_ddl_test t7 ndbcluster
ndb_ddl_test t8 ndbcluster
ndb_ddl_test t9 ndbcluster
select TABLE_SCHEMA, TABLE_NAME, ENGINE
from information_schema.tables
where TABLE_SCHEMA = 'ndb_ddl_test'
order by TABLE_SCHEMA, TABLE_NAME;
TABLE_SCHEMA TABLE_NAME ENGINE
ndb_ddl_test t2 ndbcluster
ndb_ddl_test t3 ndbcluster
ndb_ddl_test t4 ndbcluster
ndb_ddl_test t5 ndbcluster
ndb_ddl_test t6 ndbcluster
ndb_ddl_test t7 ndbcluster
ndb_ddl_test t8 ndbcluster
ndb_ddl_test t9 ndbcluster
select TABLE_SCHEMA, TABLE_NAME, ENGINE
from information_schema.tables
where TABLE_SCHEMA = 'ndb_ddl_test'
order by TABLE_SCHEMA, TABLE_NAME;
TABLE_SCHEMA TABLE_NAME ENGINE
ndb_ddl_test t2 ndbcluster
ndb_ddl_test t3 ndbcluster
ndb_ddl_test t4 ndbcluster
ndb_ddl_test t5 ndbcluster
ndb_ddl_test t6 ndbcluster
ndb_ddl_test t7 ndbcluster
ndb_ddl_test t8 ndbcluster
ndb_ddl_test t9 ndbcluster
ALTER TABLE t1
ENGINE=NDB;
== verify_mysql_dd.inc ==
set debug='+d,ndb_simulate_alter_failure_rename1';
ALTER TABLE ndb_ddl_test.t1 ENGINE = MyISAM;
ERROR HY000: Internal error: Simulated : Failed to rename original table to a temp name.
== verify_mysql_dd.inc ==
ALTER TABLE ndb_ddl_test.t1 ENGINE = MyISAM;
set debug='+d,ndb_simulate_alter_failure_rename2';
ALTER TABLE ndb_ddl_test.t1 ENGINE = NDB;
ERROR HY000: Internal error: Simulated : Failed to rename new table to target name.
Number of tables with temp name in NDB
0
ALTER TABLE ndb_ddl_test.t1 ENGINE = NDB;
== verify_mysql_dd.inc ==
|
