Debian Codegraph @

mysql-test/suite/rpl_nogtid/t/rpl_binlog_sql_mode.test

raw
1 # ==== Purpose ====
2 #
3 # Check the removal of sql_mode flags from routines' metadata.
4 #
5 # List of removed modes:
6 #
7 # - POSTGRESQL (0x00100)
8 # - ORACLE (0x00200)
9 # - MSSQL (0x00400)
10 # - DB2 (0x00800)
11 # - MAXDB (0x01000)
12 # - NO_KEY_OPTIONS (0x02000)
13 # - NO_TABLE_OPTIONS (0x04000)
14 # - NO_FIELD_OPTIONS (0x08000)
15 # - MYSQL323 (0x10000)
16 # - MYSQL40 (0x20000)
17 # - NO_AUTO_CREAETE_USER (0x10000000)
18 #
19 # ==== Implementation ====
20 #
21 # Setup "fake replication" where the slave only starts the SQL thread,
22 # not the IO thread, and reads from an existing relay log that has
23 # been prepared so that it contains the error. This requires some
24 # extra server options: see the -master.opt file.
25
26 --source include/not_group_replication_plugin.inc
27 --let $rpl_skip_start_slave= 1
28 --source include/not_have_privilege_checks_user.inc
29 --source include/master-slave.inc
30
31 --echo ==== Initialize ====
32 --connection slave
33
34 # The binlog we read does funny things with triggers and causes this warning.
35 --disable_query_log
36 CALL mtr.add_suppression('Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT');
37 CALL mtr.add_suppression("Either event.*is from an old source");
38 --enable_query_log
39
40 # Need to restore this at the end; CHANGE MASTER modifies it (see the
41 # manual for CHANGE MASTER).
42 SET @old_relay_log_purge= @@global.relay_log_purge;
43
44
45 # the relay log contains CREATE SCHEMA db1; CREATE PROCEDURE p_...
46 --let $fake_relay_log = $MYSQL_TEST_DIR/std_data/bug27213339-bin.000001
47 --source include/setup_fake_relay_log.inc
48
49 --echo ==== Test ====
50 --source include/start_slave_sql.inc
51 --let $slave_param= Exec_Master_Log_Pos
52 --let $slave_param_value=11102
53 --source include/wait_for_slave_param.inc
54
55 --echo ==== Check ====
56
57 SHOW CREATE EVENT db1.e_DB2;
58 SHOW CREATE EVENT db1.e_MAXDB;
59 SHOW CREATE EVENT db1.e_MSSQL;
60 SHOW CREATE EVENT db1.e_MYSQL323;
61 SHOW CREATE EVENT db1.e_MYSQL40;
62 SHOW CREATE EVENT db1.e_NO_FIELD_OPTIONS;
63 SHOW CREATE EVENT db1.e_NO_KEY_OPTIONS;
64 SHOW CREATE EVENT db1.e_NO_TABLE_OPTIONS;
65 SHOW CREATE EVENT db1.e_ORACLE;
66 SHOW CREATE EVENT db1.e_POSTGRESQL;
67 SHOW CREATE EVENT db1.e1;
68
69
70 SHOW CREATE FUNCTION db1.f_DB2;
71 SHOW CREATE FUNCTION db1.f_MAXDB;
72 SHOW CREATE FUNCTION db1.f_MSSQL;
73 SHOW CREATE FUNCTION db1.f_MYSQL323;
74 SHOW CREATE FUNCTION db1.f_MYSQL40;
75 SHOW CREATE FUNCTION db1.f_NO_FIELD_OPTIONS;
76 SHOW CREATE FUNCTION db1.f_NO_KEY_OPTIONS;
77 SHOW CREATE FUNCTION db1.f_NO_TABLE_OPTIONS;
78 SHOW CREATE FUNCTION db1.f_ORACLE;
79 SHOW CREATE FUNCTION db1.f_POSTGRESQL;
80 SHOW CREATE FUNCTION db1.f1;
81
82 SHOW CREATE PROCEDURE db1.p_DB2;
83 SHOW CREATE PROCEDURE db1.p_MAXDB;
84 SHOW CREATE PROCEDURE db1.p_MSSQL;
85 SHOW CREATE PROCEDURE db1.p_MYSQL323;
86 SHOW CREATE PROCEDURE db1.p_MYSQL40;
87 SHOW CREATE PROCEDURE db1.p_NO_FIELD_OPTIONS;
88 SHOW CREATE PROCEDURE db1.p_NO_KEY_OPTIONS;
89 SHOW CREATE PROCEDURE db1.p_NO_TABLE_OPTIONS;
90 SHOW CREATE PROCEDURE db1.p_ORACLE;
91 SHOW CREATE PROCEDURE db1.p_POSTGRESQL;
92 SHOW CREATE PROCEDURE db1.p1;
93
94 SHOW CREATE TRIGGER db1.t_DB2;
95 SHOW CREATE TRIGGER db1.t_MAXDB;
96 SHOW CREATE TRIGGER db1.t_MSSQL;
97 SHOW CREATE TRIGGER db1.t_MYSQL323;
98 SHOW CREATE TRIGGER db1.t_MYSQL40;
99 SHOW CREATE TRIGGER db1.t_NO_FIELD_OPTIONS;
100 SHOW CREATE TRIGGER db1.t_NO_KEY_OPTIONS;
101 SHOW CREATE TRIGGER db1.t_NO_TABLE_OPTIONS;
102 SHOW CREATE TRIGGER db1.t_ORACLE;
103 SHOW CREATE TRIGGER db1.t_POSTGRESQL;
104 SHOW CREATE TRIGGER db1.t1;
105
106 --echo ==== Clean up ====
107
108 DROP SCHEMA db1;
109
110 --source include/stop_slave_sql.inc
111 --source include/cleanup_fake_relay_log.inc
112
113 #
114 # Dump the relay binlog file using mysqlbinlog to show sql_mode filtering:
115 #
116 # SET @@session.sql_mode = ... & /*!80005 &~0x1003ff00*/
117 #
118 # We should use --short-form everywhere because in other case output will
119 # be time dependend. Better than nothing.
120 #
121 let $MYSQLD_DATADIR= `select @@datadir`;
122 --let $mysqlbinlog_parameters= --short-form --local-load=$MYSQLTEST_VARDIR/tmp/ $MYSQL_TEST_DIR/std_data/bug27213339-bin.000001
123 --source include/mysqlbinlog.inc
124
125
126 SET @@global.relay_log_purge= @old_relay_log_purge;
127 --let $rpl_only_running_threads= 1
128 --source include/rpl_end.inc