summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/rpl/r/rpl_empty_string_is_null.result
blob: 9d0b0295b0d0fce3a98f6f472aed79bffc50fe1d (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
include/master-slave.inc
[connection master]
#
# MDEV-18918 SQL mode EMPTY_STRING_IS_NULL breaks RBR upon CREATE TABLE .. SELECT
#
SET SQL_MODE= 'EMPTY_STRING_IS_NULL';
CREATE TABLE t1 AS SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE 1 = 0;
connection slave;
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `TABLE_NAME` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
connection master;
DROP TABLE t1;
include/rpl_end.inc