START TRANSACTION WITH CONSISTENT SNAPSHOT does not work for PBXT

Bug #499026 reported by Kristian Nielsen
6
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

Revision history for this message
Kristian Nielsen (knielsen) wrote :
Revision history for this message
Kristian Nielsen (knielsen) wrote :
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.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.