Debian Codegraph @

mysql-test/suite/ndb_ddl/drop_table_consistency.result

raw
1 CREATE TABLE t1 (
2 a int PRIMARY KEY,
3 b varchar(255)
4 ) ENGINE NDB;
5 SHOW TABLES;
6 Tables_in_test
7 t1
8 SHOW TABLES;
9 Tables_in_test
10 t1
11 SHOW TABLES;
12 Tables_in_test
13 t1
14 SHOW TABLES;
15 Tables_in_test
16 t1
17 SHOW TABLES;
18 Tables_in_test
19 t1
20 SHOW TABLES;
21 Tables_in_test
22 t1
23 Drop the table using ndb_drop_table
24 SHOW CREATE TABLE t1;
25 ERROR HY000: Table definition has changed, please retry transaction
26 SHOW WARNINGS;
27 Level Code Message
28 Warning 1296 Got error 284 'Table not defined in transaction coordinator' from NDB
29 Error 1412 Table definition has changed, please retry transaction
30 DROP TABLE t1;
31 SHOW TABLES;
32 Tables_in_test
33 SHOW TABLES;
34 Tables_in_test
35 SHOW TABLES;
36 Tables_in_test
37 SHOW TABLES;
38 Tables_in_test
39 SHOW TABLES;
40 Tables_in_test
41 SHOW TABLES;
42 Tables_in_test
43 No event found for 'test.t1'
44 CREATE TABLE t1 (
45 a int,
46 b varchar(255)
47 ) ENGINE NDB;
48 SHOW TABLES;
49 Tables_in_test
50 t1
51 SHOW TABLES;
52 Tables_in_test
53 t1
54 SHOW TABLES;
55 Tables_in_test
56 t1
57 SHOW TABLES;
58 Tables_in_test
59 t1
60 SHOW TABLES;
61 Tables_in_test
62 t1
63 SHOW TABLES;
64 Tables_in_test
65 t1
66 Drop the table using ndb_drop_table
67 SHOW CREATE TABLE t1;
68 ERROR HY000: Table definition has changed, please retry transaction
69 SHOW WARNINGS;
70 Level Code Message
71 Warning 1296 Got error 284 'Table not defined in transaction coordinator' from NDB
72 Error 1412 Table definition has changed, please retry transaction
73 DROP TABLE t1;
74 SHOW TABLES;
75 Tables_in_test
76 SHOW TABLES;
77 Tables_in_test
78 SHOW TABLES;
79 Tables_in_test
80 SHOW TABLES;
81 Tables_in_test
82 SHOW TABLES;
83 Tables_in_test
84 SHOW TABLES;
85 Tables_in_test
86 CREATE DATABASE ndb_ddl_test3;
87 USE ndb_ddl_test3;
88 CREATE TABLE t1 (
89 a int PRIMARY KEY,
90 b varchar(255)
91 ) ENGINE NDB;
92 CREATE TABLE t2 (
93 a int PRIMARY KEY,
94 b varchar(255)
95 ) ENGINE NDB;
96 SHOW TABLES IN ndb_ddl_test3;
97 Tables_in_ndb_ddl_test3
98 t1
99 t2
100 SHOW TABLES IN ndb_ddl_test3;
101 Tables_in_ndb_ddl_test3
102 t1
103 t2
104 SHOW TABLES IN ndb_ddl_test3;
105 Tables_in_ndb_ddl_test3
106 t1
107 t2
108 SHOW TABLES IN ndb_ddl_test3;
109 Tables_in_ndb_ddl_test3
110 t1
111 t2
112 SHOW TABLES IN ndb_ddl_test3;
113 Tables_in_ndb_ddl_test3
114 t1
115 t2
116 SHOW TABLES IN ndb_ddl_test3;
117 Tables_in_ndb_ddl_test3
118 t1
119 t2
120 Drop the table using ndb_drop_table
121 DROP DATABASE ndb_ddl_test3;
122 No event found for 'ndb_ddl_test3.t1'
123 No event found for 'ndb_ddl_test3.t2'
124 CREATE DATABASE ndb_ddl_test3;
125 USE ndb_ddl_test3;
126 CREATE TABLE t1 (
127 a int PRIMARY KEY,
128 b varchar(255)
129 ) ENGINE NDB;
130 DROP DATABASE ndb_ddl_test3;