You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Sergey Soldatov (JIRA)" <ji...@apache.org> on 2018/01/19 05:40:00 UTC
[jira] [Commented] (PHOENIX-4534) upsert/delete/upsert for the same
row corrupts the indexes
[ https://issues.apache.org/jira/browse/PHOENIX-4534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16331767#comment-16331767 ]
Sergey Soldatov commented on PHOENIX-4534:
------------------------------------------
[~rajeshbabu] at first glance that would work. Possible we may want to get a patch for master branch and let jenkins check whether any of UT/IT fails?
> 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
>
>
> 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)