Debian Codegraph @

mysql-test/suite/innodb/t/alter_table.test

raw
1 --source include/have_innodb.inc
2 --source include/have_sequence.inc
3 #
4 # MDEV-11995 ALTER TABLE proceeds despite reporting ER_TOO_LONG_KEY error
5 #
6 set @@sql_mode=strict_trans_tables;
7 create table t1(a text not null) row_format=dynamic engine=innodb;
8 create index idx1 on t1(a(3073));
9 show create table t1;
10 drop table t1;
11 set @@sql_mode=default;
12
13 #
14 # MDEV-14081 ALTER TABLE CHANGE COLUMN Corrupts Index Leading to Crashes in 10.2
15 #
16 create table t1 (
17 id1 int(11) not null auto_increment,
18 id2 varchar(30) not null,
19 id3 datetime not null default current_timestamp,
20 primary key (id1),
21 unique key unique_id2 (id2)
22 ) engine=innodb;
23 alter table t1 change column id2 id4 varchar(100) not null;
24 select * from t1 where id4 like 'a';
25 drop table t1;
26
27 --echo #
28 --echo # MDEV-17725 Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed in Diagnostics_area::set_ok_status upon ALTER failing due to error from engine
29 --echo #
30
31 SET sql_mode=STRICT_ALL_TABLES;
32 CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=InnoDB;
33 ALTER TABLE t1 ORDER BY a;
34 DROP TABLE t1;
35
36 SET sql_mode='';
37 CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=InnoDB;
38 ALTER TABLE t1 ORDER BY a;
39 DROP TABLE t1;
40
41 SET sql_mode=DEFAULT;
42
43 --echo #
44 --echo # MDEV-18775 Server crashes in dict_table_t::instant_column
45 --echo # upon ADD COLUMN
46 --echo #
47
48 CREATE TABLE tx (pk INT PRIMARY KEY) ENGINE=InnoDB;
49 CREATE TABLE t1 (pk INT, a INT, PRIMARY KEY (pk), KEY (a), FOREIGN KEY (a) REFERENCES tx (pk)) ENGINE=InnoDB;
50
51 SET FOREIGN_KEY_CHECKS=OFF;
52
53 --error ER_FK_COLUMN_CANNOT_DROP
54 ALTER TABLE t1 DROP a;
55
56 SET FOREIGN_KEY_CHECKS=ON;
57
58 ALTER TABLE t1 ADD b INT;
59 --error ER_DROP_INDEX_FK
60 ALTER TABLE t1 DROP a;
61 ALTER TABLE t1 ADD c INT;
62 DROP TABLE t1, tx;
63
64 --echo #
65 --echo # MDEV-14119 Assertion cmp_rec_rec() on ALTER TABLE
66 --echo #
67 CREATE TABLE t1(a INT NOT NULL UNIQUE) ENGINE=InnoDB;
68 INSERT INTO t1 SELECT * FROM seq_1_to_128;
69 ALTER TABLE t1 ADD b TINYINT AUTO_INCREMENT PRIMARY KEY, DROP KEY a;
70 DROP TABLE t1;
71
72 --echo #
73 --echo # MDEV-22939 Server crashes in row_make_new_pathname()
74 --echo #
75 CREATE TABLE t (a INT) ENGINE=INNODB;
76 ALTER TABLE t DISCARD TABLESPACE;
77 --error ER_TABLESPACE_DISCARDED
78 ALTER TABLE t ENGINE INNODB;
79 --error ER_TABLESPACE_DISCARDED
80 ALTER TABLE t FORCE;
81 DROP TABLE t;
82
83 --echo #
84 --echo # MDEV-24763 ALTER TABLE fails to rename a column in SYS_FIELDS
85 --echo #
86 CREATE TABLE t1 (a INT, b TEXT, c INT, PRIMARY KEY(b(9)), INDEX(c,a))
87 ENGINE=InnoDB;
88 ALTER TABLE t1 CHANGE COLUMN a u INT;
89 --replace_column 1 ID
90 SELECT sf.* FROM information_schema.innodb_sys_fields sf
91 INNER JOIN information_schema.innodb_sys_indexes si ON sf.index_id=si.index_id
92 INNER JOIN information_schema.innodb_sys_tables st ON si.table_id=st.table_id
93 WHERE st.name='test/t1' ORDER BY sf.index_id,sf.pos;
94 DROP TABLE t1;
95
96 --echo #
97 --echo # End of 10.2 tests
98 --echo #
99
100 --echo #
101 --echo # Check that innodb supports transactional=1
102 --echo #
103
104 create table t1 (a int) transactional=1 engine=aria;
105 create table t2 (a int) transactional=1 engine=innodb;
106 show create table t1;
107 show create table t2;
108 alter table t1 engine=innodb;
109 alter table t1 add column b int;
110 drop table t1,t2;
111
112 --echo #
113 --echo # MDEV-19272 Assertion unireg_check...Field::NEXT_NUMBER failed
114 --echo #
115 CREATE TABLE t1 (c INT AUTO_INCREMENT NULL UNIQUE) ENGINE=InnoDB;
116 ALTER TABLE t1 MODIFY c INT NOT NULL, ALGORITHM=INPLACE;
117 DROP TABLE t1;
118 --error ER_WRONG_FIELD_SPEC
119 CREATE TABLE t1 (c TIMESTAMP AUTO_INCREMENT UNIQUE) ENGINE=InnoDB;
120 --error ER_WRONG_FIELD_SPEC
121 CREATE TABLE t1 (c DATETIME AUTO_INCREMENT UNIQUE) ENGINE=InnoDB;
122
123 --echo #
124 --echo # MDEV-31000 Assertion failed on ALTER TABLE...page_compressed=1
125 --echo #
126
127 SET @save_file_per_table=@@GLOBAL.innodb_file_per_table;
128 SET GLOBAL innodb_file_per_table=0;
129 CREATE TABLE t (c INT PRIMARY KEY) ENGINE=INNODB;
130 SET GLOBAL innodb_file_per_table=1;
131 ALTER TABLE t page_compressed=1;
132 SET GLOBAL innodb_file_per_table=@save_file_per_table;
133 SELECT space>0 FROM information_schema.innodb_sys_tables WHERE name='test/t';
134 DROP TABLE t;
135
136 --echo # End of 10.4 tests
137
138 --echo #
139 --echo # MDEV-21748 ASAN use-after-poison in PageBulk::insertPage()
140 --echo #
141 CREATE TABLE t1 (pk TIMESTAMP PRIMARY KEY, a TIMESTAMP NULL UNIQUE)
142 ENGINE=InnoDB;
143 INSERT INTO t1 VALUES
144 ('2020-03-10 10:21:00', NULL),
145 ('0000-00-00 00:00:00', '0000-00-00 00:00:00');
146 ALTER TABLE t1 FORCE, ALGORITHM=INPLACE;
147 DROP TABLE t1;
148 --echo #
149 --echo # MDEV-21850 ASAN use-after-poison in page_cur_insert_rec_low()
150 --echo #
151 CREATE TABLE t1 (id INT PRIMARY KEY, a YEAR, INDEX(id,a)) ENGINE=InnoDB;
152 INSERT INTO t1 VALUES (1,NULL),(2,NULL);
153 UPDATE t1 SET a=0;
154 DROP TABLE t1;
155
156 --echo # End of 10.5 tests