[HAWQ-273] Concurrent read committed SELECT return 0 rows for AO table which is ALTERed with REORGANIZE by other transaction

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Resolved
• Fix Version/s: 2.0.0.0-incubating
• Component/s: Transaction
• Assignee: Ming Li
• Reporter: Ming Li
• Created: 23/Dec/15 07:58
• Updated: 14/Jul/16 17:58
• Resolved: 14/Jul/16 17:58

Description

testdb=# DROP TABLE tbl_isolation;
DROP TABLE
testdb=# CREATE TABLE tbl_isolation (a INT, b int, c int) WITH (appendonly=true);
CREATE TABLE
testdb=# INSERT INTO tbl_isolation SELECT generate_series(1, 100000), generate_series(1, 100000), generate_series(1, 100000);
INSERT 0 100000
•
Thread A:
testdb=# BEGIN transaction isolation level SERIALIZABLE;
BEGIN
testdb=# ALTER TABLE tbl_isolation set with ( reorganize='true') distributed randomly;
ALTER TABLE
•
Thread B:
testdb=# BEGIN transaction isolation level read committed;
BEGIN
testdb=# select count from tbl_isolation;
•
Thread A:
testdb=# commit;
COMMIT
•
•
Thread B:
testdb=# select count from tbl_isolation;
count
-------
0
(1 row)