Debian Codegraph @

mysql-test/suite/ndb_ddl/alter_allow_copying.result

raw
1 select @@ndb_allow_copying_alter_table;
2 @@ndb_allow_copying_alter_table
3 1
4 set @@ndb_allow_copying_alter_table = 0;
5 ALTER TABLE t1
6 modify column b varchar(255);
7 ERROR 0A000: Implicit copying alter is not supported. Reason: ndb_allow_copying_alter_table=0. Try ALGORITHM=COPY to force the alter.
8 SHOW WARNINGS LIMIT 2;
9 Level Code Message
10 Warning 1846 Reason: 'Altering field type is not supported'
11 Error 1846 Implicit copying alter is not supported. Reason: ndb_allow_copying_alter_table=0. Try ALGORITHM=COPY to force the alter.
12 set @@ndb_allow_copying_alter_table = 0;
13 ALTER TABLE t8 ADD COLUMN VALUE_NEW VARCHAR(25) DEFAULT NULL;
14 ERROR 0A000: Implicit copying alter is not supported. Reason: ndb_allow_copying_alter_table=0. Try ALGORITHM=COPY to force the alter.
15 SHOW WARNINGS LIMIT 2;
16 Level Code Message
17 Warning 1846 Reason: 'Found hidden primary key or user defined partitioning'
18 Error 1846 Implicit copying alter is not supported. Reason: ndb_allow_copying_alter_table=0. Try ALGORITHM=COPY to force the alter.
19 set @@ndb_allow_copying_alter_table = 0;
20 ALTER TABLE t1
21 ALGORITHM=COPY,
22 modify column b varchar(255);
23 set @@ndb_allow_copying_alter_table = default;
24 select @@ndb_allow_copying_alter_table;
25 @@ndb_allow_copying_alter_table
26 1
27 set @@ndb_allow_copying_alter_table = 0;
28 set @@ndb_use_copying_alter_table = 1;
29 ALTER TABLE t1
30 add column c int;
31 ERROR 0A000: Implicit copying alter is not supported. Reason: ndb_allow_copying_alter_table=0. Try ALGORITHM=COPY to force the alter.
32 ALTER TABLE t1
33 modify column b varchar(255);
34 ERROR 0A000: Implicit copying alter is not supported. Reason: ndb_allow_copying_alter_table=0. Try ALGORITHM=COPY to force the alter.
35 ALTER TABLE t1
36 ALGORITHM=INPLACE,
37 add column c int COLUMN_FORMAT DYNAMIC;
38 ALTER TABLE t1
39 ALGORITHM=COPY,
40 add column d int;
41 set @@ndb_use_copying_alter_table = default;
42 set @@ndb_allow_copying_alter_table = default;
43 == verify_mysql_dd.inc ==