Debian Codegraph @

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

raw
1 #
2 # MDEV-19632 Replication aborts with ER_SLAVE_CONVERSION_FAILED upon CREATE ... SELECT in ORACLE mode
3 #
4 SET sql_mode=DEFAULT;
5 CREATE TABLE t1 (
6 def_timestamp TIMESTAMP,
7 mdb_timestamp mariadb_schema.TIMESTAMP,
8 ora_timestamp oracle_schema.TIMESTAMP,
9 max_timestamp maxdb_schema.TIMESTAMP
10 );
11 SHOW CREATE TABLE t1;
12 Table Create Table
13 t1 CREATE TABLE `t1` (
14 `def_timestamp` timestamp NULL DEFAULT NULL,
15 `mdb_timestamp` timestamp NULL DEFAULT NULL,
16 `ora_timestamp` timestamp NULL DEFAULT NULL,
17 `max_timestamp` datetime DEFAULT NULL
18 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
19 SET sql_mode=MAXDB;
20 SHOW CREATE TABLE t1;
21 Table Create Table
22 t1 CREATE TABLE "t1" (
23 "def_timestamp" mariadb_schema.timestamp NULL DEFAULT NULL,
24 "mdb_timestamp" mariadb_schema.timestamp NULL DEFAULT NULL,
25 "ora_timestamp" mariadb_schema.timestamp NULL DEFAULT NULL,
26 "max_timestamp" datetime DEFAULT NULL
27 )
28 DROP TABLE t1;
29 SET sql_mode=MAXDB;
30 CREATE TABLE t1 (
31 def_timestamp TIMESTAMP,
32 mdb_timestamp mariadb_schema.TIMESTAMP,
33 ora_timestamp oracle_schema.TIMESTAMP,
34 max_timestamp maxdb_schema.TIMESTAMP
35 );
36 SHOW CREATE TABLE t1;
37 Table Create Table
38 t1 CREATE TABLE "t1" (
39 "def_timestamp" datetime DEFAULT NULL,
40 "mdb_timestamp" mariadb_schema.timestamp NULL DEFAULT NULL,
41 "ora_timestamp" mariadb_schema.timestamp NULL DEFAULT NULL,
42 "max_timestamp" datetime DEFAULT NULL
43 )
44 SET sql_mode=DEFAULT;
45 SHOW CREATE TABLE t1;
46 Table Create Table
47 t1 CREATE TABLE `t1` (
48 `def_timestamp` datetime DEFAULT NULL,
49 `mdb_timestamp` timestamp NULL DEFAULT NULL,
50 `ora_timestamp` timestamp NULL DEFAULT NULL,
51 `max_timestamp` datetime DEFAULT NULL
52 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
53 DROP TABLE t1;