From: Date: March 8 2005 9:44pm Subject: bk commit into 5.0 tree (Sinisa:1.1777) BUG#8850 List-Archive: http://lists.mysql.com/internals/22794 X-Bug: 8850 Message-Id: <200503082044.j28Kind3022924@sinisa.nasamreza.org> Below is the list of changes that have just been committed into a local 5.0 repository of Sinisa. When Sinisa does a push these changes will be propagated to the main repository and, within 24 hours after the push, to the public repository. For information on how to access the public repository see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html ChangeSet 1.1777 05/03/08 22:44:35 Sinisa@stripped +2 -0 making a better test case for bug #8850 mysql-test/t/sp.test 1.106 05/03/08 22:44:17 Sinisa@stripped +2 -1 making a new test with autocommit set to 0 and 1. Second CALL is in autocommit mode to prove that the relevant bug (bug #8550) is fixed. mysql-test/r/sp.result 1.112 05/03/08 22:44:17 Sinisa@stripped +2 -1 fixing results for new test # This is a BitKeeper patch. What follows are the unified diffs for the # set of deltas contained in the patch. The rest of the patch, the part # that BitKeeper cares about, is below these diffs. # User: Sinisa # Host: sinisa.nasamreza.org # Root: /mnt/work/petica --- 1.111/mysql-test/r/sp.result Sat Mar 5 21:44:02 2005 +++ 1.112/mysql-test/r/sp.result Tue Mar 8 22:44:17 2005 @@ -2545,11 +2545,12 @@ truncate table t1; insert t1 values (1); rollback; end | -begin; +set autocommit=0; insert t1 values (2); call sp1(); ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction commit; +set autocommit=1; select * from t1; a 2 --- 1.105/mysql-test/t/sp.test Sat Mar 5 21:44:02 2005 +++ 1.106/mysql-test/t/sp.test Tue Mar 8 22:44:17 2005 @@ -3087,11 +3087,12 @@ end | delimiter ;| -begin; +set autocommit=0; insert t1 values (2); --error 1192 call sp1(); commit; +set autocommit=1; select * from t1; call sp1(); select * from t1;