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)
