phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rajeshbabu Chintaguntla (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-4534) upsert/delete/upsert for the same row corrupts the indexes
Date Tue, 23 Jan 2018 09:10:00 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-4534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16335537#comment-16335537
] 

Rajeshbabu Chintaguntla commented on PHOENIX-4534:
--------------------------------------------------

[~sergey.soldatov] Those failures are not related to the patch. They are failing even without
patch as well. In the previous comments I have given 4 test cases failing always.

{noformat}

failed these unit tests: ./phoenix-core/target/failsafe-reports/TEST-org.apache.phoenix.end2end.LocalIndexSplitMergeIT

./phoenix-core/target/failsafe-reports/TEST-org.apache.phoenix.end2end.OrderByIT ./phoenix-core/target/failsafe-reports/TEST-org.apache.phoenix.end2end.RowValueConstructorIT

./phoenix-core/target/failsafe-reports/TEST-org.apache.phoenix.end2end.index.IndexMetadataIT

./phoenix-core/target/failsafe-reports/TEST-org.apache.phoenix.end2end.DefaultColumnValueIT

{noformat}

> upsert/delete/upsert for the same row corrupts the indexes
> ----------------------------------------------------------
>
>                 Key: PHOENIX-4534
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-4534
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 5.0
>            Reporter: Romil Choksi
>            Assignee: Rajeshbabu Chintaguntla
>            Priority: Critical
>              Labels: HBase-2.0
>             Fix For: 5.0
>
>         Attachments: PHOENIX-4534.patch, PHOENIX-4534_v2.patch, PHOENIX-4534_v3.patch
>
>
> If we delete and upsert again the same row, the corresponding index has a null value.

> {noformat}
> 0: jdbc:phoenix:> create table a (id integer primary key, f float);
> No rows affected (2.272 seconds)
> 0: jdbc:phoenix:> create index i1 on a (f);
> No rows affected (5.769 seconds)
> 0: jdbc:phoenix:> upsert into a values (1,0.5);
> 1 row affected (0.021 seconds)
> 0: jdbc:phoenix:> select * from i1;
> +------+------+
> | 0:F  | :ID  |
> +------+------+
> | 0.5  | 1    |
> +------+------+
> 1 row selected (0.016 seconds)
> 0: jdbc:phoenix:> delete from a where id = 1;
> 1 row affected (0.009 seconds)
> 0: jdbc:phoenix:> select * from i1;
> +------+------+
> | 0:F  | :ID  |
> +------+------+
> +------+------+
> No rows selected (0.015 seconds)
> 0: jdbc:phoenix:> upsert into a values (1,0.5);
> 1 row affected (0.008 seconds)
> 0: jdbc:phoenix:> select * from i1;
> +-------+------+
> |  0:F  | :ID  |
> +-------+------+
> | null  | 1    |
> +-------+------+
> 1 row selected (0.013 seconds)
> {noformat}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message