--- level_read_committed.result 2013-01-22 22:05:05.246633000 +0400 +++ level_read_committed.reject 2013-01-23 03:22:36.603654615 +0400 @@ -1,3 +1,9 @@ +# -- WARNING ---------------------------------------------------------------- +# According to I_S.ENGINES, MRG_MYISAM does not support transactions. +# If it is true, the test will most likely fail; you can +# either create an rdiff file, or add the test to disabled.def. +# If transactions should be supported, check the data in Information Schema. +# --------------------------------------------------------------------------- DROP TABLE IF EXISTS t1; connect con1,localhost,root,,; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; @@ -16,6 +22,7 @@ connection con1; SELECT a FROM t1; a +1 connection con2; INSERT INTO t1 (a) VALUES (2); # WARNING: Statement ended with errno 0, errname ''. @@ -23,25 +30,37 @@ connection con1; SELECT a FROM t1; a +1 +2 INSERT INTO t1 (a) SELECT a+100 FROM t1; # WARNING: Statement ended with errno 0, errname ''. # If it differs from the result file, it might indicate a problem. SELECT a FROM t1; a +1 +101 +102 +2 connection con2; SELECT a FROM t1; a 1 +101 +102 2 COMMIT; SELECT a FROM t1; a 1 +101 +102 2 connection con1; SELECT a FROM t1; a 1 +101 +102 2 INSERT INTO t1 (a) SELECT a+200 FROM t1; # WARNING: Statement ended with errno 0, errname ''. @@ -49,23 +68,35 @@ SELECT a FROM t1; a 1 +101 +102 2 201 202 +301 +302 COMMIT; SELECT a FROM t1; a 1 +101 +102 2 201 202 +301 +302 connection con2; SELECT a FROM t1; a 1 +101 +102 2 201 202 +301 +302 connection default; disconnect con1; disconnect con2;