START TRANSACTION WITH CONSISTENT SNAPSHOT does not work for PBXT
Bug #499026 reported by
Kristian Nielsen
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
PBXT |
Fix Committed
|
Undecided
|
Vladimir Kolesnikov |
Bug Description
CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=innodb;
CREATE TABLE t2 (a INT PRIMARY KEY) ENGINE=pbxt;
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
START TRANSACTION WITH CONSISTENT SNAPSHOT;
SELECT * FROM t1;
# Let another transaction change table t2 ...
SELECT * FROM t2;
The last SELECT should not see the changes made to t2 by other transactions
after executing START TRANSACTION WITH CONSISTENT SNAPSHOT, however they do.
This works correctly when table t2 is an InnoDB table.
Tested on latest MariaDB lp:maria.
Full test case and result file attached.
Related branches
lp:~vkolesnikov/pbxt/pbxt-bug-499026
- PBXT Core: Pending requested
-
Diff: 273 lines (+211/-1)6 files modifiedChangeLog (+2/-0)
src/ha_pbxt.cc (+24/-0)
test/mysql-test/pbxt-test-run.pl (+3/-1)
test/mysql-test/r/pbxt_snapshot.result (+76/-0)
test/mysql-test/t/pbxt_snapshot-master.opt (+2/-0)
test/mysql-test/t/pbxt_snapshot.test (+104/-0)
Changed in pbxt: | |
assignee: | nobody → Vladimir Kolesnikov (vkolesnikov) |
status: | New → In Progress |
Changed in pbxt: | |
status: | In Progress → Fix Committed |
To post a comment you must log in.