Debian Codegraph @

mysql-test/suite/ndb_ddl/alter_inplace.result

raw
1 ALTER TABLE t1 ALGORITHM=inplace, ADD INDEX a_idx1(a);
2 SELECT a FROM t1 WHERE a = 1;
3 a
4 1
5 ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX a_idx1;
6 SELECT a FROM t1 WHERE a = 4;
7 a
8 4
9 ALTER TABLE t1 ALGORITHM=inplace,
10 ADD COLUMN m VARCHAR(255) COLUMN_FORMAT DYNAMIC DEFAULT NULL;
11 UPDATE t1 SET m = CONCAT("row-", a);
12 SELECT m FROM t1 WHERE a = 3;
13 m
14 row-3
15 ALTER TABLE t1 ALGORITHM=inplace,
16 ADD COLUMN t TIMESTAMP DEFAULT CURRENT_TIMESTAMP;
17 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Adding column with non-null default value is not supported online. Try ALGORITHM=COPY.
18 ALTER TABLE t1 ALGORITHM=inplace,
19 ADD COLUMN ai INT NOT NULL UNIQUE AUTO_INCREMENT;
20 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Only add column exclusively can be performed online. Try ALGORITHM=COPY.
21 ALTER TABLE t1 ALGORITHM=inplace,
22 RENAME COLUMN b TO b_new;
23 Got one of the listed errors
24 ALTER TABLE t2 ALGORITHM=inplace, ADD INDEX a_idx1(a);
25 SELECT a FROM t2 WHERE a = 1;
26 a
27 1
28 ALTER TABLE t2 ALGORITHM=inplace, DROP INDEX a_idx1;
29 SELECT a FROM t2 WHERE a = 4;
30 a
31 4
32 ALTER TABLE t2 ALGORITHM=inplace,
33 ADD COLUMN m VARCHAR(255) COLUMN_FORMAT DYNAMIC DEFAULT NULL;
34 UPDATE t2 SET m = CONCAT("row-", a);
35 SELECT m FROM t2 WHERE a = 3;
36 m
37 row-3
38 ALTER TABLE t2 ALGORITHM=inplace,
39 ADD COLUMN t TIMESTAMP DEFAULT CURRENT_TIMESTAMP;
40 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Adding column with non-null default value is not supported online. Try ALGORITHM=COPY.
41 ALTER TABLE t2 ALGORITHM=inplace,
42 ADD COLUMN ai INT NOT NULL UNIQUE AUTO_INCREMENT;
43 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Only add column exclusively can be performed online. Try ALGORITHM=COPY.
44 ALTER TABLE t2 ALGORITHM=inplace,
45 RENAME COLUMN b TO b_new;
46 Got one of the listed errors
47 ALTER TABLE t3 ALGORITHM=inplace, ADD INDEX a_idx1(a);
48 SELECT a FROM t3 WHERE a = 1;
49 a
50 1
51 ALTER TABLE t3 ALGORITHM=inplace, DROP INDEX a_idx1;
52 SELECT a FROM t3 WHERE a = 4;
53 a
54 4
55 ALTER TABLE t3 ALGORITHM=inplace,
56 ADD COLUMN m VARCHAR(255) COLUMN_FORMAT DYNAMIC DEFAULT NULL;
57 UPDATE t3 SET m = CONCAT("row-", a);
58 SELECT m FROM t3 WHERE a = 3;
59 m
60 row-3
61 ALTER TABLE t3 ALGORITHM=inplace,
62 ADD COLUMN t TIMESTAMP DEFAULT CURRENT_TIMESTAMP;
63 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Adding column with non-null default value is not supported online. Try ALGORITHM=COPY.
64 ALTER TABLE t3 ALGORITHM=inplace,
65 ADD COLUMN ai INT NOT NULL UNIQUE AUTO_INCREMENT;
66 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Only add column exclusively can be performed online. Try ALGORITHM=COPY.
67 ALTER TABLE t3 ALGORITHM=inplace,
68 RENAME COLUMN b TO b_new;
69 Got one of the listed errors
70 ALTER TABLE t4 ALGORITHM=inplace, ADD INDEX a_idx1(a);
71 SELECT a FROM t4 WHERE a = 1;
72 a
73 1
74 ALTER TABLE t4 ALGORITHM=inplace, DROP INDEX a_idx1;
75 SELECT a FROM t4 WHERE a = 4;
76 a
77 4
78 ALTER TABLE t4 ALGORITHM=inplace,
79 ADD COLUMN m VARCHAR(255) COLUMN_FORMAT DYNAMIC DEFAULT NULL;
80 UPDATE t4 SET m = CONCAT("row-", a);
81 SELECT m FROM t4 WHERE a = 3;
82 m
83 row-3
84 ALTER TABLE t4 ALGORITHM=inplace,
85 ADD COLUMN t TIMESTAMP DEFAULT CURRENT_TIMESTAMP;
86 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Adding column with non-null default value is not supported online. Try ALGORITHM=COPY.
87 ALTER TABLE t4 ALGORITHM=inplace,
88 ADD COLUMN ai INT NOT NULL UNIQUE AUTO_INCREMENT;
89 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Only add column exclusively can be performed online. Try ALGORITHM=COPY.
90 ALTER TABLE t4 ALGORITHM=inplace,
91 RENAME COLUMN b TO b_new;
92 Got one of the listed errors
93 ALTER TABLE t5 ALGORITHM=inplace, ADD INDEX a_idx1(a);
94 SELECT a FROM t5 WHERE a = 1;
95 a
96 1
97 ALTER TABLE t5 ALGORITHM=inplace, DROP INDEX a_idx1;
98 SELECT a FROM t5 WHERE a = 4;
99 a
100 4
101 ALTER TABLE t5 ALGORITHM=inplace,
102 ADD COLUMN m VARCHAR(255) COLUMN_FORMAT DYNAMIC DEFAULT NULL;
103 UPDATE t5 SET m = CONCAT("row-", a);
104 SELECT m FROM t5 WHERE a = 3;
105 m
106 row-3
107 ALTER TABLE t5 ALGORITHM=inplace,
108 ADD COLUMN t TIMESTAMP DEFAULT CURRENT_TIMESTAMP;
109 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Adding column with non-null default value is not supported online. Try ALGORITHM=COPY.
110 ALTER TABLE t5 ALGORITHM=inplace,
111 ADD COLUMN ai INT NOT NULL UNIQUE AUTO_INCREMENT;
112 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Only add column exclusively can be performed online. Try ALGORITHM=COPY.
113 ALTER TABLE t5 ALGORITHM=inplace,
114 RENAME COLUMN b TO b_new;
115 Got one of the listed errors
116 ALTER TABLE t6 ALGORITHM=inplace, ADD INDEX a_idx1(a);
117 SELECT a FROM t6 WHERE a = 1;
118 a
119 ALTER TABLE t6 ALGORITHM=inplace, DROP INDEX a_idx1;
120 SELECT a FROM t6 WHERE a = 4;
121 a
122 ALTER TABLE t6 ALGORITHM=inplace,
123 ADD COLUMN m VARCHAR(255) DEFAULT NULL;
124 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Found hidden primary key or user defined partitioning. Try ALGORITHM=COPY.
125 ALTER TABLE t6 ALGORITHM=inplace,
126 RENAME COLUMN b TO b_new;
127 Got one of the listed errors
128 ALTER TABLE t7 ALGORITHM=inplace, ADD INDEX a_idx1(a);
129 SELECT a FROM t7 WHERE a = 1;
130 a
131 1
132 ALTER TABLE t7 ALGORITHM=inplace, DROP INDEX a_idx1;
133 SELECT a FROM t7 WHERE a = 4;
134 a
135 4
136 ALTER TABLE t7 ALGORITHM=inplace,
137 ADD COLUMN m VARCHAR(255) COLUMN_FORMAT DYNAMIC DEFAULT NULL;
138 UPDATE t7 SET m = CONCAT("row-", a);
139 SELECT m FROM t7 WHERE a = 3;
140 m
141 row-3
142 ALTER TABLE t7 ALGORITHM=inplace,
143 ADD COLUMN t TIMESTAMP DEFAULT CURRENT_TIMESTAMP;
144 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Adding column with non-null default value is not supported online. Try ALGORITHM=COPY.
145 ALTER TABLE t7 ALGORITHM=inplace,
146 ADD COLUMN ai INT NOT NULL UNIQUE AUTO_INCREMENT;
147 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Only add column exclusively can be performed online. Try ALGORITHM=COPY.
148 ALTER TABLE t7 ALGORITHM=inplace,
149 RENAME COLUMN b TO b_new;
150 SELECT b_new FROM t7 WHERE a = 4;
151 b_new
152 4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b4b
153 ALTER TABLE t7 ALGORITHM=inplace,
154 RENAME COLUMN b_new TO b;
155 ALTER TABLE t8 ALGORITHM=inplace, ADD INDEX a_idx1(a);
156 SELECT a FROM t8 WHERE a = 1;
157 a
158 1
159 ALTER TABLE t8 ALGORITHM=inplace, DROP INDEX a_idx1;
160 SELECT a FROM t8 WHERE a = 4;
161 a
162 4
163 ALTER TABLE t8 ALGORITHM=inplace,
164 ADD COLUMN m VARCHAR(255) DEFAULT NULL;
165 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Found hidden primary key or user defined partitioning. Try ALGORITHM=COPY.
166 ALTER TABLE t8 ALGORITHM=inplace,
167 RENAME COLUMN b TO b_new;
168 SELECT b_new FROM t8 WHERE a = 4;
169 b_new
170 4-t8
171 ALTER TABLE t8 ALGORITHM=inplace,
172 RENAME COLUMN b_new TO b;
173 ALTER TABLE t9 ALGORITHM=inplace, ADD INDEX a_idx1(a);
174 SELECT a FROM t9 WHERE a = 1;
175 a
176 1
177 ALTER TABLE t9 ALGORITHM=inplace, DROP INDEX a_idx1;
178 SELECT a FROM t9 WHERE a = 4;
179 a
180 4
181 ALTER TABLE t9 ALGORITHM=inplace,
182 ADD COLUMN m VARCHAR(255) DEFAULT NULL;
183 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Found hidden primary key or user defined partitioning. Try ALGORITHM=COPY.
184 ALTER TABLE t9 ALGORITHM=inplace,
185 RENAME COLUMN b TO b_new;
186 SELECT b_new FROM t9 WHERE a = 4;
187 b_new
188 4-t9
189 ALTER TABLE t9 ALGORITHM=inplace,
190 RENAME COLUMN b_new TO b;
191 == verify_mysql_dd.inc ==