Debian Codegraph @

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

raw
1 # ==== Purpose ====
2 #
3 # Test verifies that reading binary log by using "SHOW BINLOG EVENTS" command
4 # from should correctly print the values of session variables such as
5 # foreign_key_checks, sql_auto_is_null, unique_checks etc
6 #
7 # ==== References ====
8 #
9 # MDEV-29804 SHOW BINLOG EVENTS produces semantically/syntactically incorrect statements
10
11
12 --source include/have_log_bin.inc
13 --source include/have_innodb.inc
14 --source include/have_binlog_format_statement.inc
15
16 reset master;
17
18 set foreign_key_checks= 0, sql_auto_is_null=1, check_constraint_checks=0, unique_checks=0;
19 create table t (a int, check(a>1), foreign key(a) references x (x)) engine=InnoDB as select 1 as a;
20
21 source include/show_binlog_events.inc;
22
23 # Cleanup
24 drop table t;
25 reset master;