Max Shaposhnikov created PHOENIX-979:
----------------------------------------

             Summary: 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
            Reporter: Max Shaposhnikov
            Priority: Minor


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)

Reply via email to