Gecko [ 122.154.134.11 ]

Name	Size	Permission
binlog_base64_flag.test	5.38 KB	-rw-r--r--
binlog_bug23533.test	1.45 KB	-rw-r--r--
binlog_bug36391-master.opt	32 B	-rw-r--r--
binlog_bug36391.test	1023 B	-rw-r--r--
binlog_database.test	369 B	-rw-r--r--
binlog_delete_and_flush_index....	3.49 KB	-rw-r--r--
binlog_drop_if_exists.test	3.47 KB	-rw-r--r--
binlog_grant.test	1.82 KB	-rw-r--r--
binlog_incident-master.opt	52 B	-rw-r--r--
binlog_incident.test	939 B	-rw-r--r--
binlog_index-master.opt	16 B	-rw-r--r--
binlog_index.test	7.34 KB	-rw-r--r--
binlog_innodb.test	3.97 KB	-rw-r--r--
binlog_innodb_row.test	2.19 KB	-rw-r--r--
binlog_killed.test	8.21 KB	-rw-r--r--
binlog_killed_simulate-master....	39 B	-rw-r--r--
binlog_killed_simulate.test	2.54 KB	-rw-r--r--
binlog_mix_innodb_stat.test	230 B	-rw-r--r--
binlog_mixed_failure_mixing_en...	143 B	-rw-r--r--
binlog_mixed_load_data.test	501 B	-rw-r--r--
binlog_multi_engine.test	2.78 KB	-rw-r--r--
binlog_mysqlbinlog-cp932-maste...	23 B	-rw-r--r--
binlog_mysqlbinlog-cp932.test	975 B	-rw-r--r--
binlog_mysqlbinlog2.test	7.07 KB	-rw-r--r--
binlog_mysqlbinlog_base64.test	2.45 KB	-rw-r--r--
binlog_mysqlbinlog_row.test	10.67 KB	-rw-r--r--
binlog_mysqlbinlog_row_innodb....	638 B	-rw-r--r--
binlog_mysqlbinlog_row_myisam....	631 B	-rw-r--r--
binlog_mysqlbinlog_row_trans.t...	3.71 KB	-rw-r--r--
binlog_old_versions.test	4.99 KB	-rw-r--r--
binlog_query_filter_rules-mast...	40 B	-rw-r--r--
binlog_query_filter_rules.test	808 B	-rw-r--r--
binlog_reset_master.test	998 B	-rw-r--r--
binlog_row_binlog-master.opt	24 B	-rw-r--r--
binlog_row_binlog.test	223 B	-rw-r--r--
binlog_row_ctype_cp932.test	228 B	-rw-r--r--
binlog_row_ctype_ucs.test	234 B	-rw-r--r--
binlog_row_drop_tmp_tbl.test	232 B	-rw-r--r--
binlog_row_failure_mixing_engi...	141 B	-rw-r--r--
binlog_row_innodb_stat-master....	26 B	-rw-r--r--
binlog_row_innodb_stat.test	228 B	-rw-r--r--
binlog_row_insert_select.test	471 B	-rw-r--r--
binlog_row_mix_innodb_myisam-m...	29 B	-rw-r--r--
binlog_row_mix_innodb_myisam.t...	545 B	-rw-r--r--
binlog_row_mysqlbinlog_db_filt...	4.12 KB	-rw-r--r--
binlog_row_mysqlbinlog_verbose...	3.76 KB	-rw-r--r--
binlog_server_id.test	663 B	-rw-r--r--
binlog_sf.test	2.67 KB	-rw-r--r--
binlog_sql_mode.test	4.58 KB	-rw-r--r--
binlog_start_comment.test	900 B	-rw-r--r--
binlog_statement_insert_delaye...	336 B	-rw-r--r--
binlog_stm_binlog-master.opt	40 B	-rw-r--r--
binlog_stm_binlog.test	483 B	-rw-r--r--
binlog_stm_blackhole.test	267 B	-rw-r--r--
binlog_stm_ctype_cp932.test	278 B	-rw-r--r--
binlog_stm_ctype_ucs.test	249 B	-rw-r--r--
binlog_stm_do_db-master.opt	38 B	-rw-r--r--
binlog_stm_do_db.test	2.78 KB	-rw-r--r--
binlog_stm_drop_tmp_tbl.test	247 B	-rw-r--r--
binlog_stm_innodb_stat-master....	26 B	-rw-r--r--
binlog_stm_innodb_stat.test	234 B	-rw-r--r--
binlog_stm_insert_select.test	252 B	-rw-r--r--
binlog_stm_mix_innodb_myisam-m...	29 B	-rw-r--r--
binlog_stm_mix_innodb_myisam.t...	512 B	-rw-r--r--
binlog_stm_ps.test	701 B	-rw-r--r--
binlog_stm_row.test	3.06 KB	-rw-r--r--
binlog_stm_unsafe_warning-mast...	38 B	-rw-r--r--
binlog_stm_unsafe_warning.test	3.7 KB	-rw-r--r--
binlog_tmp_table.test	3.94 KB	-rw-r--r--
binlog_truncate_innodb-master....	14 B	-rw-r--r--
binlog_truncate_innodb.test	1.07 KB	-rw-r--r--
binlog_truncate_myisam.test	352 B	-rw-r--r--
binlog_unsafe.test	13.34 KB	-rw-r--r--
binlog_write_error.test	2.31 KB	-rw-r--r--
disabled.def	634 B	-rw-r--r--

