diff options
Diffstat (limited to 'mysql-test/suite/innodb/r/innodb_bug49164.result')
| -rw-r--r-- | mysql-test/suite/innodb/r/innodb_bug49164.result | 52 |
1 files changed, 52 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/innodb_bug49164.result b/mysql-test/suite/innodb/r/innodb_bug49164.result new file mode 100644 index 00000000..857cd285 --- /dev/null +++ b/mysql-test/suite/innodb/r/innodb_bug49164.result @@ -0,0 +1,52 @@ +connect con1,localhost,root,,; +connect con2,localhost,root,,; +connection con1; +SET tx_isolation = 'READ-COMMITTED'; +CREATE TABLE bug49164 (a INT, b BIGINT, c TINYINT, PRIMARY KEY (a, b)) +ENGINE=InnoDB; +insert into bug49164 values (1,1,1), (2,2,2), (3,3,3); +begin; +update bug49164 set c=7; +select * from bug49164; +a b c +1 1 7 +2 2 7 +3 3 7 +rollback; +select * from bug49164; +a b c +1 1 1 +2 2 2 +3 3 3 +begin; +update bug49164 set c=7; +connection con2; +SET tx_isolation = 'READ-COMMITTED'; +begin; +select * from bug49164; +a b c +1 1 1 +2 2 2 +3 3 3 +commit; +begin; +update bug49164 set c=6 where a=1 and b=1; +connection con1; +rollback; +select * from bug49164; +a b c +1 1 1 +2 2 2 +3 3 3 +connection con2; +commit; +connection con1; +select * from bug49164; +a b c +1 1 6 +2 2 2 +3 3 3 +connection default; +disconnect con1; +disconnect con2; +drop table bug49164; |