Debian Codegraph @

mysql-test/suite/ndb_ddl/schema_dist_deferred_upgrade.result

raw
1 # Verify that NDB SE DDLs are blocked in all MySQL Servers
2 create table t1 (a int) engine ndb;
3 ERROR HY000: DDLs are disallowed on NDB SE as there is at least one node without MySQL DD support connected to the cluster.
4 create table t1 (a int) engine ndb;
5 ERROR HY000: DDLs are disallowed on NDB SE as there is at least one node without MySQL DD support connected to the cluster.
6 create table t1 (a int) engine ndb;
7 ERROR HY000: DDLs are disallowed on NDB SE as there is at least one node without MySQL DD support connected to the cluster.
8 create table t1 (a int) engine ndb;
9 ERROR HY000: DDLs are disallowed on NDB SE as there is at least one node without MySQL DD support connected to the cluster.
10 create table t1 (a int) engine ndb;
11 ERROR HY000: DDLs are disallowed on NDB SE as there is at least one node without MySQL DD support connected to the cluster.
12 create table t1 (a int) engine ndb;
13 ERROR HY000: DDLs are disallowed on NDB SE as there is at least one node without MySQL DD support connected to the cluster.
14 # Verify that the ndb_schema table was not upgraded
15 Is 'mysql.ndb_schema' table upgraded?
16 No
17 # Verify that DDLs are allowed when MySQL Server see all API nodes as
18 # upgraded to version supporting new MySQL DD
19 set GLOBAL debug="-d,ndb_simulate_upgrade_from_non_dd_version";
20 create table t1 (a int) engine ndb;
21 Warnings:
22 Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
23 drop table t1;
24 Warnings:
25 Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
26 set GLOBAL debug="-d,ndb_simulate_upgrade_from_non_dd_version";
27 create table t1 (a int) engine ndb;
28 Warnings:
29 Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
30 drop table t1;
31 Warnings:
32 Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
33 set GLOBAL debug="-d,ndb_simulate_upgrade_from_non_dd_version";
34 create table t1 (a int) engine ndb;
35 Warnings:
36 Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
37 drop table t1;
38 Warnings:
39 Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
40 set GLOBAL debug="-d,ndb_simulate_upgrade_from_non_dd_version";
41 create table t1 (a int) engine ndb;
42 Warnings:
43 Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
44 drop table t1;
45 Warnings:
46 Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
47 set GLOBAL debug="-d,ndb_simulate_upgrade_from_non_dd_version";
48 create table t1 (a int) engine ndb;
49 Warnings:
50 Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
51 drop table t1;
52 Warnings:
53 Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
54 set GLOBAL debug="-d,ndb_simulate_upgrade_from_non_dd_version";
55 create table t1 (a int) engine ndb;
56 Warnings:
57 Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
58 drop table t1;
59 Warnings:
60 Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
61 # ndb_schema will be upgraded only when a MySQL Server restarts
62 Is 'mysql.ndb_schema' table upgraded?
63 No
64 # Restart first MySQL Server to trigger schema distribution upgrade, the
65 # other Servers will pick it up gracefully
66 # restart: --debug=-d,ndb_simulate_upgrade_from_non_dd_version,ndb_schema_skip_create_schema_op_id
67 # Verify that the ndb_schema table was upgraded
68 Is 'mysql.ndb_schema' table upgraded?
69 Yes
70 Checking mysqld1
71 # Verify DDLs and DMLs
72 create table t1(
73 pk int not null,
74 a varchar(37) not null
75 ) engine ndb;
76 insert into t1 values (1, "hello");
77 alter table t1 add column b int null default 24;
78 alter table t1 modify column b int not null;
79 select * from t1;
80 pk a b
81 1 hello 24
82 drop table t1;
83 Checking mysqld2
84 # Verify DDLs and DMLs
85 create table t1(
86 pk int not null,
87 a varchar(37) not null
88 ) engine ndb;
89 insert into t1 values (1, "hello");
90 alter table t1 add column b int null default 24;
91 alter table t1 modify column b int not null;
92 select * from t1;
93 pk a b
94 1 hello 24
95 drop table t1;
96 Checking mysqld3
97 # Verify DDLs and DMLs
98 create table t1(
99 pk int not null,
100 a varchar(37) not null
101 ) engine ndb;
102 insert into t1 values (1, "hello");
103 alter table t1 add column b int null default 24;
104 alter table t1 modify column b int not null;
105 select * from t1;
106 pk a b
107 1 hello 24
108 drop table t1;
109 Checking mysqld4
110 # Verify DDLs and DMLs
111 create table t1(
112 pk int not null,
113 a varchar(37) not null
114 ) engine ndb;
115 insert into t1 values (1, "hello");
116 alter table t1 add column b int null default 24;
117 alter table t1 modify column b int not null;
118 select * from t1;
119 pk a b
120 1 hello 24
121 drop table t1;
122 Checking mysqld5
123 # Verify DDLs and DMLs
124 create table t1(
125 pk int not null,
126 a varchar(37) not null
127 ) engine ndb;
128 insert into t1 values (1, "hello");
129 alter table t1 add column b int null default 24;
130 alter table t1 modify column b int not null;
131 select * from t1;
132 pk a b
133 1 hello 24
134 drop table t1;
135 Checking mysqld6
136 # Verify DDLs and DMLs
137 create table t1(
138 pk int not null,
139 a varchar(37) not null
140 ) engine ndb;
141 insert into t1 values (1, "hello");
142 alter table t1 add column b int null default 24;
143 alter table t1 modify column b int not null;
144 select * from t1;
145 pk a b
146 1 hello 24
147 drop table t1;