Debian Codegraph @

mysql-test/suite/rpl/r/rpl_row_create_select.result

raw
1 include/master-slave.inc
2 [connection master]
3 #
4 # BUG#17994219: CREATE TABLE .. SELECT PRODUCES INVALID STRUCTURE,
5 # BREAKS RBR
6 #
7 connection master;
8 #After the patch, the display width is set to a default
9 #value of 21.
10 SET STATEMENT sql_mode = 'NO_ENGINE_SUBSTITUTION' FOR
11 CREATE TABLE t1 AS SELECT REPEAT('A', 1000) DIV 1 AS a;
12 Warnings:
13 Warning 1292 Truncated incorrect DECIMAL value: 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA...'
14 SHOW CREATE TABLE t1;
15 Table Create Table
16 t1 CREATE TABLE `t1` (
17 `a` bigint(21) DEFAULT NULL
18 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
19 SET STATEMENT sql_mode = 'NO_ENGINE_SUBSTITUTION' FOR
20 CREATE TABLE t2 AS SELECT CONVERT(REPEAT('A', 255) USING UCS2) DIV 1 AS a;
21 Warnings:
22 Warning 1292 Truncated incorrect DECIMAL value: 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA...'
23 SHOW CREATE TABLE t2;
24 Table Create Table
25 t2 CREATE TABLE `t2` (
26 `a` bigint(21) DEFAULT NULL
27 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
28 #After the patch, no error is reported.
29 connection slave;
30 connection master;
31 DROP TABLE t1;
32 DROP TABLE t2;
33 include/rpl_end.inc