[
https://issues.apache.org/jira/browse/CALCITE-1035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15070148#comment-15070148
]
Kevin Liew edited comment on CALCITE-1035 at 12/24/15 12:30 AM:
----------------------------------------------------------------
I wasn't able to test with Calcite 1.5.0 and we aren't using Java code. We are
sending REST requests in over http (and updating the fetch request with the new
statement id). For testing purposes, you can use curl or fiddler to send http
requests.
was (Author: kliew):
Hi [~elserj]
I'm testing the jars compiled from the latest Phoenix source code and Calcite
1.5.0; the issue is still present - we do not get an update row-count.
{noformat}{
"response": "fetch",
"frame": {
"offset": 0,
"done": true,
"rows": [
]
}
}{noformat}
> 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)
