[DRILL-5051] DRILL-5051: Fix incorrect result returned in nest query with offset specified

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.8.0
• Fix Version/s: 1.10.0
• Component/s: Query Planning & Optimization
• Labels: ready-to-commit

Environment

Fedora 24 / OpenJDK 8

• Flags: Patch
• Assignee: Account Not Used
• Reporter: Account Not Used
• Reviewer: Khurram Faraaz
• Created: 18/Nov/16 09:56
• Updated: 30/Mar/17 11:53
• Resolved: 20/Dec/16 17:03

Description

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

Issue Links

• links to: GitHub Pull Request #662