Debian Codegraph @

mysql-test/suite/ndb_ddl/alter_engine_myisam.result

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