Debian Codegraph @

mysql-test/suite/binlog/r/binlog_functional_index.result

raw
1 # Check that the hidden generated column is not included in the binlog
2 # regardless of binlog_row_image
3 RESET MASTER;
4 SET @start_row_image_value = @@session.binlog_row_image;
5 CREATE TABLE t1 (col1 INT, col2 INT NOT NULL, col3 INT, col4 INT, UNIQUE INDEX ((ABS(col2))));
6 SET @@session.binlog_row_image = MINIMAL;
7 INSERT INTO t1 VALUES (1, 2, 3, 4), (2, 3, 4, 5);
8 UPDATE t1 SET col1 = 2 WHERE ABS(col2) = 2;
9 SET @@session.binlog_row_image = FULL;
10 INSERT INTO t1 VALUES (10, 20, 30, 40), (20, 30, 40, 50);
11 UPDATE t1 SET col1 = 20 WHERE ABS(col2) = 20;
12 SET @@session.binlog_row_image = NOBLOB;
13 INSERT INTO t1 VALUES (100, 200, 300, 400), (200, 300, 400, 500);
14 UPDATE t1 SET col1 = 200 WHERE ABS(col2) = 200;
15 DROP TABLE t1;
16 FLUSH LOGS;
17 include/mysqlbinlog.inc
18 ### INSERT INTO `test`.`t1`
19 ### SET
20 ### @1=1
21 ### @2=2
22 ### @3=3
23 ### @4=4
24 ### INSERT INTO `test`.`t1`
25 ### SET
26 ### @1=2
27 ### @2=3
28 ### @3=4
29 ### @4=5
30 ### UPDATE `test`.`t1`
31 ### WHERE
32 ### @1=1
33 ### @2=2
34 ### @3=3
35 ### @4=4
36 ### SET
37 ### @1=2
38 ### INSERT INTO `test`.`t1`
39 ### SET
40 ### @1=10
41 ### @2=20
42 ### @3=30
43 ### @4=40
44 ### INSERT INTO `test`.`t1`
45 ### SET
46 ### @1=20
47 ### @2=30
48 ### @3=40
49 ### @4=50
50 ### UPDATE `test`.`t1`
51 ### WHERE
52 ### @1=10
53 ### @2=20
54 ### @3=30
55 ### @4=40
56 ### SET
57 ### @1=20
58 ### @2=20
59 ### @3=30
60 ### @4=40
61 ### INSERT INTO `test`.`t1`
62 ### SET
63 ### @1=100
64 ### @2=200
65 ### @3=300
66 ### @4=400
67 ### INSERT INTO `test`.`t1`
68 ### SET
69 ### @1=200
70 ### @2=300
71 ### @3=400
72 ### @4=500
73 ### UPDATE `test`.`t1`
74 ### WHERE
75 ### @1=100
76 ### @2=200
77 ### @3=300
78 ### @4=400
79 ### SET
80 ### @1=200
81 ### @2=200
82 ### @3=300
83 ### @4=400
84 RESET MASTER;
85 # Check that when the only unique NOT NULL index is a functional index,
86 # the binary log contains a full before-image regardless of
87 # binlog_row_image.
88 CREATE TABLE t1 (
89 col1 INT NOT NULL
90 , col2 INT NOT NULL
91 , col3 INT NOT NULL
92 , UNIQUE INDEX idx1 ((ABS(col1))));
93 INSERT INTO t1 VALUES (1, 1, 1);
94 SET binlog_row_image = MINIMAL;
95 UPDATE t1 SET col2 = 2 WHERE ABS(col1) = 1;
96 SET binlog_row_image = FULL;
97 UPDATE t1 SET col2 = 3 WHERE ABS(col1) = 1;
98 SET binlog_row_image = NOBLOB;
99 UPDATE t1 SET col2 = 4 WHERE ABS(col1) = 1;
100 DROP TABLE t1;
101 FLUSH LOGS;
102 SET @@session.binlog_row_image = @start_row_image_value;
103 include/mysqlbinlog.inc
104 ### INSERT INTO `test`.`t1`
105 ### SET
106 ### @1=1
107 ### @2=1
108 ### @3=1
109 ### UPDATE `test`.`t1`
110 ### WHERE
111 ### @1=1
112 ### @2=1
113 ### @3=1
114 ### SET
115 ### @2=2
116 ### UPDATE `test`.`t1`
117 ### WHERE
118 ### @1=1
119 ### @2=2
120 ### @3=1
121 ### SET
122 ### @1=1
123 ### @2=3
124 ### @3=1
125 ### UPDATE `test`.`t1`
126 ### WHERE
127 ### @1=1
128 ### @2=3
129 ### @3=1
130 ### SET
131 ### @1=1
132 ### @2=4
133 ### @3=1