Volodymyr Vysotskyi created DRILL-7192:
------------------------------------------
Summary: Drill limits rows when autoLimit is disabled
Key: DRILL-7192
URL: https://issues.apache.org/jira/browse/DRILL-7192
Project: Apache Drill
Issue Type: Bug
Affects Versions: 1.16.0
Reporter: Volodymyr Vysotskyi
Fix For: Future
In DRILL-7048 was implemented autoLimit for JDBC and rest clients.
*Steps to reproduce the issue:*
1. Check that autoLimit was disabled, if not, disable it and restart Drill.
2. Submit any query, and verify that rows count is correct, for example,
{code:sql}
SELECT * FROM cp.`employee.json`;
{code}
returns 1,155 rows
3. Enable autoLimit for sqlLine sqlLine client:
{code:sql}
!set rowLimit 10
{code}
4. Submit the same query and verify that the result has 10 rows.
5. Disable autoLimit:
{code:sql}
!set rowLimit 0
{code}
6. Submit the same query, but for this time, *it returns 10 rows instead of
1,155*.
Correct rows count is returned only after creating a new connection.
The same issue is also observed for SQuirreL SQL client, but for example, for
Postgres, it works correctly.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
