Server IP : 172.67.216.182 / Your IP : 162.158.108.43 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /www/server/mysql/src/mysql-test/suite/binlog/r/ |
Upload File : |
SET @old_sql_mode= @@global.sql_mode; SET @old_binlog_format=@@session.binlog_format; SET SESSION sql_mode=8; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. Initialization RESET MASTER; CREATE TABLE t1 (id INT); CREATE PROCEDURE testProc() SELECT * FROM t1; CREATE VIEW testView as SELECT * from t1; CREATE FUNCTION testFunc() RETURNS INT BEGIN return 1; END;| CREATE TRIGGER testTrig BEFORE INSERT ON t1 FOR EACH ROW BEGIN UPDATE t1 SET id = id +1; END;| CREATE EVENT testEvent ON SCHEDULE EVERY 1 DAY DO BEGIN UPDATE t1 SET id = id +1; END;| Check Result select (@a:=load_file("MYSQLTEST_VARDIR/tmp/mysqlbinlog_bug39526.binlog")) is not null AS Loaded; Loaded 1 *** String sql_mode=0 is found: 0 *** 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; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SET @@session.binlog_format=@old_binlog_format; # # Test for Bug#12601974 - STORED PROCEDURE SQL_MODE=NO_BACKSLASH_ESCAPES # IGNORED AND BREAKS REPLICATION # DROP DATABASE IF EXISTS mysqltest_db; DROP TABLE IF EXISTS test_table; CREATE DATABASE mysqltest_db; USE mysqltest_db; CREATE TABLE test_table (c1 CHAR(50)); SET @org_mode=@@sql_mode; SET @@sql_mode=''; 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'; 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=''; CALL proc_without_sql_mode('abcd\'ef', 'abcd\"ef'); CALL proc_with_sql_mode('wxyz\'ef', 'wxyz\"ef'); SELECT * FROM test_table; c1 abcd'ef abcd"ef abcdef abcd ef abcd ef abcd ef abcd\ef abcd\%ef abcd\_ef wxyz'ef wxyz"ef wxyz\bef wxyz\nef wxyz\ref wxyz\tef wxyz\\ef wxyz\%ef wxyz\_ef "Dropping table test_table" DROP TABLE test_table; RESET MASTER; #"test_table" content after replaying the binlog SELECT * FROM test_table; c1 abcd'ef abcd"ef abcdef abcd ef abcd ef abcd ef abcd\ef abcd\%ef abcd\_ef wxyz'ef wxyz"ef wxyz\bef wxyz\nef wxyz\ref wxyz\tef wxyz\\ef wxyz\%ef wxyz\_ef #Clean up DROP DATABASE mysqltest_db; SET @@sql_mode= @org_mode; use test; #End of Test for Bug#12601974