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
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
|
CREATE TABLE t1 (
a int PRIMARY KEY,
b varchar(255)
) ENGINE NDB;
SHOW TABLES;
Tables_in_test
t1
SHOW TABLES;
Tables_in_test
t1
SHOW TABLES;
Tables_in_test
t1
SHOW TABLES;
Tables_in_test
t1
SHOW TABLES;
Tables_in_test
t1
SHOW TABLES;
Tables_in_test
t1
Drop the table using ndb_drop_table
SHOW CREATE TABLE t1;
ERROR HY000: Table definition has changed, please retry transaction
SHOW WARNINGS;
Level Code Message
Warning 1296 Got error 284 'Table not defined in transaction coordinator' from NDB
Error 1412 Table definition has changed, please retry transaction
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
SHOW TABLES;
Tables_in_test
SHOW TABLES;
Tables_in_test
SHOW TABLES;
Tables_in_test
SHOW TABLES;
Tables_in_test
SHOW TABLES;
Tables_in_test
No event found for 'test.t1'
CREATE TABLE t1 (
a int,
b varchar(255)
) ENGINE NDB;
SHOW TABLES;
Tables_in_test
t1
SHOW TABLES;
Tables_in_test
t1
SHOW TABLES;
Tables_in_test
t1
SHOW TABLES;
Tables_in_test
t1
SHOW TABLES;
Tables_in_test
t1
SHOW TABLES;
Tables_in_test
t1
Drop the table using ndb_drop_table
SHOW CREATE TABLE t1;
ERROR HY000: Table definition has changed, please retry transaction
SHOW WARNINGS;
Level Code Message
Warning 1296 Got error 284 'Table not defined in transaction coordinator' from NDB
Error 1412 Table definition has changed, please retry transaction
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
SHOW TABLES;
Tables_in_test
SHOW TABLES;
Tables_in_test
SHOW TABLES;
Tables_in_test
SHOW TABLES;
Tables_in_test
SHOW TABLES;
Tables_in_test
CREATE DATABASE ndb_ddl_test3;
USE ndb_ddl_test3;
CREATE TABLE t1 (
a int PRIMARY KEY,
b varchar(255)
) ENGINE NDB;
CREATE TABLE t2 (
a int PRIMARY KEY,
b varchar(255)
) ENGINE NDB;
SHOW TABLES IN ndb_ddl_test3;
Tables_in_ndb_ddl_test3
t1
t2
SHOW TABLES IN ndb_ddl_test3;
Tables_in_ndb_ddl_test3
t1
t2
SHOW TABLES IN ndb_ddl_test3;
Tables_in_ndb_ddl_test3
t1
t2
SHOW TABLES IN ndb_ddl_test3;
Tables_in_ndb_ddl_test3
t1
t2
SHOW TABLES IN ndb_ddl_test3;
Tables_in_ndb_ddl_test3
t1
t2
SHOW TABLES IN ndb_ddl_test3;
Tables_in_ndb_ddl_test3
t1
t2
Drop the table using ndb_drop_table
DROP DATABASE ndb_ddl_test3;
No event found for 'ndb_ddl_test3.t1'
No event found for 'ndb_ddl_test3.t2'
CREATE DATABASE ndb_ddl_test3;
USE ndb_ddl_test3;
CREATE TABLE t1 (
a int PRIMARY KEY,
b varchar(255)
) ENGINE NDB;
DROP DATABASE ndb_ddl_test3;
|
