bk commit into 6.0 tree (hakank:1.2821)

[Hakan Kuecuekyilmaz]

Below is the list of changes that have just been committed into a local
6.0 repository of hakan. When hakan 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@stripped, 2008-02-22 18:51:56+01:00, hakank@lu0011.(none) +2 -0
  Isolation level should be set before
  starting a transaction.

  mysql-test/suite/falcon/r/falcon_bug_22165.result@stripped, 2008-02-22 18:51:52+01:00,
hakank@lu0011.(none) +1 -1
    Adjust result file.

  mysql-test/suite/falcon/t/falcon_bug_22165.test@stripped, 2008-02-22 18:51:53+01:00,
hakank@lu0011.(none) +1 -1
    Isolation level should be set before
    starting a transaction.

diff -Nrup a/mysql-test/suite/falcon/r/falcon_bug_22165.result
b/mysql-test/suite/falcon/r/falcon_bug_22165.result
--- a/mysql-test/suite/falcon/r/falcon_bug_22165.result	2008-02-06 16:21:11 +01:00
+++ b/mysql-test/suite/falcon/r/falcon_bug_22165.result	2008-02-22 18:51:52 +01:00
@@ -15,8 +15,8 @@ declare continue handler for sqlexceptio
 ALTER TABLE t1 MODIFY COLUMN c timestamp;
 end;
 while v < 10 do
-START TRANSACTION;
 SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
+START TRANSACTION;
 INSERT INTO t1 (a, b) VALUES (v, 'a');
 UPDATE t1 SET c = current_timestamp WHERE a = v;
 COMMIT;
diff -Nrup a/mysql-test/suite/falcon/t/falcon_bug_22165.test
b/mysql-test/suite/falcon/t/falcon_bug_22165.test
--- a/mysql-test/suite/falcon/t/falcon_bug_22165.test	2008-02-06 16:21:11 +01:00
+++ b/mysql-test/suite/falcon/t/falcon_bug_22165.test	2008-02-22 18:51:53 +01:00
@@ -29,8 +29,8 @@ begin
     ALTER TABLE t1 MODIFY COLUMN c timestamp;
   end;
   while v < 10 do
-    START TRANSACTION;
     SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
+    START TRANSACTION;
     INSERT INTO t1 (a, b) VALUES (v, 'a');
     UPDATE t1 SET c = current_timestamp WHERE a = v;
     COMMIT;