Debian Codegraph @

mysql-test/suite/compat/oracle/t/rpl_mariadb_date.test

raw
1 --source include/have_binlog_format_row.inc
2 --source include/master-slave.inc
3
4 SET SQL_MODE=DEFAULT;
5 CREATE TABLE t1 (a DATE);
6 INSERT INTO t1 VALUES (NULL);
7 INSERT INTO t1 VALUES ('2001-01-01');
8
9 SET SQL_MODE= ORACLE;
10 CREATE TABLE t2 SELECT * FROM t1;
11
12 --let $binlog_file = LAST
13 source include/show_binlog_events.inc;
14
15 SET SQL_MODE= DEFAULT;
16 SHOW CREATE TABLE t1;
17 SHOW CREATE TABLE t2;
18
19 SET SQL_MODE= ORACLE;
20 SHOW CREATE TABLE t1;
21 SHOW CREATE TABLE t2;
22
23 --sync_slave_with_master
24 SELECT * FROM t1;
25 SELECT * FROM t2;
26
27 SET SQL_MODE= DEFAULT;
28 SHOW CREATE TABLE t1;
29 SHOW CREATE TABLE t2;
30
31 SET SQL_MODE= ORACLE;
32 SHOW CREATE TABLE t1;
33 SHOW CREATE TABLE t2;
34
35 # Cleanup
36 --connection master
37 DROP TABLE t1, t2;
38 --source include/rpl_end.inc