From ff3079c8d0f27a54b55cb2685aa9fd1cb498bc1a Mon Sep 17 00:00:00 2001 From: unknown Date: Fri, 20 Jan 2006 17:21:39 +0300 Subject: Test case for BUG#16621: INSERTs in Stored Procedures causes data corruption in the Binary Log. mysql-test/r/rpl_sp.result: Update result file. mysql-test/t/rpl_sp.test: Add test case for BUG#16621: INSERTs in Stored Procedures causes data corruption in the Binary Log. --- mysql-test/r/rpl_sp.result | 13 +++++++++++++ 1 file changed, 13 insertions(+) (limited to 'mysql-test/r/rpl_sp.result') diff --git a/mysql-test/r/rpl_sp.result b/mysql-test/r/rpl_sp.result index c9a9e162fa6..7180b677b8e 100644 --- a/mysql-test/r/rpl_sp.result +++ b/mysql-test/r/rpl_sp.result @@ -401,5 +401,18 @@ drop function f1; select * from t1; a 1 +DROP PROCEDURE IF EXISTS p1; +DROP TABLE IF EXISTS t1; +CREATE TABLE t1(col VARCHAR(10)); +CREATE PROCEDURE p1(arg VARCHAR(10)) +INSERT INTO t1 VALUES(arg); +CALL p1('test'); +SELECT * FROM t1; +col +test +SELECT * FROM t1; +col +test +DROP PROCEDURE p1; drop table t1; reset master; -- cgit v1.2.1