Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_binlog_sql_mode.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 ==== Initialize ====
7 SET @old_relay_log_purge= @@global.relay_log_purge;
8 include/setup_fake_relay_log.inc
9 Setting up fake replication from MYSQL_TEST_DIR/std_data/bug27213339-bin.000001
10 ==== Test ====
11 include/start_slave_sql.inc
12 include/wait_for_slave_param.inc [Exec_Master_Log_Pos]
13 ==== Check ====
14 SHOW CREATE EVENT db1.e_DB2;
15 Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
16 e_DB2 PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `e_DB2` ON SCHEDULE EVERY 100 WEEK STARTS '2018-01-23 12:11:33' ON COMPLETION NOT PRESERVE DISABLE ON SLAVE DO SELECT 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
17 SHOW CREATE EVENT db1.e_MAXDB;
18 Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
19 e_MAXDB PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `e_MAXDB` ON SCHEDULE EVERY 100 WEEK STARTS '2018-01-23 12:11:33' ON COMPLETION NOT PRESERVE DISABLE ON SLAVE DO SELECT 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
20 SHOW CREATE EVENT db1.e_MSSQL;
21 Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
22 e_MSSQL PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `e_MSSQL` ON SCHEDULE EVERY 100 WEEK STARTS '2018-01-23 12:11:33' ON COMPLETION NOT PRESERVE DISABLE ON SLAVE DO SELECT 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
23 SHOW CREATE EVENT db1.e_MYSQL323;
24 Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
25 e_MYSQL323 HIGH_NOT_PRECEDENCE SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `e_MYSQL323` ON SCHEDULE EVERY 100 WEEK STARTS '2018-01-23 12:11:33' ON COMPLETION NOT PRESERVE DISABLE ON SLAVE DO SELECT 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
26 SHOW CREATE EVENT db1.e_MYSQL40;
27 Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
28 e_MYSQL40 HIGH_NOT_PRECEDENCE SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `e_MYSQL40` ON SCHEDULE EVERY 100 WEEK STARTS '2018-01-23 12:11:33' ON COMPLETION NOT PRESERVE DISABLE ON SLAVE DO SELECT 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
29 SHOW CREATE EVENT db1.e_NO_FIELD_OPTIONS;
30 Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
31 e_NO_FIELD_OPTIONS SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `e_NO_FIELD_OPTIONS` ON SCHEDULE EVERY 100 WEEK STARTS '2018-01-23 12:11:33' ON COMPLETION NOT PRESERVE DISABLE ON SLAVE DO SELECT 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
32 SHOW CREATE EVENT db1.e_NO_KEY_OPTIONS;
33 Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
34 e_NO_KEY_OPTIONS SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `e_NO_KEY_OPTIONS` ON SCHEDULE EVERY 100 WEEK STARTS '2018-01-23 12:11:33' ON COMPLETION NOT PRESERVE DISABLE ON SLAVE DO SELECT 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
35 SHOW CREATE EVENT db1.e_NO_TABLE_OPTIONS;
36 Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
37 e_NO_TABLE_OPTIONS SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `e_NO_TABLE_OPTIONS` ON SCHEDULE EVERY 100 WEEK STARTS '2018-01-23 12:11:33' ON COMPLETION NOT PRESERVE DISABLE ON SLAVE DO SELECT 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
38 SHOW CREATE EVENT db1.e_ORACLE;
39 Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
40 e_ORACLE PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `e_ORACLE` ON SCHEDULE EVERY 100 WEEK STARTS '2018-01-23 12:11:33' ON COMPLETION NOT PRESERVE DISABLE ON SLAVE DO SELECT 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
41 SHOW CREATE EVENT db1.e_POSTGRESQL;
42 Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
43 e_POSTGRESQL PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `e_POSTGRESQL` ON SCHEDULE EVERY 100 WEEK STARTS '2018-01-23 12:11:33' ON COMPLETION NOT PRESERVE DISABLE ON SLAVE DO SELECT 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
44 SHOW CREATE EVENT db1.e1;
45 Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
46 e1 PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,HIGH_NOT_PRECEDENCE SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `e1` ON SCHEDULE EVERY 100 WEEK STARTS '2018-01-23 12:11:33' ON COMPLETION NOT PRESERVE DISABLE ON SLAVE DO SELECT 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
47 SHOW CREATE FUNCTION db1.f_DB2;
48 Function sql_mode Create Function character_set_client collation_connection Database Collation
49 f_DB2 PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE CREATE DEFINER="root"@"localhost" FUNCTION "f_DB2"() RETURNS int
50 RETURN 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
51 SHOW CREATE FUNCTION db1.f_MAXDB;
52 Function sql_mode Create Function character_set_client collation_connection Database Collation
53 f_MAXDB PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE CREATE DEFINER="root"@"localhost" FUNCTION "f_MAXDB"() RETURNS int
54 RETURN 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
55 SHOW CREATE FUNCTION db1.f_MSSQL;
56 Function sql_mode Create Function character_set_client collation_connection Database Collation
57 f_MSSQL PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE CREATE DEFINER="root"@"localhost" FUNCTION "f_MSSQL"() RETURNS int
58 RETURN 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
59 SHOW CREATE FUNCTION db1.f_MYSQL323;
60 Function sql_mode Create Function character_set_client collation_connection Database Collation
61 f_MYSQL323 HIGH_NOT_PRECEDENCE CREATE DEFINER=`root`@`localhost` FUNCTION `f_MYSQL323`() RETURNS int
62 RETURN 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
63 SHOW CREATE FUNCTION db1.f_MYSQL40;
64 Function sql_mode Create Function character_set_client collation_connection Database Collation
65 f_MYSQL40 HIGH_NOT_PRECEDENCE CREATE DEFINER=`root`@`localhost` FUNCTION `f_MYSQL40`() RETURNS int
66 RETURN 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
67 SHOW CREATE FUNCTION db1.f_NO_FIELD_OPTIONS;
68 Function sql_mode Create Function character_set_client collation_connection Database Collation
69 f_NO_FIELD_OPTIONS CREATE DEFINER=`root`@`localhost` FUNCTION `f_NO_FIELD_OPTIONS`() RETURNS int
70 RETURN 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
71 SHOW CREATE FUNCTION db1.f_NO_KEY_OPTIONS;
72 Function sql_mode Create Function character_set_client collation_connection Database Collation
73 f_NO_KEY_OPTIONS CREATE DEFINER=`root`@`localhost` FUNCTION `f_NO_KEY_OPTIONS`() RETURNS int
74 RETURN 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
75 SHOW CREATE FUNCTION db1.f_NO_TABLE_OPTIONS;
76 Function sql_mode Create Function character_set_client collation_connection Database Collation
77 f_NO_TABLE_OPTIONS CREATE DEFINER=`root`@`localhost` FUNCTION `f_NO_TABLE_OPTIONS`() RETURNS int
78 RETURN 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
79 SHOW CREATE FUNCTION db1.f_ORACLE;
80 Function sql_mode Create Function character_set_client collation_connection Database Collation
81 f_ORACLE PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE CREATE DEFINER="root"@"localhost" FUNCTION "f_ORACLE"() RETURNS int
82 RETURN 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
83 SHOW CREATE FUNCTION db1.f_POSTGRESQL;
84 Function sql_mode Create Function character_set_client collation_connection Database Collation
85 f_POSTGRESQL PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE CREATE DEFINER="root"@"localhost" FUNCTION "f_POSTGRESQL"() RETURNS int
86 RETURN 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
87 SHOW CREATE FUNCTION db1.f1;
88 Function sql_mode Create Function character_set_client collation_connection Database Collation
89 f1 PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,HIGH_NOT_PRECEDENCE CREATE DEFINER="root"@"localhost" FUNCTION "f1"() RETURNS int
90 RETURN 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
91 SHOW CREATE PROCEDURE db1.p_DB2;
92 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
93 p_DB2 PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE CREATE DEFINER="root"@"localhost" PROCEDURE "p_DB2"()
94 SELECT 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
95 SHOW CREATE PROCEDURE db1.p_MAXDB;
96 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
97 p_MAXDB PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE CREATE DEFINER="root"@"localhost" PROCEDURE "p_MAXDB"()
98 SELECT 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
99 SHOW CREATE PROCEDURE db1.p_MSSQL;
100 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
101 p_MSSQL PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE CREATE DEFINER="root"@"localhost" PROCEDURE "p_MSSQL"()
102 SELECT 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
103 SHOW CREATE PROCEDURE db1.p_MYSQL323;
104 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
105 p_MYSQL323 HIGH_NOT_PRECEDENCE CREATE DEFINER=`root`@`localhost` PROCEDURE `p_MYSQL323`()
106 SELECT 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
107 SHOW CREATE PROCEDURE db1.p_MYSQL40;
108 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
109 p_MYSQL40 HIGH_NOT_PRECEDENCE CREATE DEFINER=`root`@`localhost` PROCEDURE `p_MYSQL40`()
110 SELECT 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
111 SHOW CREATE PROCEDURE db1.p_NO_FIELD_OPTIONS;
112 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
113 p_NO_FIELD_OPTIONS CREATE DEFINER=`root`@`localhost` PROCEDURE `p_NO_FIELD_OPTIONS`()
114 SELECT 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
115 SHOW CREATE PROCEDURE db1.p_NO_KEY_OPTIONS;
116 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
117 p_NO_KEY_OPTIONS CREATE DEFINER=`root`@`localhost` PROCEDURE `p_NO_KEY_OPTIONS`()
118 SELECT 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
119 SHOW CREATE PROCEDURE db1.p_NO_TABLE_OPTIONS;
120 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
121 p_NO_TABLE_OPTIONS CREATE DEFINER=`root`@`localhost` PROCEDURE `p_NO_TABLE_OPTIONS`()
122 SELECT 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
123 SHOW CREATE PROCEDURE db1.p_ORACLE;
124 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
125 p_ORACLE PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE CREATE DEFINER="root"@"localhost" PROCEDURE "p_ORACLE"()
126 SELECT 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
127 SHOW CREATE PROCEDURE db1.p_POSTGRESQL;
128 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
129 p_POSTGRESQL PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE CREATE DEFINER="root"@"localhost" PROCEDURE "p_POSTGRESQL"()
130 SELECT 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
131 SHOW CREATE PROCEDURE db1.p1;
132 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
133 p1 PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,HIGH_NOT_PRECEDENCE CREATE DEFINER="root"@"localhost" PROCEDURE "p1"()
134 SELECT 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci
135 SHOW CREATE TRIGGER db1.t_DB2;
136 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
137 t_DB2 PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE CREATE DEFINER=`root`@`localhost` TRIGGER `t_DB2` BEFORE INSERT ON `t1` FOR EACH ROW SET @foo = 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci 2018-01-23 12:11:33.63
138 SHOW CREATE TRIGGER db1.t_MAXDB;
139 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
140 t_MAXDB PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE CREATE DEFINER=`root`@`localhost` TRIGGER `t_MAXDB` BEFORE INSERT ON `t1` FOR EACH ROW SET @foo = 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci 2018-01-23 12:11:33.63
141 SHOW CREATE TRIGGER db1.t_MSSQL;
142 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
143 t_MSSQL PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE CREATE DEFINER=`root`@`localhost` TRIGGER `t_MSSQL` BEFORE INSERT ON `t1` FOR EACH ROW SET @foo = 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci 2018-01-23 12:11:33.64
144 SHOW CREATE TRIGGER db1.t_MYSQL323;
145 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
146 t_MYSQL323 HIGH_NOT_PRECEDENCE CREATE DEFINER=`root`@`localhost` TRIGGER `t_MYSQL323` BEFORE INSERT ON `t1` FOR EACH ROW SET @foo = 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci 2018-01-23 12:11:33.64
147 SHOW CREATE TRIGGER db1.t_MYSQL40;
148 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
149 t_MYSQL40 HIGH_NOT_PRECEDENCE CREATE DEFINER=`root`@`localhost` TRIGGER `t_MYSQL40` BEFORE INSERT ON `t1` FOR EACH ROW SET @foo = 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci 2018-01-23 12:11:33.65
150 SHOW CREATE TRIGGER db1.t_NO_FIELD_OPTIONS;
151 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
152 t_NO_FIELD_OPTIONS CREATE DEFINER=`root`@`localhost` TRIGGER `t_NO_FIELD_OPTIONS` BEFORE INSERT ON `t1` FOR EACH ROW SET @foo = 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci 2018-01-23 12:11:33.65
153 SHOW CREATE TRIGGER db1.t_NO_KEY_OPTIONS;
154 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
155 t_NO_KEY_OPTIONS CREATE DEFINER=`root`@`localhost` TRIGGER `t_NO_KEY_OPTIONS` BEFORE INSERT ON `t1` FOR EACH ROW SET @foo = 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci 2018-01-23 12:11:33.66
156 SHOW CREATE TRIGGER db1.t_NO_TABLE_OPTIONS;
157 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
158 t_NO_TABLE_OPTIONS CREATE DEFINER=`root`@`localhost` TRIGGER `t_NO_TABLE_OPTIONS` BEFORE INSERT ON `t1` FOR EACH ROW SET @foo = 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci 2018-01-23 12:11:33.66
159 SHOW CREATE TRIGGER db1.t_ORACLE;
160 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
161 t_ORACLE PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE CREATE DEFINER=`root`@`localhost` TRIGGER `t_ORACLE` BEFORE INSERT ON `t1` FOR EACH ROW SET @foo = 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci 2018-01-23 12:11:33.67
162 SHOW CREATE TRIGGER db1.t_POSTGRESQL;
163 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
164 t_POSTGRESQL PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE CREATE DEFINER=`root`@`localhost` TRIGGER `t_POSTGRESQL` BEFORE INSERT ON `t1` FOR EACH ROW SET @foo = 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci 2018-01-23 12:11:33.67
165 SHOW CREATE TRIGGER db1.t1;
166 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
167 t1 PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,HIGH_NOT_PRECEDENCE CREATE DEFINER=`root`@`localhost` TRIGGER `t1` BEFORE INSERT ON `t1` FOR EACH ROW SET @foo = 1 utf8mb3 utf8mb3_general_ci latin1_swedish_ci 2018-01-23 12:11:33.68
168 ==== Clean up ====
169 DROP SCHEMA db1;
170 include/stop_slave_sql.inc
171 include/cleanup_fake_relay_log.inc
172 include/mysqlbinlog.inc
173 # The proper term is pseudo_replica_mode, but we use this compatibility alias
174 # to make the statement usable on server versions 8.0.24 and older.
175 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
176 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
177 DELIMITER /*!*/;
178 ROLLBACK/*!*/;
179 # [empty]
180 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
181 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
182 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
183 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
184 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
185 SET @@SESSION.GTID_NEXT= '#'/*!*/;
186 SET TIMESTAMP=#/*!*/;
187 SET @@session.pseudo_thread_id=#/*!*/;
188 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
189 SET @@session.sql_mode=1436549152/*!80005 &~0x1003ff00*//*!*/;
190 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
191 /*!\C utf8mb3 *//*!*/;
192 SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=8/*!*/;
193 SET @@session.lc_time_names=0/*!*/;
194 SET @@session.collation_database=DEFAULT/*!*/;
195 CREATE SCHEMA db1
196 /*!*/;
197 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
198 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
199 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
200 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
201 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
202 SET @@SESSION.GTID_NEXT= '#'/*!*/;
203 use `db1`/*!*/;
204 SET TIMESTAMP=#/*!*/;
205 CREATE TABLE t1 (i INT)
206 /*!*/;
207 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
208 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
209 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
210 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
211 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
212 SET @@SESSION.GTID_NEXT= '#'/*!*/;
213 SET TIMESTAMP=#/*!*/;
214 SET @@session.sql_mode=59406/*!80005 &~0x1003ff00*//*!*/;
215 CREATE DEFINER="root"@"localhost" PROCEDURE "p_DB2"()
216 SELECT 1
217 /*!*/;
218 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
219 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
220 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
221 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
222 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
223 SET @@SESSION.GTID_NEXT= '#'/*!*/;
224 SET TIMESTAMP=#/*!*/;
225 CREATE DEFINER="root"@"localhost" FUNCTION "f_DB2"() RETURNS int(11)
226 RETURN 1
227 /*!*/;
228 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
229 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
230 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
231 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
232 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
233 SET @@SESSION.GTID_NEXT= '#'/*!*/;
234 SET TIMESTAMP=#.631960/*!*/;
235 CREATE DEFINER="root"@"localhost" TRIGGER t_DB2 BEFORE INSERT ON t1 FOR EACH ROW SET @foo = 1
236 /*!*/;
237 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
238 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
239 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
240 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
241 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
242 SET @@SESSION.GTID_NEXT= '#'/*!*/;
243 SET TIMESTAMP=#/*!*/;
244 SET @@session.time_zone='SYSTEM'/*!*/;
245 CREATE DEFINER="root"@"localhost" EVENT e_DB2 ON SCHEDULE EVERY 100 WEEK DO SELECT 1
246 /*!*/;
247 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
248 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
249 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
250 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
251 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
252 SET @@SESSION.GTID_NEXT= '#'/*!*/;
253 SET TIMESTAMP=#/*!*/;
254 SET @@session.sql_mode=268496910/*!80005 &~0x1003ff00*//*!*/;
255 CREATE DEFINER="root"@"localhost" PROCEDURE "p_MAXDB"()
256 SELECT 1
257 /*!*/;
258 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
259 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
260 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
261 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
262 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
263 SET @@SESSION.GTID_NEXT= '#'/*!*/;
264 SET TIMESTAMP=#/*!*/;
265 CREATE DEFINER="root"@"localhost" FUNCTION "f_MAXDB"() RETURNS int(11)
266 RETURN 1
267 /*!*/;
268 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
269 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
270 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
271 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
272 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
273 SET @@SESSION.GTID_NEXT= '#'/*!*/;
274 SET TIMESTAMP=#.638945/*!*/;
275 CREATE DEFINER="root"@"localhost" TRIGGER t_MAXDB BEFORE INSERT ON t1 FOR EACH ROW SET @foo = 1
276 /*!*/;
277 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
278 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
279 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
280 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
281 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
282 SET @@SESSION.GTID_NEXT= '#'/*!*/;
283 SET TIMESTAMP=#/*!*/;
284 CREATE DEFINER="root"@"localhost" EVENT e_MAXDB ON SCHEDULE EVERY 100 WEEK DO SELECT 1
285 /*!*/;
286 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
287 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
288 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
289 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
290 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
291 SET @@SESSION.GTID_NEXT= '#'/*!*/;
292 SET TIMESTAMP=#/*!*/;
293 SET @@session.sql_mode=58382/*!80005 &~0x1003ff00*//*!*/;
294 CREATE DEFINER="root"@"localhost" PROCEDURE "p_MSSQL"()
295 SELECT 1
296 /*!*/;
297 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
298 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
299 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
300 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
301 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
302 SET @@SESSION.GTID_NEXT= '#'/*!*/;
303 SET TIMESTAMP=#/*!*/;
304 CREATE DEFINER="root"@"localhost" FUNCTION "f_MSSQL"() RETURNS int(11)
305 RETURN 1
306 /*!*/;
307 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
308 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
309 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
310 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
311 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
312 SET @@SESSION.GTID_NEXT= '#'/*!*/;
313 SET TIMESTAMP=#.643491/*!*/;
314 CREATE DEFINER="root"@"localhost" TRIGGER t_MSSQL BEFORE INSERT ON t1 FOR EACH ROW SET @foo = 1
315 /*!*/;
316 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
317 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
318 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
319 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
320 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
321 SET @@SESSION.GTID_NEXT= '#'/*!*/;
322 SET TIMESTAMP=#/*!*/;
323 CREATE DEFINER="root"@"localhost" EVENT e_MSSQL ON SCHEDULE EVERY 100 WEEK DO SELECT 1
324 /*!*/;
325 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
326 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
327 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
328 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
329 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
330 SET @@SESSION.GTID_NEXT= '#'/*!*/;
331 SET TIMESTAMP=#/*!*/;
332 SET @@session.sql_mode=536936448/*!80005 &~0x1003ff00*//*!*/;
333 CREATE DEFINER=`root`@`localhost` PROCEDURE `p_MYSQL323`()
334 SELECT 1
335 /*!*/;
336 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
337 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
338 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
339 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
340 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
341 SET @@SESSION.GTID_NEXT= '#'/*!*/;
342 SET TIMESTAMP=#/*!*/;
343 CREATE DEFINER=`root`@`localhost` FUNCTION `f_MYSQL323`() RETURNS int(11)
344 RETURN 1
345 /*!*/;
346 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
347 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
348 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
349 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
350 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
351 SET @@SESSION.GTID_NEXT= '#'/*!*/;
352 SET TIMESTAMP=#.647664/*!*/;
353 CREATE DEFINER=`root`@`localhost` TRIGGER t_MYSQL323 BEFORE INSERT ON t1 FOR EACH ROW SET @foo = 1
354 /*!*/;
355 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
356 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
357 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
358 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
359 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
360 SET @@SESSION.GTID_NEXT= '#'/*!*/;
361 SET TIMESTAMP=#/*!*/;
362 CREATE DEFINER=`root`@`localhost` EVENT e_MYSQL323 ON SCHEDULE EVERY 100 WEEK DO SELECT 1
363 /*!*/;
364 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
365 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
366 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
367 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
368 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
369 SET @@SESSION.GTID_NEXT= '#'/*!*/;
370 SET TIMESTAMP=#/*!*/;
371 SET @@session.sql_mode=537001984/*!80005 &~0x1003ff00*//*!*/;
372 CREATE DEFINER=`root`@`localhost` PROCEDURE `p_MYSQL40`()
373 SELECT 1
374 /*!*/;
375 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
376 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
377 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
378 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
379 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
380 SET @@SESSION.GTID_NEXT= '#'/*!*/;
381 SET TIMESTAMP=#/*!*/;
382 CREATE DEFINER=`root`@`localhost` FUNCTION `f_MYSQL40`() RETURNS int(11)
383 RETURN 1
384 /*!*/;
385 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
386 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
387 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
388 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
389 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
390 SET @@SESSION.GTID_NEXT= '#'/*!*/;
391 SET TIMESTAMP=#.652147/*!*/;
392 CREATE DEFINER=`root`@`localhost` TRIGGER t_MYSQL40 BEFORE INSERT ON t1 FOR EACH ROW SET @foo = 1
393 /*!*/;
394 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
395 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
396 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
397 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
398 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
399 SET @@SESSION.GTID_NEXT= '#'/*!*/;
400 SET TIMESTAMP=#/*!*/;
401 CREATE DEFINER=`root`@`localhost` EVENT e_MYSQL40 ON SCHEDULE EVERY 100 WEEK DO SELECT 1
402 /*!*/;
403 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
404 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
405 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
406 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
407 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
408 SET @@SESSION.GTID_NEXT= '#'/*!*/;
409 SET TIMESTAMP=#/*!*/;
410 SET @@session.sql_mode=32768/*!80005 &~0x1003ff00*//*!*/;
411 CREATE DEFINER=`root`@`localhost` PROCEDURE `p_NO_FIELD_OPTIONS`()
412 SELECT 1
413 /*!*/;
414 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
415 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
416 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
417 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
418 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
419 SET @@SESSION.GTID_NEXT= '#'/*!*/;
420 SET TIMESTAMP=#/*!*/;
421 CREATE DEFINER=`root`@`localhost` FUNCTION `f_NO_FIELD_OPTIONS`() RETURNS int(11)
422 RETURN 1
423 /*!*/;
424 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
425 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
426 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
427 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
428 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
429 SET @@SESSION.GTID_NEXT= '#'/*!*/;
430 SET TIMESTAMP=#.656900/*!*/;
431 CREATE DEFINER=`root`@`localhost` TRIGGER t_NO_FIELD_OPTIONS BEFORE INSERT ON t1 FOR EACH ROW SET @foo = 1
432 /*!*/;
433 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
434 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
435 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
436 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
437 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
438 SET @@SESSION.GTID_NEXT= '#'/*!*/;
439 SET TIMESTAMP=#/*!*/;
440 CREATE DEFINER=`root`@`localhost` EVENT e_NO_FIELD_OPTIONS ON SCHEDULE EVERY 100 WEEK DO SELECT 1
441 /*!*/;
442 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
443 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
444 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
445 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
446 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
447 SET @@SESSION.GTID_NEXT= '#'/*!*/;
448 SET TIMESTAMP=#/*!*/;
449 SET @@session.sql_mode=8192/*!80005 &~0x1003ff00*//*!*/;
450 CREATE DEFINER=`root`@`localhost` PROCEDURE `p_NO_KEY_OPTIONS`()
451 SELECT 1
452 /*!*/;
453 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
454 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
455 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
456 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
457 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
458 SET @@SESSION.GTID_NEXT= '#'/*!*/;
459 SET TIMESTAMP=#/*!*/;
460 CREATE DEFINER=`root`@`localhost` FUNCTION `f_NO_KEY_OPTIONS`() RETURNS int(11)
461 RETURN 1
462 /*!*/;
463 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
464 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
465 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
466 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
467 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
468 SET @@SESSION.GTID_NEXT= '#'/*!*/;
469 SET TIMESTAMP=#.661728/*!*/;
470 CREATE DEFINER=`root`@`localhost` TRIGGER t_NO_KEY_OPTIONS BEFORE INSERT ON t1 FOR EACH ROW SET @foo = 1
471 /*!*/;
472 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
473 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
474 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
475 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
476 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
477 SET @@SESSION.GTID_NEXT= '#'/*!*/;
478 SET TIMESTAMP=#/*!*/;
479 CREATE DEFINER=`root`@`localhost` EVENT e_NO_KEY_OPTIONS ON SCHEDULE EVERY 100 WEEK DO SELECT 1
480 /*!*/;
481 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
482 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
483 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
484 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
485 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
486 SET @@SESSION.GTID_NEXT= '#'/*!*/;
487 SET TIMESTAMP=#/*!*/;
488 SET @@session.sql_mode=16384/*!80005 &~0x1003ff00*//*!*/;
489 CREATE DEFINER=`root`@`localhost` PROCEDURE `p_NO_TABLE_OPTIONS`()
490 SELECT 1
491 /*!*/;
492 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
493 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
494 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
495 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
496 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
497 SET @@SESSION.GTID_NEXT= '#'/*!*/;
498 SET TIMESTAMP=#/*!*/;
499 CREATE DEFINER=`root`@`localhost` FUNCTION `f_NO_TABLE_OPTIONS`() RETURNS int(11)
500 RETURN 1
501 /*!*/;
502 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
503 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
504 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
505 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
506 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
507 SET @@SESSION.GTID_NEXT= '#'/*!*/;
508 SET TIMESTAMP=#.666717/*!*/;
509 CREATE DEFINER=`root`@`localhost` TRIGGER t_NO_TABLE_OPTIONS BEFORE INSERT ON t1 FOR EACH ROW SET @foo = 1
510 /*!*/;
511 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
512 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
513 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
514 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
515 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
516 SET @@SESSION.GTID_NEXT= '#'/*!*/;
517 SET TIMESTAMP=#/*!*/;
518 CREATE DEFINER=`root`@`localhost` EVENT e_NO_TABLE_OPTIONS ON SCHEDULE EVERY 100 WEEK DO SELECT 1
519 /*!*/;
520 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
521 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
522 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
523 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
524 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
525 SET @@SESSION.GTID_NEXT= '#'/*!*/;
526 SET TIMESTAMP=#/*!*/;
527 SET @@session.sql_mode=268493326/*!80005 &~0x1003ff00*//*!*/;
528 CREATE DEFINER="root"@"localhost" PROCEDURE "p_ORACLE"()
529 SELECT 1
530 /*!*/;
531 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
532 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
533 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
534 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
535 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
536 SET @@SESSION.GTID_NEXT= '#'/*!*/;
537 SET TIMESTAMP=#/*!*/;
538 CREATE DEFINER="root"@"localhost" FUNCTION "f_ORACLE"() RETURNS int(11)
539 RETURN 1
540 /*!*/;
541 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
542 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
543 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
544 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
545 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
546 SET @@SESSION.GTID_NEXT= '#'/*!*/;
547 SET TIMESTAMP=#.671967/*!*/;
548 CREATE DEFINER="root"@"localhost" TRIGGER t_ORACLE BEFORE INSERT ON t1 FOR EACH ROW SET @foo = 1
549 /*!*/;
550 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
551 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
552 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
553 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
554 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
555 SET @@SESSION.GTID_NEXT= '#'/*!*/;
556 SET TIMESTAMP=#/*!*/;
557 CREATE DEFINER="root"@"localhost" EVENT e_ORACLE ON SCHEDULE EVERY 100 WEEK DO SELECT 1
558 /*!*/;
559 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
560 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
561 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
562 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
563 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
564 SET @@SESSION.GTID_NEXT= '#'/*!*/;
565 SET TIMESTAMP=#/*!*/;
566 SET @@session.sql_mode=57614/*!80005 &~0x1003ff00*//*!*/;
567 CREATE DEFINER="root"@"localhost" PROCEDURE "p_POSTGRESQL"()
568 SELECT 1
569 /*!*/;
570 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
571 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
572 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
573 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
574 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
575 SET @@SESSION.GTID_NEXT= '#'/*!*/;
576 SET TIMESTAMP=#/*!*/;
577 CREATE DEFINER="root"@"localhost" FUNCTION "f_POSTGRESQL"() RETURNS int(11)
578 RETURN 1
579 /*!*/;
580 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
581 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
582 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
583 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
584 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
585 SET @@SESSION.GTID_NEXT= '#'/*!*/;
586 SET TIMESTAMP=#.677247/*!*/;
587 CREATE DEFINER="root"@"localhost" TRIGGER t_POSTGRESQL BEFORE INSERT ON t1 FOR EACH ROW SET @foo = 1
588 /*!*/;
589 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
590 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
591 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
592 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
593 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
594 SET @@SESSION.GTID_NEXT= '#'/*!*/;
595 SET TIMESTAMP=#/*!*/;
596 CREATE DEFINER="root"@"localhost" EVENT e_POSTGRESQL ON SCHEDULE EVERY 100 WEEK DO SELECT 1
597 /*!*/;
598 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
599 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
600 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
601 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
602 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
603 SET @@SESSION.GTID_NEXT= '#'/*!*/;
604 SET TIMESTAMP=#/*!*/;
605 SET @@session.sql_mode=805568270/*!80005 &~0x1003ff00*//*!*/;
606 CREATE DEFINER="root"@"localhost" PROCEDURE "p1"()
607 SELECT 1
608 /*!*/;
609 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
610 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
611 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
612 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
613 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
614 SET @@SESSION.GTID_NEXT= '#'/*!*/;
615 SET TIMESTAMP=#/*!*/;
616 CREATE DEFINER="root"@"localhost" FUNCTION "f1"() RETURNS int(11)
617 RETURN 1
618 /*!*/;
619 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
620 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
621 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
622 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
623 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
624 SET @@SESSION.GTID_NEXT= '#'/*!*/;
625 SET TIMESTAMP=#.682763/*!*/;
626 CREATE DEFINER="root"@"localhost" TRIGGER t1 BEFORE INSERT ON t1 FOR EACH ROW SET @foo = 1
627 /*!*/;
628 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
629 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
630 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
631 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
632 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
633 SET @@SESSION.GTID_NEXT= '#'/*!*/;
634 SET TIMESTAMP=#/*!*/;
635 CREATE DEFINER="root"@"localhost" EVENT e1 ON SCHEDULE EVERY 100 WEEK DO SELECT 1
636 /*!*/;
637 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
638 DELIMITER ;
639 # End of log file
640 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
641 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
642 SET @@global.relay_log_purge= @old_relay_log_purge;
643 include/rpl_end.inc