[
https://issues.apache.org/jira/browse/PHOENIX-979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14007382#comment-14007382
]
Hudson commented on PHOENIX-979:
--------------------------------
SUCCESS: Integrated in Phoenix #228 (See
[https://builds.apache.org/job/Phoenix/228/])
PHOENIX-979 Delete on key and non-key field (gabrielr: rev
4954c7371cf88dc19d314bb81b178100fae315f8)
* phoenix-core/src/it/java/org/apache/phoenix/end2end/DeleteIT.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/DeleteCompiler.java
> 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)
