You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Max Shaposhnikov (JIRA)" <ji...@apache.org> on 2014/05/13 20:26:16 UTC
[jira] [Created] (PHOENIX-979) DELETE deletes row when WHERE
contains PK fields but other than PK conditions are false
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)