[ https://issues.apache.org/jira/browse/CALCITE-1035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15088622#comment-15088622 ]
Josh Elser commented on CALCITE-1035: ------------------------------------- bq. Is this fixed in Calcite? Unknown. I have not gotten around to trying to reproduce it yet. > Avatica fetch does not return an update row-count for upsert, delete > -------------------------------------------------------------------- > > Key: CALCITE-1035 > URL: https://issues.apache.org/jira/browse/CALCITE-1035 > Project: Calcite > Issue Type: Bug > Components: avatica > Affects Versions: 1.5.0 > Environment: Hortonworks HDP 2.3 upgraded to Phoenix 4.5.0 > Reporter: Kevin Liew > Labels: avatica, calcite, fetch, phoenix, prepare, wireprotocol > > 1. prepare an upsert or delete > {noformat}request: { > "request": "prepare", > "connectionId": "c28224cd-a688-4117-af44-0d1510918bd8", > "sql": "upsert into test.integer_table values ('test3', ?)", > "maxRowCount": -1 > } > {noformat} > Response: > {noformat} > { > "response": "prepare", > "statement": { > "connectionId": "36acc5c4-0136-874a-2fcf-a3ec747d7FD4", > "id": 1532322378, > "signature": { > "columns": [ > > ], > "sql": "upsert into test.integer_table values ('test3', ?)", > "parameters": [ > { > "signed": false, > "precision": 0, > "scale": 0, > "parameterType": 4, > "typeName": "INTEGER", > "className": "java.lang.Integer", > "name": "?1" > } > ], > "cursorFactory": { > "style": "LIST", > "clazz": null, > "fieldNames": null > } > } > } > } > {noformat} > 2. execute by calling 'fetch' to Phoenix > {noformat} > request: { > "request": "fetch", > "connectionId": "36acc5c4-0136-874a-2fcf-a3ec747d7FD4", > "statementId": 1532322378, > "parameterValues": [ > { > "type": "INTEGER", > "value": 1 > } > ], > "offset": 0, > "fetchMaxRowCount": 100 > } > {noformat} > Result: > {noformat} > { > "response": "fetch", > "frame": { > "offset": 0, > "done": true, > "rows": [ > > ] > } > } > {noformat} > using prepareAndExecute, we get back an update row-count, but > prepareAndExecute cannot be used for parameterized statements -- This message was sent by Atlassian JIRA (v6.3.4#6332)