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