Ming LI created HAWQ-273:
----------------------------
Summary: Concurrent read committed SELECT return 0 rows for AO
table which is ALTERed with REORGANIZE by other transaction
Key: HAWQ-273
URL: https://issues.apache.org/jira/browse/HAWQ-273
Project: Apache HAWQ
Issue Type: Bug
Components: Transaction
Reporter: Ming LI
Assignee: Lei Chang
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)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
