[jira] [Resolved] (PHOENIX-979) DELETE deletes row when WHERE contains PK fields but other than PK conditions are false

["Gabriel Reid (JIRA)" <ji...@apache.org>]

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

Gabriel Reid resolved PHOENIX-979.
----------------------------------

       Resolution: Fixed
    Fix Version/s: 4.1
                   3.1
                   5.0.0

Pushed to 3.0, 4.0, and master branches

> DELETE deletes row when WHERE contains PK fields but other than PK conditions are false
> ---------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-979
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-979
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 3.0.0, 4.0.0
>            Reporter: Max Shaposhnikov
>            Assignee: Gabriel Reid
>            Priority: Blocker
>             Fix For: 5.0.0, 3.1, 4.1
>
>         Attachments: PHOENIX-979.patch
>
>
> example is
> CREATE TABLE test_table (pk_field INTEGER NOT NULL PRIMARY KEY, secondary_field INTEGER NOT NULL)
> UPSERT INTO test_table (pk_field, secondary_field) VALUES (5,7)
> DELETE FROM test_table WHERE pk_field = 5 AND secondary_field = 6
> last delete will delete record, while WHERE condition contains secondary_field = 6, but record itself has secondary_field = 7



--
This message was sent by Atlassian JIRA
(v6.2#6252)