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)