Debian Codegraph @

mysql-test/suite/innodb/r/alter_not_null_debug.result

raw
1 CREATE TABLE t1(c1 INT NOT NULL, c2 INT, PRIMARY KEY(c1))ENGINE=INNODB;
2 INSERT INTO t1 VALUES(1, 1);
3 SET DEBUG_SYNC= 'row_merge_after_scan
4 SIGNAL opened WAIT_FOR flushed';
5 affected rows: 0
6 ALTER TABLE t1 CHANGE c2 c2 INT NOT NULL DEFAULT 2;
7 connect con1,localhost,root;
8 SET DEBUG_SYNC= 'now WAIT_FOR opened';
9 affected rows: 0
10 INSERT INTO t1 VALUES(2, NULL);
11 affected rows: 1
12 UPDATE t1 SET c1 = 3 WHERE c2 = 1;
13 affected rows: 1
14 info: Rows matched: 1 Changed: 1 Warnings: 0
15 SET DEBUG_SYNC= 'now SIGNAL flushed';
16 affected rows: 0
17 connection default;
18 affected rows: 0
19 info: Records: 0 Duplicates: 0 Warnings: 1
20 Warnings:
21 Warning 1265 Data truncated for column 'c2' at row 3
22 SELECT * FROM t1;
23 c1 c2
24 2 0
25 3 1
26 DROP TABLE t1;
27 CREATE TABLE t1(c1 INT NOT NULL, c2 INT, PRIMARY KEY(c1))ENGINE=INNODB;
28 INSERT INTO t1 VALUES(1, 1);
29 SET DEBUG_SYNC= 'row_merge_after_scan
30 SIGNAL opened WAIT_FOR flushed';
31 affected rows: 0
32 ALTER TABLE t1 CHANGE c2 c2 INT NOT NULL DEFAULT 2;
33 connection con1;
34 SET DEBUG_SYNC= 'now WAIT_FOR opened';
35 affected rows: 0
36 INSERT INTO t1 VALUES(2, 3);
37 affected rows: 1
38 UPDATE t1 SET c1 = 3 WHERE c2 = 1;
39 affected rows: 1
40 info: Rows matched: 1 Changed: 1 Warnings: 0
41 SET DEBUG_SYNC= 'now SIGNAL flushed';
42 affected rows: 0
43 connection default;
44 affected rows: 0
45 info: Records: 0 Duplicates: 0 Warnings: 0
46 SELECT * FROM t1;
47 c1 c2
48 2 3
49 3 1
50 DROP TABLE t1;
51 CREATE TABLE t1(c1 INT NOT NULL, c2 INT, c3 INT, PRIMARY KEY(c1))ENGINE=INNODB;
52 INSERT INTO t1 VALUES(1, 2, 3);
53 SET DEBUG_SYNC= 'row_merge_after_scan
54 SIGNAL opened WAIT_FOR flushed';
55 affected rows: 0
56 ALTER IGNORE TABLE t1 CHANGE c2 c2 INT NOT NULL DEFAULT 2;
57 connection con1;
58 SET DEBUG_SYNC= 'now WAIT_FOR opened';
59 affected rows: 0
60 UPDATE t1 SET c2= 2 WHERE c1 = 1;
61 affected rows: 0
62 info: Rows matched: 1 Changed: 0 Warnings: 0
63 INSERT INTO t1 VALUES (2, NULL, 4);
64 affected rows: 1
65 SET DEBUG_SYNC= 'now SIGNAL flushed';
66 affected rows: 0
67 connection default;
68 affected rows: 0
69 info: Records: 0 Duplicates: 0 Warnings: 1
70 Warnings:
71 Warning 1265 Data truncated for column 'c2' at row 3
72 SELECT * FROM t1;
73 c1 c2 c3
74 1 2 3
75 2 0 4
76 DROP TABLE t1;
77 SET DEBUG_SYNC='RESET';
78 #
79 # MDEV-21539 Assertion ...prtype... in row_log_table_apply_convert_mrec
80 #
81 CREATE TABLE t1 (f VARCHAR(8) CHARACTER SET latin1 COLLATE latin1_swedish_ci)
82 ENGINE=InnoDB;
83 INSERT INTO t1 VALUES('ZERO');
84 connection con1;
85 SET DEBUG_SYNC = 'row_log_table_apply1_before SIGNAL scanned WAIT_FOR insert_done';
86 ALTER TABLE t1 MODIFY f VARCHAR(256) COLLATE latin1_german2_ci NOT NULL;
87 # session default
88 connection default;
89 SET DEBUG_SYNC = 'now WAIT_FOR scanned';
90 INSERT INTO t1 VALUES('one');
91 SET DEBUG_SYNC = 'now SIGNAL insert_done';
92 connection con1;
93 disconnect con1;
94 connection default;
95 SET DEBUG_SYNC=RESET;
96 ALTER TABLE t1 CHANGE f eins VARCHAR(257) COLLATE latin1_german1_ci NOT NULL,
97 ALGORITHM=INSTANT;
98 SELECT * FROM t1;
99 eins
100 ZERO
101 one
102 DROP TABLE t1;