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
|
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.
SHOW WARNINGS LIMIT 2;
Level Code Message
Warning 1846 Reason: 'Altering field type is not supported'
Error 1846 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 t8 ADD COLUMN VALUE_NEW VARCHAR(25) DEFAULT NULL;
ERROR 0A000: Implicit copying alter is not supported. Reason: ndb_allow_copying_alter_table=0. Try ALGORITHM=COPY to force the alter.
SHOW WARNINGS LIMIT 2;
Level Code Message
Warning 1846 Reason: 'Found hidden primary key or user defined partitioning'
Error 1846 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 ==
|
