Debian Codegraph @

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

raw
1 --echo #
2 --echo # MDEV-19632 Replication aborts with ER_SLAVE_CONVERSION_FAILED upon CREATE ... SELECT in ORACLE mode
3 --echo #
4
5
6 SET sql_mode=DEFAULT;
7 CREATE TABLE t1 (
8 def_timestamp TIMESTAMP,
9 mdb_timestamp mariadb_schema.TIMESTAMP,
10 ora_timestamp oracle_schema.TIMESTAMP,
11 max_timestamp maxdb_schema.TIMESTAMP
12 );
13 SHOW CREATE TABLE t1;
14 SET sql_mode=MAXDB;
15 SHOW CREATE TABLE t1;
16 DROP TABLE t1;
17
18
19 SET sql_mode=MAXDB;
20 CREATE TABLE t1 (
21 def_timestamp TIMESTAMP,
22 mdb_timestamp mariadb_schema.TIMESTAMP,
23 ora_timestamp oracle_schema.TIMESTAMP,
24 max_timestamp maxdb_schema.TIMESTAMP
25 );
26 SHOW CREATE TABLE t1;
27 SET sql_mode=DEFAULT;
28 SHOW CREATE TABLE t1;
29 DROP TABLE t1;