[ https://issues.apache.org/jira/browse/DRILL-5051?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hongze Zhang updated DRILL-5051: -------------------------------- Summary: DRILL-5051: Fix incorrect computation of 'fetch' in LimitRecordBatch when 'offset' is specified (was: Returning incorrect number of rows while querying using both nested select and offset) > DRILL-5051: Fix incorrect computation of 'fetch' in LimitRecordBatch when > 'offset' is specified > ----------------------------------------------------------------------------------------------- > > Key: DRILL-5051 > URL: https://issues.apache.org/jira/browse/DRILL-5051 > Project: Apache Drill > Issue Type: Bug > Components: Query Planning & Optimization > Affects Versions: 1.8.0 > Environment: Fedora 24 / OpenJDK 8 > Reporter: Hongze Zhang > Assignee: Hongze Zhang > Labels: ready-to-commit > Fix For: Future > > > My SQl: > select count(1) from (select id from (select id from > cp.`tpch/lineitem.parquet` LIMIT 2) limit 1 offset 1) > This SQL returns nothing. > Something goes wrong in LimitRecordBatch.java, and the reason is different > with [DRILL-4884|https://issues.apache.org/jira/browse/DRILL-4884?filter=-2] -- This message was sent by Atlassian JIRA (v6.3.4#6332)