Francis Chuang created CALCITE-1181:
---------------------------------------
Summary: FetchResponse always return no rows
Key: CALCITE-1181
URL: https://issues.apache.org/jira/browse/CALCITE-1181
Project: Calcite
Issue Type: Bug
Components: avatica
Affects Versions: avatica-1.7.1
Environment: HBase 1.1 and Phoenix 4.7.0
Reporter: Francis Chuang
Assignee: Julian Hyde
Assuming I have a table called my_table which is created and seeded like so:
CREATE TABLE my_table (k BIGINT PRIMARY KEY, v VARCHAR) TRANSACTIONAL=true
UPSERT INTO my_table VALUES (1,'A')
UPSERT INTO my_table VALUES (2,'B')
I have 2 rows in the table. If I query the table using SELECT * FROM my_table,
and request a maxRowCount of 1, using FetchRequest to request further rows
always returns 0 rows.
For ease of reproduction, I have included CURL commands (avatica will need to
have serialization set to JSON):
curl localhost:8765 -XPOST --data '{"request": "openConnection","connectionId":
"my-conn"}'
curl localhost:8765 -XPOST --data '{"request":
"createStatement","connectionId": "my-conn"}'
curl localhost:8765 -XPOST --data '{"request":
"prepareAndExecute","connectionId": "my-conn","statementId": 12345,"sql":
"SELECT * FROM my_table","maxRowCount": 1}' # update the statementId
curl localhost:8765 -XPOST --data '{"request": "fetch","connectionId":
"my-conn","statementId": 12345,"offset": 0,"fetchMaxRowCount": 1}' # update the
statementId
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
