[ https://issues.apache.org/jira/browse/DRILL-7192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Arina Ielchiieva reassigned DRILL-7192: --------------------------------------- Assignee: Vova Vysotskyi (was: Kunal Khatua) > 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: Vova Vysotskyi > Assignee: Vova Vysotskyi > Priority: Major > Fix For: 1.17.0 > > > 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 (v8.3.4#803005)