Debian Codegraph @

mysql-test/suite/binlog/t/binlog_stm_mysqlbinlog_collate_implicit.test

raw
1 -- source include/have_utf8.inc
2 -- source include/have_utf8mb4.inc
3 -- source include/have_ucs2.inc
4 -- source include/have_binlog_format_statement.inc
5 -- source include/have_log_bin.inc
6
7 --disable_query_log
8 CALL mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
9 --enable_query_log
10
11 RESET MASTER;
12 SET timestamp=1000000000;
13
14 --echo #
15 --echo # MDEV-30164 System variable for default collations
16 --echo #
17
18 SET character_set_collations='utf8mb3=utf8mb3_bin,ucs2=ucs2_bin';
19
20 CREATE TABLE t1 (a VARCHAR(20));
21 DROP TABLE t1;
22
23 CREATE TABLE t1 (a VARCHAR(20) CHARACTER SET utf8mb4);
24 DROP TABLE t1;
25
26 CREATE TABLE t1 (a VARCHAR(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin);
27 DROP TABLE t1;
28
29 CREATE TABLE t1 (a VARCHAR(20) CHARACTER SET utf8mb3);
30
31 INSERT INTO t1 VALUES ('a00');
32 INSERT INTO t1 VALUES (_utf8mb3'a01-utf8mb3');
33 INSERT INTO t1 VALUES (_utf8mb4'a01-utf8mb4');
34
35 PREPARE stmt FROM 'INSERT INTO t1 VALUES (?)';
36 EXECUTE stmt USING _utf8mb3'a02-utf8mb3';
37 EXECUTE stmt USING _utf8mb4'a02-utf8mb4';
38
39 EXECUTE stmt USING CONVERT('a03-utf8mb3' USING utf8mb3);
40 EXECUTE stmt USING CONVERT('a03-utf8mb4' USING utf8mb4);
41
42 EXECUTE stmt USING IF(0,CONVERT('a04-utf8mb3' USING utf8mb3),CONVERT('a03-utf8mb4' USING utf8mb4));
43 EXECUTE stmt USING IF(1,CONVERT('a04-utf8mb3' USING utf8mb3),CONVERT('a03-utf8mb4' USING utf8mb4));
44
45 DEALLOCATE PREPARE stmt;
46
47 DROP TABLE t1;
48
49 PREPARE stmt FROM 'CREATE TABLE t1 (a VARCHAR(20) CHARACTER SET utf8mb4)';
50 EXECUTE stmt;
51 DROP TABLE t1;
52 DEALLOCATE PREPARE stmt;
53
54 PREPARE stmt FROM 'CREATE TABLE t1 (a VARCHAR(20) CHARACTER SET utf8mb3)';
55 EXECUTE stmt;
56 DROP TABLE t1;
57 DEALLOCATE PREPARE stmt;
58
59
60 EXECUTE IMMEDIATE 'CREATE TABLE t1 (a VARCHAR(20) CHARACTER SET utf8mb4)';
61 DROP TABLE t1;
62
63 EXECUTE IMMEDIATE 'CREATE TABLE t1 (a VARCHAR(20) CHARACTER SET utf8mb3)';
64 DROP TABLE t1;
65
66
67 ### Starting master-bin.000002
68 FLUSH LOGS;
69
70 --disable_query_log
71 SELECT "--- ---- ---" as "";
72 --enable_query_log
73
74 let $MYSQLD_DATADIR= `select @@datadir`;
75 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
76 --replace_regex /SQL_LOAD_MB-[0-9a-f]+-[0-9a-f]+/SQL_LOAD_MB-#-#/ /@@session.sql_mode=\d+/@@session.sql_mode=#/ /collation_server=\d+/collation_server=#/
77 --exec $MYSQL_BINLOG --short-form --local-load=$MYSQLTEST_VARDIR/tmp/ $MYSQLD_DATADIR/master-bin.000001