Debian Codegraph @

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

raw
1 #
2 # WL#10905 - Support for INVISIBLE columns.
3 #
4 # Test case to verify that INVISIBLE columns are included in the binlog event.
5 SET @start_row_image_value = @@session.binlog_row_image;
6 RESET MASTER;
7 CREATE TABLE t1 (f1 INT,
8 f2 INT INVISIBLE DEFAULT(10),
9 f3 INT INVISIBLE DEFAULT(905),
10 f4 LONGTEXT DEFAULT('longtext'),
11 CONSTRAINT PRIMARY KEY (f1, f2));
12 SET @@session.binlog_row_image = MINIMAL;
13 INSERT INTO t1(f1) VALUES (1);
14 UPDATE t1 SET f3=10905 WHERE f1 = 1 AND f2 = 10;
15 SET @@session.binlog_row_image = NOBLOB;
16 INSERT INTO t1(f1) VALUES (2);
17 UPDATE t1 SET f3=10905 WHERE f1 = 2 AND f2 = 10;
18 SET @@session.binlog_row_image = FULL;
19 INSERT INTO t1(f1) VALUES (3);
20 UPDATE t1 SET f3=10905 WHERE f1 =3 AND f2 = 10;
21 DROP TABLE t1;
22 FLUSH LOGS;
23 SET @@session.binlog_row_image = @start_row_image_value;
24 include/mysqlbinlog.inc
25 ### INSERT INTO `test`.`t1`
26 ### SET
27 ### @1=1
28 ### @2=10
29 ### @3=905
30 ### @4='longtext'
31 ### UPDATE `test`.`t1`
32 ### WHERE
33 ### @1=1
34 ### @2=10
35 ### SET
36 ### @3=10905
37 ### INSERT INTO `test`.`t1`
38 ### SET
39 ### @1=2
40 ### @2=10
41 ### @3=905
42 ### @4='longtext'
43 ### UPDATE `test`.`t1`
44 ### WHERE
45 ### @1=2
46 ### @2=10
47 ### @3=905
48 ### SET
49 ### @1=2
50 ### @2=10
51 ### @3=10905
52 ### INSERT INTO `test`.`t1`
53 ### SET
54 ### @1=3
55 ### @2=10
56 ### @3=905
57 ### @4='longtext'
58 ### UPDATE `test`.`t1`
59 ### WHERE
60 ### @1=3
61 ### @2=10
62 ### @3=905
63 ### @4='longtext'
64 ### SET
65 ### @1=3
66 ### @2=10
67 ### @3=10905
68 ### @4='longtext'