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
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
|
--source setup.inc
# Test that it's possible to turn off copying ALTER TABLE by
# setting ndb_allow_copying_alter_table = 0. This means that
# only queries which automatically are performed inplace or were
# user explicitly requested ALGORITHM=COPY will
# be allowed
#
# Check the default value of ndb_allow_copying_alter_table
select @@ndb_allow_copying_alter_table;
#
# 1) Query fails since implicit copying alter is not allowed
#
set @@ndb_allow_copying_alter_table = 0;
--error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
ALTER TABLE t1
modify column b varchar(255);
SHOW WARNINGS LIMIT 2;
#
# 1b) Query fails since implicit copying alter is not allowed
# - reason explaining that table with hidden primary key
# does not support inplace alter table
#
set @@ndb_allow_copying_alter_table = 0;
--error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
ALTER TABLE t8 ADD COLUMN VALUE_NEW VARCHAR(25) DEFAULT NULL;
SHOW WARNINGS LIMIT 2;
#
# 2) Query is allowed since user explicitly requested ALGORITHM=COPY
# and that overrides ndb_allow_copying_alter_table=0
#
set @@ndb_allow_copying_alter_table = 0;
ALTER TABLE t1
ALGORITHM=COPY,
modify column b varchar(255);
# Set variable back to default and check
set @@ndb_allow_copying_alter_table = default;
select @@ndb_allow_copying_alter_table;
#
# Check combination with ndb_use_copying_alter_table, which
# forces usage of copying alter table unless ALGORITHM=INPLACE
# has been specified
#
set @@ndb_allow_copying_alter_table = 0;
set @@ndb_use_copying_alter_table = 1;
# Implicit inplace alter, use_copying -> error because of allow_copying
--error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
ALTER TABLE t1
add column c int;
# Implicit copying alter, use_copying -> error because of allow_copying
--error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
ALTER TABLE t1
modify column b varchar(255);
# Explicit inplace alter, allowed
ALTER TABLE t1
ALGORITHM=INPLACE,
add column c int COLUMN_FORMAT DYNAMIC;
# Explicit copying alter, works as it overrides ndb_allow_copying_alter_table
ALTER TABLE t1
ALGORITHM=COPY,
add column d int;
set @@ndb_use_copying_alter_table = default;
set @@ndb_allow_copying_alter_table = default;
--source verify_mysql_dd.inc
--source cleanup.inc
|
