phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Samarth Jain (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (PHOENIX-2919) PreparedStatement Returns Incorrect Number of Deleted Records
Date Wed, 01 Jun 2016 19:09:59 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-2919?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Samarth Jain resolved PHOENIX-2919.
-----------------------------------
    Resolution: Fixed

> 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)

Mime
View raw message