Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 #
4 # MDEV-19632 Replication aborts with ER_SLAVE_CONVERSION_FAILED upon CREATE ... SELECT in ORACLE mode
5 #
6 SET timestamp=UNIX_TIMESTAMP('2001-01-01 10:00:00');
7 SET sql_mode=DEFAULT;
8 CREATE TABLE t1 (a TIMESTAMP NOT NULL DEFAULT NOW());
9 INSERT INTO t1 VALUES (NULL);
10 INSERT INTO t1 VALUES ('2001-01-01 10:20:30');
11 SET sql_mode=MAXDB;
12 CREATE TABLE t2 SELECT * FROM t1;
13 SET timestamp=DEFAULT;
14 include/show_binlog_events.inc
15 Log_name Pos Event_type Server_id End_log_pos Info
16 master-bin.000001 # Gtid # # GTID #-#-#
17 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a TIMESTAMP NOT NULL DEFAULT NOW())
18 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
19 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (NULL)
20 master-bin.000001 # Table_map # # table_id: # (test.t1)
21 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
22 master-bin.000001 # Query # # COMMIT
23 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
24 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES ('2001-01-01 10:20:30')
25 master-bin.000001 # Table_map # # table_id: # (test.t1)
26 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
27 master-bin.000001 # Query # # COMMIT
28 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
29 master-bin.000001 # Query # # use `test`; CREATE TABLE "t2" (
30 "a" mariadb_schema.timestamp NOT NULL DEFAULT current_timestamp()
31 )
32 master-bin.000001 # Annotate_rows # # CREATE TABLE t2 SELECT * FROM t1
33 master-bin.000001 # Table_map # # table_id: # (test.t2)
34 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
35 master-bin.000001 # Query # # COMMIT
36 connection slave;
37 SELECT * FROM t1;
38 a
39 2001-01-01 10:00:00
40 2001-01-01 10:20:30
41 SET sql_mode=DEFAULT;
42 SHOW CREATE TABLE t1;
43 Table Create Table
44 t1 CREATE TABLE `t1` (
45 `a` timestamp NOT NULL DEFAULT current_timestamp()
46 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
47 SHOW CREATE TABLE t2;
48 Table Create Table
49 t2 CREATE TABLE `t2` (
50 `a` timestamp NOT NULL DEFAULT current_timestamp()
51 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
52 SET sql_mode=MAXDB;
53 SHOW CREATE TABLE t1;
54 Table Create Table
55 t1 CREATE TABLE "t1" (
56 "a" mariadb_schema.timestamp NOT NULL DEFAULT current_timestamp()
57 )
58 SHOW CREATE TABLE t2;
59 Table Create Table
60 t2 CREATE TABLE "t2" (
61 "a" mariadb_schema.timestamp NOT NULL DEFAULT current_timestamp()
62 )
63 connection master;
64 DROP TABLE t1, t2;
65 include/rpl_end.inc