Debian Codegraph @

mysql-test/suite/compat/maxdb/rpl_mariadb_timestamp.test

raw
1 --source include/have_binlog_format_row.inc
2 --source include/master-slave.inc
3
4 --echo #
5 --echo # MDEV-19632 Replication aborts with ER_SLAVE_CONVERSION_FAILED upon CREATE ... SELECT in ORACLE mode
6 --echo #
7
8 SET timestamp=UNIX_TIMESTAMP('2001-01-01 10:00:00');
9 SET sql_mode=DEFAULT;
10 CREATE TABLE t1 (a TIMESTAMP NOT NULL DEFAULT NOW());
11 INSERT INTO t1 VALUES (NULL);
12 INSERT INTO t1 VALUES ('2001-01-01 10:20:30');
13 SET sql_mode=MAXDB;
14 CREATE TABLE t2 SELECT * FROM t1;
15 SET timestamp=DEFAULT;
16
17 --let $binlog_file = LAST
18 source include/show_binlog_events.inc;
19
20 --sync_slave_with_master
21 SELECT * FROM t1;
22 SET sql_mode=DEFAULT;
23 SHOW CREATE TABLE t1;
24 SHOW CREATE TABLE t2;
25
26 SET sql_mode=MAXDB;
27 SHOW CREATE TABLE t1;
28 SHOW CREATE TABLE t2;
29
30 --connection master
31 DROP TABLE t1, t2;
32
33 --source include/rpl_end.inc