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

["Lei Chang (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HAWQ-273?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Lei Chang resolved HAWQ-273.
----------------------------
    Resolution: Fixed

> 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: Ming LI
>             Fix For: 2.0.0
>
>
> 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)