bk commit into 5.0 tree (Sinisa:1.1777) BUG#8850

[sinisa]

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;