phoenix-dev mailing list archives

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

    [ https://issues.apache.org/jira/browse/PHOENIX-2919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15311114#comment-15311114
] 

Hudson commented on PHOENIX-2919:
---------------------------------

FAILURE: Integrated in Phoenix-master #1239 (See [https://builds.apache.org/job/Phoenix-master/1239/])
PHOENIX-2919 PreparedStatement Returns Incorrect Number of Deleted (samarth: rev b8f40bf01e8b0e9990424777e023c74a762602f3)
* phoenix-core/src/main/java/org/apache/phoenix/compile/DeleteCompiler.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/DeleteIT.java


> 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