[teiid-issues] [JBoss JIRA] (TEIID-5075) Couchbase incorrect update count returned

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-5075?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13468197#comment-13468197 ] 

Steven Hawkins commented on TEIID-5075:
---------------------------------------

> update row count is 1 even though all 4 rows are inserted correctly into database.

There is an issue with the contract of the ExecutionFactory.   It needs to advertise returnsSingleUpdateCount true as it only returns a single update count even in a batch scenario.  

>  returned 'deleted number of rows' is 0, though the row was deleted from database.

The translator is looking in the wrong spot for that information.  The allRows result is empty for deletes, but it looks like there is a mutation count in the metrics that matches what we need.

> Couchbase incorrect update count returned
> -----------------------------------------
>
>                 Key: TEIID-5075
>                 URL: https://issues.jboss.org/browse/TEIID-5075
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 8.12.x-6.4
>            Reporter: Jan Stastny
>            Assignee: Steven Hawkins
>
> # For a bulk insert query:
> {code:sql}
> INSERT INTO SmallA (IntKey, StringKey) VALUES (100, '100'),(101, '101'),(102, '102'),(103, '103')
> {code}
> update row count is 1 even though all 4 rows are inserted correctly into database.
> # For a delete query:
> {code:sql}
> DELETE FROM SmallA WHERE StringKey=101;
> {code}
> returned 'deleted number of rows' is 0, though the row was deleted from database.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)