102 lines
2.7 KiB
Plaintext
102 lines
2.7 KiB
Plaintext
select @@ndb_schema_dist_upgrade_allowed;
|
|
@@ndb_schema_dist_upgrade_allowed
|
|
0
|
|
set @@ndb_schema_dist_upgrade_allowed = true;
|
|
ERROR HY000: Variable 'ndb_schema_dist_upgrade_allowed' is a read only variable
|
|
CREATE TABLE t1(
|
|
pk int not null,
|
|
a varchar(37) not null
|
|
) ENGINE = NDB;
|
|
Warnings:
|
|
Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
|
|
INSERT INTO t1 VALUES(1, "hello");
|
|
ALTER TABLE t1 ADD COLUMN b int NULL DEFAULT 24;
|
|
Warnings:
|
|
Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
|
|
Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
|
|
ALTER TABLE t1 MODIFY COLUMN b int NOT NULL;
|
|
Warnings:
|
|
Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
|
|
Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
|
|
SELECT * FROM t1;
|
|
pk a b
|
|
1 hello 24
|
|
DROP TABLE t1;
|
|
Warnings:
|
|
Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
|
|
# restart: --ndb-schema-dist-upgrade-allowed=true --debug=-d,ndb_schema_skip_create_schema_op_id
|
|
select @@ndb_schema_dist_upgrade_allowed;
|
|
@@ndb_schema_dist_upgrade_allowed
|
|
1
|
|
CREATE TABLE t1(
|
|
pk int not null,
|
|
a varchar(37) not null
|
|
) ENGINE = NDB;
|
|
INSERT INTO t1 VALUES(1, "hello");
|
|
ALTER TABLE t1 ADD COLUMN b int NULL DEFAULT 24;
|
|
ALTER TABLE t1 MODIFY COLUMN b int NOT NULL;
|
|
SELECT * FROM t1;
|
|
pk a b
|
|
1 hello 24
|
|
DROP TABLE t1;
|
|
Checking mysqld6
|
|
CREATE TABLE t1(
|
|
pk int not null,
|
|
a varchar(37) not null
|
|
) ENGINE = NDB;
|
|
INSERT INTO t1 VALUES(1, "hello");
|
|
ALTER TABLE t1 ADD COLUMN b int NULL DEFAULT 24;
|
|
ALTER TABLE t1 MODIFY COLUMN b int NOT NULL;
|
|
SELECT * FROM t1;
|
|
pk a b
|
|
1 hello 24
|
|
DROP TABLE t1;
|
|
Checking mysqld5
|
|
CREATE TABLE t1(
|
|
pk int not null,
|
|
a varchar(37) not null
|
|
) ENGINE = NDB;
|
|
INSERT INTO t1 VALUES(1, "hello");
|
|
ALTER TABLE t1 ADD COLUMN b int NULL DEFAULT 24;
|
|
ALTER TABLE t1 MODIFY COLUMN b int NOT NULL;
|
|
SELECT * FROM t1;
|
|
pk a b
|
|
1 hello 24
|
|
DROP TABLE t1;
|
|
Checking mysqld4
|
|
CREATE TABLE t1(
|
|
pk int not null,
|
|
a varchar(37) not null
|
|
) ENGINE = NDB;
|
|
INSERT INTO t1 VALUES(1, "hello");
|
|
ALTER TABLE t1 ADD COLUMN b int NULL DEFAULT 24;
|
|
ALTER TABLE t1 MODIFY COLUMN b int NOT NULL;
|
|
SELECT * FROM t1;
|
|
pk a b
|
|
1 hello 24
|
|
DROP TABLE t1;
|
|
Checking mysqld3
|
|
CREATE TABLE t1(
|
|
pk int not null,
|
|
a varchar(37) not null
|
|
) ENGINE = NDB;
|
|
INSERT INTO t1 VALUES(1, "hello");
|
|
ALTER TABLE t1 ADD COLUMN b int NULL DEFAULT 24;
|
|
ALTER TABLE t1 MODIFY COLUMN b int NOT NULL;
|
|
SELECT * FROM t1;
|
|
pk a b
|
|
1 hello 24
|
|
DROP TABLE t1;
|
|
Checking mysqld2
|
|
CREATE TABLE t1(
|
|
pk int not null,
|
|
a varchar(37) not null
|
|
) ENGINE = NDB;
|
|
INSERT INTO t1 VALUES(1, "hello");
|
|
ALTER TABLE t1 ADD COLUMN b int NULL DEFAULT 24;
|
|
ALTER TABLE t1 MODIFY COLUMN b int NOT NULL;
|
|
SELECT * FROM t1;
|
|
pk a b
|
|
1 hello 24
|
|
DROP TABLE t1;
|