Code Editor : binlog_sql_mode.test

# ==== Purpose ====
#
# Test that sql_mode can correct restore before generating the binlog event
#    when creating CREATEable objects.
#
# ==== Method ====
#
# Scan binlog file to check if the sql_mode is still set to 0 before generating binlog event
#

-- source include/have_log_bin.inc

# BUG#39526 sql_mode not retained in binary log for CREATE PROCEDURE

SET @old_sql_mode=  @@global.sql_mode;
SET @old_binlog_format=@@session.binlog_format;
let $MYSQLD_DATADIR= `select @@datadir`;
SET SESSION sql_mode=8;

--echo Initialization

RESET MASTER;
CREATE TABLE t1 (id INT);

CREATE PROCEDURE testProc() SELECT * FROM t1;
CREATE VIEW testView as SELECT * from t1;

DELIMITER |;
CREATE FUNCTION testFunc()
  RETURNS INT
  BEGIN
    return 1;
  END;|
DELIMITER ;|

DELIMITER |;
CREATE TRIGGER testTrig BEFORE INSERT ON t1
  FOR EACH ROW BEGIN
    UPDATE t1 SET id = id +1;
  END;|
DELIMITER ;|

DELIMITER |;
CREATE EVENT testEvent ON SCHEDULE
  EVERY 1 DAY
  DO
    BEGIN
      UPDATE t1 SET id = id +1;
    END;|
DELIMITER ;|

--echo Check Result

let $MYSQLD_DATADIR= `select @@datadir`;
--exec $MYSQL_BINLOG --force-if-open $MYSQLD_DATADIR/master-bin.000001 > $MYSQLTEST_VARDIR/tmp/mysqlbinlog_bug39526.binlog
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
eval select
(@a:=load_file("$MYSQLTEST_VARDIR/tmp/mysqlbinlog_bug39526.binlog"))
is not null;
let $s_mode_unsigned= `select @a like "%@@session.sql_mode=0%" /* must return 0 */`;
echo *** String sql_mode=0 is found: $s_mode_unsigned ***;

--remove_file $MYSQLTEST_VARDIR/tmp/mysqlbinlog_bug39526.binlog

--echo Clean Up

DROP PROCEDURE testProc;
DROP FUNCTION testFunc;
DROP TRIGGER testTrig;
DROP EVENT testEvent;
DROP VIEW testView;
DROP TABLE t1;

SET @@global.sql_mode= @old_sql_mode;
SET @@session.binlog_format=@old_binlog_format;

