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)