Debian Codegraph @

mysql-test/suite/innodb/r/alter_not_null.result

raw
1 #
2 # sql_mode: alter_algorithm: COPY
3 #
4 CREATE TABLE t1(f1 INT)ENGINE=INNODB;
5 INSERT INTO t1 VALUES(NULL);
6 SELECT * FROM t1;
7 f1
8 NULL
9 ALTER TABLE t1 CHANGE f1 f1 INT NOT NULL, ALGORITHM=COPY;
10 affected rows: 1
11 info: Records: 1 Duplicates: 0 Warnings: 1
12 Warnings:
13 Warning 1265 Data truncated for column 'f1' at row 1
14 SELECT * FROM t1;
15 f1
16 0
17 DROP TABLE t1;
18 CREATE TABLE t1(f1 CHAR(10))ENGINE=INNODB;
19 INSERT INTO t1 VALUES(NULL);
20 SELECT * FROM t1;
21 f1
22 NULL
23 ALTER TABLE t1 CHANGE f1 f1 CHAR(10) NOT NULL, ALGORITHM=COPY;
24 affected rows: 1
25 info: Records: 1 Duplicates: 0 Warnings: 1
26 Warnings:
27 Warning 1265 Data truncated for column 'f1' at row 1
28 SELECT * FROM t1;
29 f1
30
31 DROP TABLE t1;
32 CREATE TABLE t1(f1 VARCHAR(10))ENGINE=INNODB;
33 INSERT INTO t1 VALUES(NULL);
34 SELECT * FROM t1;
35 f1
36 NULL
37 ALTER TABLE t1 CHANGE f1 f1 VARCHAR(20) NOT NULL, ALGORITHM=COPY;
38 affected rows: 1
39 info: Records: 1 Duplicates: 0 Warnings: 1
40 Warnings:
41 Warning 1265 Data truncated for column 'f1' at row 1
42 SELECT * FROM t1;
43 f1
44
45 DROP TABLE t1;
46 CREATE TABLE t1(f1 TEXT)ENGINE=INNODB;
47 INSERT INTO t1 VALUES(NULL);
48 SELECT * FROM t1;
49 f1
50 NULL
51 ALTER TABLE t1 CHANGE f1 f1 TEXT NOT NULL DEFAULT 'abc', ALGORITHM=COPY;
52 affected rows: 1
53 info: Records: 1 Duplicates: 0 Warnings: 1
54 Warnings:
55 Warning 1265 Data truncated for column 'f1' at row 1
56 SELECT * FROM t1;
57 f1
58
59 DROP TABLE t1;
60 CREATE TABLE t1(f1 INT NOT NULL, f2 INT NOT NULL, f3 INT)ENGINE=INNODB;
61 INSERT INTO t1 VALUES(2, 2, NULL);
62 SELECT * FROM t1;
63 f1 f2 f3
64 2 2 NULL
65 ALTER TABLE t1 CHANGE f3 f3 INT NOT NULL DEFAULT (f1 + f2), ALGORITHM=COPY;
66 affected rows: 1
67 info: Records: 1 Duplicates: 0 Warnings: 1
68 Warnings:
69 Warning 1265 Data truncated for column 'f3' at row 1
70 SELECT * FROM t1;
71 f1 f2 f3
72 2 2 0
73 DROP TABLE t1;
74 CREATE TABLE t1(f1 INT NOT NULL DEFAULT 0, b TINYINT)ENGINE=InnoDB;
75 INSERT INTO t1 VALUES(10, NULL);
76 SELECT * FROM t1;
77 f1 b
78 10 NULL
79 ALTER TABLE t1 CHANGE b b TINYINT NOT NULL DEFAULT if(unix_timestamp()>1,1000,0), ALGORITHM=COPY;
80 affected rows: 1
81 info: Records: 1 Duplicates: 0 Warnings: 1
82 Warnings:
83 Warning 1265 Data truncated for column 'b' at row 1
84 SELECT * FROM t1;
85 f1 b
86 10 0
87 DROP TABLE t1;
88 CREATE TABLE t1(a INT, v INT AS (a), c INT, d INT NOT NULL, e INT) ENGINE=InnoDB;
89 ALTER TABLE t1 DROP COLUMN c, CHANGE COLUMN e e INT NOT NULL, ALGORITHM=COPY;
90 affected rows: 0
91 info: Records: 0 Duplicates: 0 Warnings: 0
92 DROP TABLE t1;
93 CREATE TABLE t1 (a INT, v INT AS (a), d INT NOT NULL, e INT) ENGINE=InnoDB;
94 ALTER TABLE t1 FORCE, ALGORITHM=COPY;
95 affected rows: 0
96 info: Records: 0 Duplicates: 0 Warnings: 0
97 DROP TABLE t1;
98 CREATE TABLE t1(c1 INT NOT NULL, c2 INT, PRIMARY KEY(c1))ENGINE=INNODB;
99 INSERT INTO t1 VALUES(1, NULL);
100 ALTER IGNORE TABLE t1 CHANGE c2 c2 INT NOT NULL DEFAULT 2;
101 affected rows: 0
102 info: Records: 0 Duplicates: 0 Warnings: 1
103 Warnings:
104 Warning 1265 Data truncated for column 'c2' at row 1
105 SELECT * FROM t1;
106 c1 c2
107 1 0
108 DROP TABLE t1;
109 #
110 # MDEV-16126 Crash or ASAN heap-buffer-overflow in
111 # mach_read_from_n_little_endian upon ALTER TABLE with blob
112 #
113 CREATE TABLE t1(a INT, v INT AS (a), b INT, c BLOB) ENGINE=InnoDB;
114 ALTER TABLE t1 ADD PRIMARY KEY(b), ALGORITHM=COPY;
115 affected rows: 0
116 info: Records: 0 Duplicates: 0 Warnings: 0
117 DROP TABLE t1;
118 #
119 # sql_mode: alter_algorithm: INPLACE
120 #
121 CREATE TABLE t1(f1 INT)ENGINE=INNODB;
122 INSERT INTO t1 VALUES(NULL);
123 SELECT * FROM t1;
124 f1
125 NULL
126 ALTER TABLE t1 CHANGE f1 f1 INT NOT NULL, ALGORITHM=INPLACE;
127 affected rows: 0
128 info: Records: 0 Duplicates: 0 Warnings: 1
129 Warnings:
130 Warning 1265 Data truncated for column 'f1' at row 1
131 SELECT * FROM t1;
132 f1
133 0
134 DROP TABLE t1;
135 CREATE TABLE t1(f1 CHAR(10))ENGINE=INNODB;
136 INSERT INTO t1 VALUES(NULL);
137 SELECT * FROM t1;
138 f1
139 NULL
140 ALTER TABLE t1 CHANGE f1 f1 CHAR(10) NOT NULL, ALGORITHM=INPLACE;
141 affected rows: 0
142 info: Records: 0 Duplicates: 0 Warnings: 1
143 Warnings:
144 Warning 1265 Data truncated for column 'f1' at row 1
145 SELECT * FROM t1;
146 f1
147
148 DROP TABLE t1;
149 CREATE TABLE t1(f1 VARCHAR(10))ENGINE=INNODB;
150 INSERT INTO t1 VALUES(NULL);
151 SELECT * FROM t1;
152 f1
153 NULL
154 ALTER TABLE t1 CHANGE f1 f1 VARCHAR(20) NOT NULL, ALGORITHM=INPLACE;
155 affected rows: 0
156 info: Records: 0 Duplicates: 0 Warnings: 1
157 Warnings:
158 Warning 1265 Data truncated for column 'f1' at row 1
159 SELECT * FROM t1;
160 f1
161
162 DROP TABLE t1;
163 CREATE TABLE t1(f1 TEXT)ENGINE=INNODB;
164 INSERT INTO t1 VALUES(NULL);
165 SELECT * FROM t1;
166 f1
167 NULL
168 ALTER TABLE t1 CHANGE f1 f1 TEXT NOT NULL DEFAULT 'abc', ALGORITHM=INPLACE;
169 affected rows: 0
170 info: Records: 0 Duplicates: 0 Warnings: 1
171 Warnings:
172 Warning 1265 Data truncated for column 'f1' at row 1
173 SELECT * FROM t1;
174 f1
175
176 DROP TABLE t1;
177 CREATE TABLE t1(f1 INT NOT NULL, f2 INT NOT NULL, f3 INT)ENGINE=INNODB;
178 INSERT INTO t1 VALUES(2, 2, NULL);
179 SELECT * FROM t1;
180 f1 f2 f3
181 2 2 NULL
182 ALTER TABLE t1 CHANGE f3 f3 INT NOT NULL DEFAULT (f1 + f2), ALGORITHM=INPLACE;
183 affected rows: 0
184 info: Records: 0 Duplicates: 0 Warnings: 1
185 Warnings:
186 Warning 1265 Data truncated for column 'f3' at row 1
187 SELECT * FROM t1;
188 f1 f2 f3
189 2 2 0
190 DROP TABLE t1;
191 CREATE TABLE t1(f1 INT NOT NULL DEFAULT 0, b TINYINT)ENGINE=InnoDB;
192 INSERT INTO t1 VALUES(10, NULL);
193 SELECT * FROM t1;
194 f1 b
195 10 NULL
196 ALTER TABLE t1 CHANGE b b TINYINT NOT NULL DEFAULT if(unix_timestamp()>1,1000,0), ALGORITHM=INPLACE;
197 affected rows: 0
198 info: Records: 0 Duplicates: 0 Warnings: 1
199 Warnings:
200 Warning 1265 Data truncated for column 'b' at row 1
201 SELECT * FROM t1;
202 f1 b
203 10 0
204 DROP TABLE t1;
205 CREATE TABLE t1(a INT, v INT AS (a), c INT, d INT NOT NULL, e INT) ENGINE=InnoDB;
206 ALTER TABLE t1 DROP COLUMN c, CHANGE COLUMN e e INT NOT NULL, ALGORITHM=INPLACE;
207 affected rows: 0
208 info: Records: 0 Duplicates: 0 Warnings: 0
209 DROP TABLE t1;
210 CREATE TABLE t1 (a INT, v INT AS (a), d INT NOT NULL, e INT) ENGINE=InnoDB;
211 ALTER TABLE t1 FORCE, ALGORITHM=INPLACE;
212 affected rows: 0
213 info: Records: 0 Duplicates: 0 Warnings: 0
214 DROP TABLE t1;
215 CREATE TABLE t1(c1 INT NOT NULL, c2 INT, PRIMARY KEY(c1))ENGINE=INNODB;
216 INSERT INTO t1 VALUES(1, NULL);
217 ALTER IGNORE TABLE t1 CHANGE c2 c2 INT NOT NULL DEFAULT 2;
218 affected rows: 0
219 info: Records: 0 Duplicates: 0 Warnings: 1
220 Warnings:
221 Warning 1265 Data truncated for column 'c2' at row 1
222 SELECT * FROM t1;
223 c1 c2
224 1 0
225 DROP TABLE t1;
226 #
227 # MDEV-16126 Crash or ASAN heap-buffer-overflow in
228 # mach_read_from_n_little_endian upon ALTER TABLE with blob
229 #
230 CREATE TABLE t1(a INT, v INT AS (a), b INT, c BLOB) ENGINE=InnoDB;
231 ALTER TABLE t1 ADD PRIMARY KEY(b), ALGORITHM=INPLACE;
232 affected rows: 0
233 info: Records: 0 Duplicates: 0 Warnings: 0
234 DROP TABLE t1;