[
https://issues.apache.org/jira/browse/PHOENIX-2919?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Brian Esserlieu updated PHOENIX-2919:
-------------------------------------
Attachment: PhoenixDeletionError.java
Class is configured to run against a localhost cluster so may need to be
modified depending on test environment.
> 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
> Attachments: 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)
