Debian Codegraph @

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

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