--echo 
--echo #
--echo # Test for Bug#12601974 - STORED PROCEDURE SQL_MODE=NO_BACKSLASH_ESCAPES
--echo # IGNORED AND BREAKS REPLICATION
--echo #

--disable_warnings
DROP DATABASE IF EXISTS mysqltest_db;
DROP TABLE IF EXISTS test_table;
--enable_warnings

CREATE DATABASE mysqltest_db;
USE mysqltest_db;
CREATE TABLE test_table (c1 CHAR(50));

SET @org_mode=@@sql_mode;

SET @@sql_mode='';
DELIMITER $;
CREATE PROCEDURE proc_without_sql_mode (IN param1 CHAR(50), IN param2 CHAR(50))
BEGIN
  DECLARE var1 CHAR(50) DEFAULT param1;
  DECLARE var2 CHAR(50) DEFAULT param2;
  DECLARE var3 CHAR(50) DEFAULT 'abcd\bef';
  DECLARE var4 CHAR(50) DEFAULT 'abcd\nef';
  DECLARE var5 CHAR(50) DEFAULT 'abcd\ref';
  DECLARE var6 CHAR(50) DEFAULT 'abcd\tef';
  DECLARE var7 CHAR(50) DEFAULT 'abcd\\ef';
  DECLARE var8 CHAR(50) DEFAULT 'abcd\%ef';
  DECLARE var9 CHAR(50) DEFAULT 'abcd\_ef';

INSERT INTO test_table VALUES (var1);
  INSERT INTO test_table VALUES (var2);
  INSERT INTO test_table VALUES (var3);
  INSERT INTO test_table VALUES (var4);
  INSERT INTO test_table VALUES (var5);
  INSERT INTO test_table VALUES (var6);
  INSERT INTO test_table VALUES (var7);
  INSERT INTO test_table VALUES (var8);
  INSERT INTO test_table VALUES (var9);
END
$

SET @@sql_mode='NO_BACKSLASH_ESCAPES'$
CREATE PROCEDURE proc_with_sql_mode (IN param1 CHAR(50), IN param2 CHAR(50))
BEGIN
  DECLARE var1 CHAR(50) DEFAULT param1;
  DECLARE var2 CHAR(50) DEFAULT param2;
  DECLARE var3 CHAR(50) DEFAULT 'wxyz\bef';
  DECLARE var4 CHAR(50) DEFAULT 'wxyz\nef';
  DECLARE var5 CHAR(50) DEFAULT 'wxyz\ref';
  DECLARE var6 CHAR(50) DEFAULT 'wxyz\tef';
  DECLARE var7 CHAR(50) DEFAULT 'wxyz\\ef';
  DECLARE var8 CHAR(50) DEFAULT 'wxyz\%ef';
  DECLARE var9 CHAR(50) DEFAULT 'wxyz\_ef';

DELIMITER ;$
SET @@sql_mode='';
CALL proc_without_sql_mode('abcd\'ef', 'abcd\"ef');
CALL proc_with_sql_mode('wxyz\'ef', 'wxyz\"ef');
SELECT * FROM test_table;

let $MYSQLD_DATADIR= `select @@datadir`;
--exec $MYSQL_BINLOG --force-if-open -d mysqltest_db $MYSQLD_DATADIR/master-bin.000001 > $MYSQLTEST_VARDIR/tmp/mysqlbinlog_bug12601974.binlog

--echo "Dropping table test_table"
DROP TABLE test_table;

--exec $MYSQL -e "source $MYSQLTEST_VARDIR/tmp/mysqlbinlog_bug12601974.binlog"

--echo #"test_table" content after replaying the binlog
SELECT * FROM test_table;

--echo #Clean up
--remove_file $MYSQLTEST_VARDIR/tmp/mysqlbinlog_bug12601974.binlog
DROP DATABASE mysqltest_db;
SET @@sql_mode= @org_mode;
use test;

--echo 
--echo #End of Test for Bug#12601974

${this.title}

Code Editor : binlog_sql_mode.test