Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2 --source include/have_debug.inc
3 --source include/have_debug_sync.inc
4 --source alter_sql_mode.inc
5
6 let $sql_mode = `SELECT @@SQL_MODE`;
7 let $error_code = 0;
8
9 if ($sql_mode == "STRICT_TRANS_TABLES") {
10 let $error_code = ER_INVALID_USE_OF_NULL;
11 }
12
13
14 # Alter table should fail for strict sql mode
15
16 CREATE TABLE t1(c1 INT NOT NULL, c2 INT, PRIMARY KEY(c1))ENGINE=INNODB;
17 INSERT INTO t1 VALUES(1, 1);
18 --enable_info
19 SET DEBUG_SYNC= 'row_merge_after_scan
20 SIGNAL opened WAIT_FOR flushed';
21 send ALTER TABLE t1 CHANGE c2 c2 INT NOT NULL DEFAULT 2;
22 connect (con1,localhost,root);
23 SET DEBUG_SYNC= 'now WAIT_FOR opened';
24 INSERT INTO t1 VALUES(2, NULL);
25 UPDATE t1 SET c1 = 3 WHERE c2 = 1;
26 SET DEBUG_SYNC= 'now SIGNAL flushed';
27 connection default;
28 --error $error_code
29 reap;
30 --disable_info
31 SELECT * FROM t1;
32 DROP TABLE t1;
33
34 # Alter table should successfully apply the log for the alter operation
35
36 CREATE TABLE t1(c1 INT NOT NULL, c2 INT, PRIMARY KEY(c1))ENGINE=INNODB;
37 INSERT INTO t1 VALUES(1, 1);
38 --enable_info
39 SET DEBUG_SYNC= 'row_merge_after_scan
40 SIGNAL opened WAIT_FOR flushed';
41 send ALTER TABLE t1 CHANGE c2 c2 INT NOT NULL DEFAULT 2;
42 connection con1;
43 SET DEBUG_SYNC= 'now WAIT_FOR opened';
44 INSERT INTO t1 VALUES(2, 3);
45 UPDATE t1 SET c1 = 3 WHERE c2 = 1;
46 SET DEBUG_SYNC= 'now SIGNAL flushed';
47 connection default;
48 reap;
49 --disable_info
50 SELECT * FROM t1;
51 DROP TABLE t1;
52
53 # Alter ignore should not give error
54
55 CREATE TABLE t1(c1 INT NOT NULL, c2 INT, c3 INT, PRIMARY KEY(c1))ENGINE=INNODB;
56 INSERT INTO t1 VALUES(1, 2, 3);
57 --enable_info
58 SET DEBUG_SYNC= 'row_merge_after_scan
59 SIGNAL opened WAIT_FOR flushed';
60 send ALTER IGNORE TABLE t1 CHANGE c2 c2 INT NOT NULL DEFAULT 2;
61 connection con1;
62 SET DEBUG_SYNC= 'now WAIT_FOR opened';
63 UPDATE t1 SET c2= 2 WHERE c1 = 1;
64 INSERT INTO t1 VALUES (2, NULL, 4);
65 SET DEBUG_SYNC= 'now SIGNAL flushed';
66 connection default;
67 reap;
68 --disable_info
69 SELECT * FROM t1;
70 DROP TABLE t1;
71 SET DEBUG_SYNC='RESET';
72
73 --echo #
74 --echo # MDEV-21539 Assertion ...prtype... in row_log_table_apply_convert_mrec
75 --echo #
76 CREATE TABLE t1 (f VARCHAR(8) CHARACTER SET latin1 COLLATE latin1_swedish_ci)
77 ENGINE=InnoDB;
78 INSERT INTO t1 VALUES('ZERO');
79 connection con1;
80 SET DEBUG_SYNC = 'row_log_table_apply1_before SIGNAL scanned WAIT_FOR insert_done';
81 send ALTER TABLE t1 MODIFY f VARCHAR(256) COLLATE latin1_german2_ci NOT NULL;
82
83 --echo # session default
84 connection default;
85 SET DEBUG_SYNC = 'now WAIT_FOR scanned';
86 INSERT INTO t1 VALUES('one');
87 SET DEBUG_SYNC = 'now SIGNAL insert_done';
88
89 connection con1;
90 reap;
91 disconnect con1;
92 connection default;
93 SET DEBUG_SYNC=RESET;
94
95 ALTER TABLE t1 CHANGE f eins VARCHAR(257) COLLATE latin1_german1_ci NOT NULL,
96 ALGORITHM=INSTANT;
97
98 SELECT * FROM t1;
99 DROP TABLE t1;