Debian Codegraph @

mysql-test/suite/compat/oracle/r/rpl_mariadb_date.result

raw
1 include/master-slave.inc
2 [connection master]
3 SET SQL_MODE=DEFAULT;
4 CREATE TABLE t1 (a DATE);
5 INSERT INTO t1 VALUES (NULL);
6 INSERT INTO t1 VALUES ('2001-01-01');
7 SET SQL_MODE= ORACLE;
8 CREATE TABLE t2 SELECT * FROM t1;
9 include/show_binlog_events.inc
10 Log_name Pos Event_type Server_id End_log_pos Info
11 master-bin.000001 # Gtid # # GTID #-#-#
12 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a DATE)
13 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
14 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (NULL)
15 master-bin.000001 # Table_map # # table_id: # (test.t1)
16 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
17 master-bin.000001 # Query # # COMMIT
18 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
19 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES ('2001-01-01')
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 # Query # # use `test`; CREATE TABLE "t2" (
25 "a" mariadb_schema.date DEFAULT NULL
26 )
27 master-bin.000001 # Annotate_rows # # CREATE TABLE t2 SELECT * FROM t1
28 master-bin.000001 # Table_map # # table_id: # (test.t2)
29 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
30 master-bin.000001 # Query # # COMMIT
31 SET SQL_MODE= DEFAULT;
32 SHOW CREATE TABLE t1;
33 Table Create Table
34 t1 CREATE TABLE `t1` (
35 `a` date DEFAULT NULL
36 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
37 SHOW CREATE TABLE t2;
38 Table Create Table
39 t2 CREATE TABLE `t2` (
40 `a` date DEFAULT NULL
41 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
42 SET SQL_MODE= ORACLE;
43 SHOW CREATE TABLE t1;
44 Table Create Table
45 t1 CREATE TABLE "t1" (
46 "a" mariadb_schema.date DEFAULT NULL
47 )
48 SHOW CREATE TABLE t2;
49 Table Create Table
50 t2 CREATE TABLE "t2" (
51 "a" mariadb_schema.date DEFAULT NULL
52 )
53 connection slave;
54 SELECT * FROM t1;
55 a
56 NULL
57 2001-01-01
58 SELECT * FROM t2;
59 a
60 NULL
61 2001-01-01
62 SET SQL_MODE= DEFAULT;
63 SHOW CREATE TABLE t1;
64 Table Create Table
65 t1 CREATE TABLE `t1` (
66 `a` date DEFAULT NULL
67 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
68 SHOW CREATE TABLE t2;
69 Table Create Table
70 t2 CREATE TABLE `t2` (
71 `a` date DEFAULT NULL
72 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
73 SET SQL_MODE= ORACLE;
74 SHOW CREATE TABLE t1;
75 Table Create Table
76 t1 CREATE TABLE "t1" (
77 "a" mariadb_schema.date DEFAULT NULL
78 )
79 SHOW CREATE TABLE t2;
80 Table Create Table
81 t2 CREATE TABLE "t2" (
82 "a" mariadb_schema.date DEFAULT NULL
83 )
84 connection master;
85 DROP TABLE t1, t2;
86 include/rpl_end.inc