You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Gabriel Reid (JIRA)" <ji...@apache.org> on 2014/05/20 20:42:38 UTC
[jira] [Updated] (PHOENIX-979) DELETE deletes row when WHERE
contains PK fields but other than PK conditions are false
[ https://issues.apache.org/jira/browse/PHOENIX-979?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gabriel Reid updated PHOENIX-979:
---------------------------------
Priority: Blocker (was: Minor)
Affects Version/s: 4.0.0
Assignee: Gabriel Reid
Changing this to blocker, as it will result in unexpected data loss.
> 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
>
> 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)