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] [Assigned] (PHOENIX-4911) Local index has stale data upon deletion of rows
Date Thu, 20 Sep 2018 15:43:00 GMT

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

Rajeshbabu Chintaguntla reassigned PHOENIX-4911:
------------------------------------------------

    Assignee: Rajeshbabu Chintaguntla

> Local index has stale data upon deletion of rows
> ------------------------------------------------
>
>                 Key: PHOENIX-4911
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-4911
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.13.2-cdh5.11.2, 5.0.0, 5.1.0
>            Reporter: Ievgen Nekrashevych
>            Assignee: Rajeshbabu Chintaguntla
>            Priority: Major
>
> When deleting data from main table index table seem to have stale data, and when the
row upserted again - index has wrong values.
> Reproducable with script:
> {code}
> create schema if not exists TS
> create table if not exists TS.TEST (STR varchar not null,INTCOL bigint not null, STARTTIME
integer, DUMMY integer default 0 CONSTRAINT PK PRIMARY KEY (STR, INTCOL))
> create local index if not exists "TEST_INDEX" on TS.TEST (STR,STARTTIME)
> -- optional delete
> -- delete from TS.TEST
> upsert into TS.TEST(STR,INTCOL,STARTTIME,DUMMY) values ('TEST',4,1,3)
> delete from TS.TEST
> upsert into TS.TEST(STR, INTCOL, STARTTIME, DUMMY) values ('TEST',4,2,4)
> delete from TS.TEST
> upsert into TS.TEST(STR, INTCOL, DUMMY) values ('TEST',4,5)
>  
> SELECT /*+NO_INDEX*/* FROM TS.TEST where STR = 'TEST'
> -- yields: STARTTIME = null
> SELECT /*+TEST_INDEX*/ * FROM TS.TEST where STR = 'TEST'
> -- yields: STARTTIME = 2
> {code}



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

Mime
View raw message