Debian Codegraph @

mysql-test/suite/innodb/t/alter_not_null.inc

raw
1 # This test is run from alter_not_null.test with different combinations of
2 # alter_algorithm and strict mode
3
4 let $sql_mode = `SELECT @@SQL_MODE`;
5 let $error_code = 0;
6
7 if ($sql_mode == "STRICT_TRANS_TABLES") {
8 let $error_code = WARN_DATA_TRUNCATED;
9 }
10
11 --echo #
12 --echo # sql_mode: $sql_mode alter_algorithm: $alter_algorithm
13 --echo #
14
15 CREATE TABLE t1(f1 INT)ENGINE=INNODB;
16 INSERT INTO t1 VALUES(NULL);
17 SELECT * FROM t1;
18 --enable_info
19 --error $error_code
20 --eval ALTER TABLE t1 CHANGE f1 f1 INT NOT NULL, ALGORITHM=$alter_algorithm
21 --disable_info
22 SELECT * FROM t1;
23 DROP TABLE t1;
24
25 CREATE TABLE t1(f1 CHAR(10))ENGINE=INNODB;
26 INSERT INTO t1 VALUES(NULL);
27 SELECT * FROM t1;
28 --enable_info
29 --error $error_code
30 --eval ALTER TABLE t1 CHANGE f1 f1 CHAR(10) NOT NULL, ALGORITHM=$alter_algorithm
31 --disable_info
32 SELECT * FROM t1;
33 DROP TABLE t1;
34
35 CREATE TABLE t1(f1 VARCHAR(10))ENGINE=INNODB;
36 INSERT INTO t1 VALUES(NULL);
37 SELECT * FROM t1;
38 --enable_info
39 --error $error_code
40 --eval ALTER TABLE t1 CHANGE f1 f1 VARCHAR(20) NOT NULL, ALGORITHM=$alter_algorithm
41 --disable_info
42 SELECT * FROM t1;
43 DROP TABLE t1;
44
45 CREATE TABLE t1(f1 TEXT)ENGINE=INNODB;
46 INSERT INTO t1 VALUES(NULL);
47 SELECT * FROM t1;
48 --enable_info
49 --error $error_code
50 --eval ALTER TABLE t1 CHANGE f1 f1 TEXT NOT NULL DEFAULT 'abc', ALGORITHM=$alter_algorithm
51 --disable_info
52 SELECT * FROM t1;
53 DROP TABLE t1;
54
55 CREATE TABLE t1(f1 INT NOT NULL, f2 INT NOT NULL, f3 INT)ENGINE=INNODB;
56 INSERT INTO t1 VALUES(2, 2, NULL);
57 SELECT * FROM t1;
58 --enable_info
59 --error $error_code
60 --eval ALTER TABLE t1 CHANGE f3 f3 INT NOT NULL DEFAULT (f1 + f2), ALGORITHM=$alter_algorithm
61 --disable_info
62 SELECT * FROM t1;
63 DROP TABLE t1;
64
65 CREATE TABLE t1(f1 INT NOT NULL DEFAULT 0, b TINYINT)ENGINE=InnoDB;
66 INSERT INTO t1 VALUES(10, NULL);
67 SELECT * FROM t1;
68 --enable_info
69 --error $error_code
70 --eval ALTER TABLE t1 CHANGE b b TINYINT NOT NULL DEFAULT if(unix_timestamp()>1,1000,0), ALGORITHM=$alter_algorithm
71 --disable_info
72 SELECT * FROM t1;
73 DROP TABLE t1;
74
75 CREATE TABLE t1(a INT, v INT AS (a), c INT, d INT NOT NULL, e INT) ENGINE=InnoDB;
76 --enable_info
77 --eval ALTER TABLE t1 DROP COLUMN c, CHANGE COLUMN e e INT NOT NULL, ALGORITHM=$alter_algorithm
78 --disable_info
79 DROP TABLE t1;
80
81 CREATE TABLE t1 (a INT, v INT AS (a), d INT NOT NULL, e INT) ENGINE=InnoDB;
82 --enable_info
83 --eval ALTER TABLE t1 FORCE, ALGORITHM=$alter_algorithm
84 --disable_info
85 DROP TABLE t1;
86
87 # Alter ignore should work irrespective of sql mode
88
89 CREATE TABLE t1(c1 INT NOT NULL, c2 INT, PRIMARY KEY(c1))ENGINE=INNODB;
90 INSERT INTO t1 VALUES(1, NULL);
91 --enable_info
92 ALTER IGNORE TABLE t1 CHANGE c2 c2 INT NOT NULL DEFAULT 2;
93 --disable_info
94 SELECT * FROM t1;
95 DROP TABLE t1;
96
97 --echo #
98 --echo # MDEV-16126 Crash or ASAN heap-buffer-overflow in
99 --echo # mach_read_from_n_little_endian upon ALTER TABLE with blob
100 --echo #
101
102 CREATE TABLE t1(a INT, v INT AS (a), b INT, c BLOB) ENGINE=InnoDB;
103 --enable_info
104 --eval ALTER TABLE t1 ADD PRIMARY KEY(b), ALGORITHM=$alter_algorithm
105 --disable_info
106 DROP TABLE t1;