[jira] [Created] (PHOENIX-2919) PreparedStatement Returns Incorrect Number of Deleted Records

["Brian Esserlieu (JIRA)" <ji...@apache.org>]

Brian Esserlieu created PHOENIX-2919:
----------------------------------------

             Summary: 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


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)