Debian Codegraph @

mysql-test/suite/binlog/t/binlog_invisible_columns.test

raw
1 #
2 --source include/have_log_bin.inc
3 --source include/have_binlog_format_row.inc
4 --source include/have_grep.inc
5
6 --echo #
7 --echo # WL#10905 - Support for INVISIBLE columns.
8 --echo #
9 --echo # Test case to verify that INVISIBLE columns are included in the binlog event.
10 SET @start_row_image_value = @@session.binlog_row_image;
11
12 # Clear the binlog
13 RESET MASTER;
14
15 CREATE TABLE t1 (f1 INT,
16 f2 INT INVISIBLE DEFAULT(10),
17 f3 INT INVISIBLE DEFAULT(905),
18 f4 LONGTEXT DEFAULT('longtext'),
19 CONSTRAINT PRIMARY KEY (f1, f2));
20 SET @@session.binlog_row_image = MINIMAL;
21 INSERT INTO t1(f1) VALUES (1);
22 UPDATE t1 SET f3=10905 WHERE f1 = 1 AND f2 = 10;
23 SET @@session.binlog_row_image = NOBLOB;
24 INSERT INTO t1(f1) VALUES (2);
25 UPDATE t1 SET f3=10905 WHERE f1 = 2 AND f2 = 10;
26 SET @@session.binlog_row_image = FULL;
27 INSERT INTO t1(f1) VALUES (3);
28 UPDATE t1 SET f3=10905 WHERE f1 =3 AND f2 = 10;
29 DROP TABLE t1;
30
31 FLUSH LOGS;
32
33 SET @@session.binlog_row_image = @start_row_image_value;
34 --let $datadir = `SELECT @@GLOBAL.DATADIR`
35 --let $mysqlbinlog_only_decoded_rows = 1
36 --let $mysqlbinlog_parameters = $datadir/binlog.000001
37 --source include/mysqlbinlog.inc