[
https://issues.apache.org/jira/browse/PHOENIX-2919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15308906#comment-15308906
]
James Taylor commented on PHOENIX-2919:
---------------------------------------
+1
> PreparedStatement Returns Incorrect Number of Deleted Records
> -------------------------------------------------------------
>
> Key: PHOENIX-2919
> URL: https://issues.apache.org/jira/browse/PHOENIX-2919
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.7.0
> Reporter: Brian Esserlieu
> Assignee: Samarth Jain
> Labels: SFDC
> Fix For: 4.8.0
>
> Attachments: PHOENIX-2919.patch, PhoenixDeletionError.java
>
>
> The java.sql.PreparedStatement.executeUpdate() return contract states the
> following:
> "Returns:
> either (1) the row count for SQL Data Manipulation Language (DML) statements
> or (2) 0 for SQL statements that return nothing".
> Phoenix deletion statements that delete 1000 or more records return an
> incorrect value from executeUpdate().
> REPRO:
> Execute this table create statement:
> DROP TABLE IF EXISTS TEST_TABLE;
> CREATE TABLE IF NOT EXISTS TEST_TABLE (
> pk1 DECIMAL NOT NULL,
> v1 VARCHAR
> CONSTRAINT PK PRIMARY KEY
> (
> pk1
> )
> );
> Then see and execute the attached Java class to see repro.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
