Debian Codegraph @

mysql-test/suite/innodb/t/innodb-index-online-norebuild.test

raw
1 --source include/have_innodb.inc
2
3 --echo # INPLACE ALTER WITH INPLACE_IGNORE FLAG AND CHANGE CREATE OPTION
4
5 --echo # CHANGE THE COLUMN DEFAULT (INPLACE_IGNORE)
6 --echo # AND TABLE CHARSET(CHANGE CREATE)
7
8 CREATE TABLE t1(
9 id INT PRIMARY KEY,
10 f1 INT NOT NULL DEFAULT 0)ENGINE=INNODB;
11
12 INSERT INTO t1 VALUES(1, 2);
13
14 let id_before_alter =`SELECT table_id FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE name="test/t1"`;
15
16 # Allow the following operation to report errors.
17 SET SQL_MODE='STRICT_ALL_TABLES';
18 ALTER TABLE t1 MODIFY COLUMN f1 INT NOT NULL DEFAULT 0,
19 DEFAULT CHARSET=latin1, ALGORITHM=INPLACE;
20
21 let id_after_alter =`SELECT table_id FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE name="test/t1"`;
22
23 if ($id_before_alter != $id_after_alter)
24 {
25 --echo "Table rebuild happened";
26 }
27
28 DROP TABLE t1;
29
30 --echo # CHANGE THE COMMENT OF COLUMN(INPLACE IGNORE)
31 --echo # AND TABLE CHARSET(CHANGE CREATE)
32
33 CREATE TABLE t1(id INT COMMENT 'independence day')ENGINE=INNODB;
34
35 INSERT INTO t1 values(1);
36
37 let id_before_alter =`SELECT table_id FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE name="test/t1"`;
38
39 ALTER TABLE t1 MODIFY COLUMN id INT COMMENT 'identifier',
40 DEFAULT CHARSET=latin1, ALGORITHM=INPLACE;
41
42 let id_after_alter =`SELECT table_id FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE name="test/t1"`;
43
44 if ($id_before_alter != $id_after_alter)
45 {
46 --echo "Table rebuild happened";
47 }
48
49 DROP TABLE t1;
50
51 --echo # RENAME THE TABLE(INPLACE IGNORE)
52 --echo # AND CHANGE TABLE CHARSET(CHANGE CREATE)
53
54 CREATE TABLE t1(
55 f1 INT NOT NULL,
56 f2 INT NOT NULL)ENGINE=INNODB;
57
58 INSERT INTO t1 VALUES(1, 2);
59
60 let id_before_alter =`SELECT table_id FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE name="test/t1"`;
61
62 ALTER TABLE t1 RENAME t2, DEFAULT CHARSET=latin1, ALGORITHM=INPLACE;
63
64 let id_after_alter =`SELECT table_id FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE name="test/t2"`;
65
66 if ($id_before_alter != $id_after_alter)
67 {
68 --echo "Table rebuild happened";
69 }
70
71 DROP TABLE t2;