diff options
| author | unknown <anozdrin@mysql.com> | 2006-01-20 17:21:39 +0300 |
|---|---|---|
| committer | unknown <anozdrin@mysql.com> | 2006-01-20 17:21:39 +0300 |
| commit | ff3079c8d0f27a54b55cb2685aa9fd1cb498bc1a (patch) | |
| tree | 38686f4365817f897be1fb457449d63decef52c3 /mysql-test/r/rpl_sp.result | |
| parent | b688b196979b8385a7463e8dcd83afdd0af6ca69 (diff) | |
| download | mariadb-git-ff3079c8d0f27a54b55cb2685aa9fd1cb498bc1a.tar.gz | |
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.
Diffstat (limited to 'mysql-test/r/rpl_sp.result')
| -rw-r--r-- | mysql-test/r/rpl_sp.result | 13 |
1 files changed, 13 insertions, 0 deletions
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; |