Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.4.7, 11.8.3
-
None
-
OS: Ubuntu-20.04 LTS
Description
Isolation Level: Read Uncommitted.
The SELECT statement is affected by the blocked statement in another concurrent transaction.
/* init */ DROP TABLE IF EXISTS t; |
/* init */ CREATE TABLE t(c1 INT NOT NULL, c2 INT NOT NULL); |
/* init */ INSERT INTO t(c1,c2) VALUES (2, 2); |
|
/* t1 */ BEGIN; |
/* t2 */ BEGIN; |
/* t2 */ INSERT INTO t(c1,c2) VALUES (5, 5); |
/* t2 */ SELECT * FROM t; -- [(2, 2), (5, 5)] |
/* t1 */ SELECT * FROM t; -- [(2, 2), (5, 5)] |
/* t1 */ DELETE FROM t WHERE TRUE; -- blocked |
/* t2 */ SELECT * FROM t ; -- [(5, 5)] |
/* t2 */ COMMIT; -- t1 unblocked |
/* t1 */ COMMIT; |
When the DELETE statement in transaction t1 is blocked, strangely, the second SELECT statement in transaction t2 only retrieved (5, 5), but failed to retrieve (2, 2).