Debian Codegraph @

mysql-test/suite/ndb_ddl/schema_dist_upgrade.result

raw
1 select @@ndb_schema_dist_upgrade_allowed;
2 @@ndb_schema_dist_upgrade_allowed
3 0
4 set @@ndb_schema_dist_upgrade_allowed = true;
5 ERROR HY000: Variable 'ndb_schema_dist_upgrade_allowed' is a read only variable
6 include/assert_grep.inc [Detect initial start in MySQL Server 6]
7 include/assert_grep.inc [Detect initial start in MySQL Server 5]
8 include/assert_grep.inc [Detect initial start in MySQL Server 4]
9 include/assert_grep.inc [Detect initial start in MySQL Server 3]
10 include/assert_grep.inc [Detect initial start in MySQL Server 2]
11 include/assert_grep.inc [Detect initial start in MySQL Server 1]
12 CREATE TABLE t1(
13 pk int not null,
14 a varchar(37) not null
15 ) ENGINE = NDB;
16 Warnings:
17 Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
18 INSERT INTO t1 VALUES(1, "hello");
19 ALTER TABLE t1 ADD COLUMN b int NULL DEFAULT 24;
20 Warnings:
21 Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
22 Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
23 ALTER TABLE t1 MODIFY COLUMN b int NOT NULL;
24 Warnings:
25 Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
26 Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
27 SELECT * FROM t1;
28 pk a b
29 1 hello 24
30 DROP TABLE t1;
31 Warnings:
32 Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
33 # restart: --ndb-schema-dist-upgrade-allowed=true --debug=-d,ndb_schema_skip_create_schema_op_id
34 select @@ndb_schema_dist_upgrade_allowed;
35 @@ndb_schema_dist_upgrade_allowed
36 1
37 include/assert_grep.inc [Detect normal system restart in MySQL Server 1]
38 CREATE TABLE t1(
39 pk int not null,
40 a varchar(37) not null
41 ) ENGINE = NDB;
42 INSERT INTO t1 VALUES(1, "hello");
43 ALTER TABLE t1 ADD COLUMN b int NULL DEFAULT 24;
44 ALTER TABLE t1 MODIFY COLUMN b int NOT NULL;
45 SELECT * FROM t1;
46 pk a b
47 1 hello 24
48 DROP TABLE t1;
49 Checking mysqld6
50 include/assert_grep.inc [Detect schema dist setup in MySQL Server 6]
51 CREATE TABLE t1(
52 pk int not null,
53 a varchar(37) not null
54 ) ENGINE = NDB;
55 INSERT INTO t1 VALUES(1, "hello");
56 ALTER TABLE t1 ADD COLUMN b int NULL DEFAULT 24;
57 ALTER TABLE t1 MODIFY COLUMN b int NOT NULL;
58 SELECT * FROM t1;
59 pk a b
60 1 hello 24
61 DROP TABLE t1;
62 Checking mysqld5
63 include/assert_grep.inc [Detect schema dist setup in MySQL Server 5]
64 CREATE TABLE t1(
65 pk int not null,
66 a varchar(37) not null
67 ) ENGINE = NDB;
68 INSERT INTO t1 VALUES(1, "hello");
69 ALTER TABLE t1 ADD COLUMN b int NULL DEFAULT 24;
70 ALTER TABLE t1 MODIFY COLUMN b int NOT NULL;
71 SELECT * FROM t1;
72 pk a b
73 1 hello 24
74 DROP TABLE t1;
75 Checking mysqld4
76 include/assert_grep.inc [Detect schema dist setup in MySQL Server 4]
77 CREATE TABLE t1(
78 pk int not null,
79 a varchar(37) not null
80 ) ENGINE = NDB;
81 INSERT INTO t1 VALUES(1, "hello");
82 ALTER TABLE t1 ADD COLUMN b int NULL DEFAULT 24;
83 ALTER TABLE t1 MODIFY COLUMN b int NOT NULL;
84 SELECT * FROM t1;
85 pk a b
86 1 hello 24
87 DROP TABLE t1;
88 Checking mysqld3
89 include/assert_grep.inc [Detect schema dist setup in MySQL Server 3]
90 CREATE TABLE t1(
91 pk int not null,
92 a varchar(37) not null
93 ) ENGINE = NDB;
94 INSERT INTO t1 VALUES(1, "hello");
95 ALTER TABLE t1 ADD COLUMN b int NULL DEFAULT 24;
96 ALTER TABLE t1 MODIFY COLUMN b int NOT NULL;
97 SELECT * FROM t1;
98 pk a b
99 1 hello 24
100 DROP TABLE t1;
101 Checking mysqld2
102 include/assert_grep.inc [Detect schema dist setup in MySQL Server 2]
103 CREATE TABLE t1(
104 pk int not null,
105 a varchar(37) not null
106 ) ENGINE = NDB;
107 INSERT INTO t1 VALUES(1, "hello");
108 ALTER TABLE t1 ADD COLUMN b int NULL DEFAULT 24;
109 ALTER TABLE t1 MODIFY COLUMN b int NOT NULL;
110 SELECT * FROM t1;
111 pk a b
112 1 hello 24
113 DROP TABLE t1;