Debian Codegraph @

mysql-test/suite/versioning/t/rpl_row.test

raw
1 --source include/have_binlog_format_row.inc
2 --source include/master-slave.inc
3 --source include/have_innodb.inc
4 --source suite/versioning/sys_time.inc
5
6 --echo # MDEV-16252: MINIMAL binlog_row_image does not work for versioned tables
7 set @old_row_image= @@binlog_row_image;
8 set binlog_row_image= minimal;
9
10 create or replace table t1 (pk int, i int, primary key(pk))
11 with system versioning;
12 insert into t1 values (1,10),(2,20);
13 update t1 set i = 0;
14
15 --sync_slave_with_master
16 --connection master
17 drop table t1;
18 set binlog_row_image= @old_row_image;
19
20 --echo #
21 --echo # MDEV-28254 Wrong position for row_start, row_end after adding column
22 --echo # to implicit versioned table
23 --echo #
24 --let TMP= $MYSQLTEST_VARDIR/tmp
25 --let $MYSQLD_DATADIR= `select @@datadir`
26 set @@system_versioning_alter_history= keep;
27 set @@session.time_zone='+00:00';
28
29 create table t1 (x int) with system versioning engine innodb;
30 alter table t1 add column y int, algorithm=inplace;
31 check table t1;
32 --exec $MYSQL_DUMP --databases test > $TMP/dump.sql
33
34 --sync_slave_with_master
35 drop table t1;
36 --exec $MYSQL_SLAVE test < $TMP/dump.sql
37 show create table t1;
38
39 --connection master
40 set timestamp= 12345;
41 --let $start_pos= query_get_value("SHOW MASTER STATUS", Position, 1)
42 insert t1 values (1, 1);
43 --replace_result $sys_timestamp_max TIMESTAMP_MAX
44 select *, unix_timestamp(row_start) as row_start, unix_timestamp(row_end) as row_end from t1;
45 --let $stop_pos= query_get_value("SHOW MASTER STATUS", Position, 1)
46 set timestamp= default;
47
48 # NOTE: pipe grep is not Windows-compatible
49 --let grep_file= $TMP/out.txt
50 --let grep_regex= ^###
51 --let grep_filter=s{$sys_timestamp_max}{MAX_TIMESTAMP};
52 --exec $MYSQL_BINLOG -v -j $start_pos --stop-position=$stop_pos -o 3 $MYSQLD_DATADIR/master-bin.000001 > $grep_file
53 --source include/grep.inc
54 --sync_slave_with_master
55 select * from t1;
56
57 --connection master
58 drop table t1;
59 --remove_files_wildcard $TMP *.txt
60 --remove_files_wildcard $TMP *.sql
61
62 --echo #
63 --echo # MDEV-31297 Create table as select on system versioned tables do not work consistently on replication
64 --echo #
65 --connection master
66 create table t engine=innodb with system versioning as select 1 as i;
67 show create table t;
68 select * from t;
69
70 --sync_slave_with_master
71 show create table t;
72 select * from t;
73
74 --connection master
75 drop table t;
76
77 --source rpl_common.inc