33 lines
1.2 KiB
Plaintext
33 lines
1.2 KiB
Plaintext
select @@ndb_allow_copying_alter_table;
|
|
@@ndb_allow_copying_alter_table
|
|
1
|
|
set @@ndb_allow_copying_alter_table = 0;
|
|
ALTER TABLE t1
|
|
modify column b varchar(255);
|
|
ERROR 0A000: Implicit copying alter is not supported. Reason: ndb_allow_copying_alter_table=0. Try ALGORITHM=COPY to force the alter.
|
|
set @@ndb_allow_copying_alter_table = 0;
|
|
ALTER TABLE t1
|
|
ALGORITHM=COPY,
|
|
modify column b varchar(255);
|
|
set @@ndb_allow_copying_alter_table = default;
|
|
select @@ndb_allow_copying_alter_table;
|
|
@@ndb_allow_copying_alter_table
|
|
1
|
|
set @@ndb_allow_copying_alter_table = 0;
|
|
set @@ndb_use_copying_alter_table = 1;
|
|
ALTER TABLE t1
|
|
add column c int;
|
|
ERROR 0A000: Implicit copying alter is not supported. Reason: ndb_allow_copying_alter_table=0. Try ALGORITHM=COPY to force the alter.
|
|
ALTER TABLE t1
|
|
modify column b varchar(255);
|
|
ERROR 0A000: Implicit copying alter is not supported. Reason: ndb_allow_copying_alter_table=0. Try ALGORITHM=COPY to force the alter.
|
|
ALTER TABLE t1
|
|
ALGORITHM=INPLACE,
|
|
add column c int COLUMN_FORMAT DYNAMIC;
|
|
ALTER TABLE t1
|
|
ALGORITHM=COPY,
|
|
add column d int;
|
|
set @@ndb_use_copying_alter_table = default;
|
|
set @@ndb_allow_copying_alter_table = default;
|
|
== verify_mysql_dd.inc ==
|