[
https://issues.apache.org/jira/browse/DRILL-5051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15683464#comment-15683464
]
ASF GitHub Bot commented on DRILL-5051:
---------------------------------------
GitHub user zbdzzg opened a pull request:
https://github.com/apache/drill/pull/662
DRILL-5051: Fix incorrect result returned in nest query with offset s…
…pecified
1. Fix this problem.
2. Merge two limit methods, most of code is the same.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/zbdzzg/drill 5051
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/drill/pull/662.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #662
----
commit 102ad402250c0d74c9ab7a724aef3262b92069d8
Author: hongze.zhz <[email protected]>
Date: 2016-11-18T12:11:38Z
DRILL-5051: Fix incorrect result returned in nest query with offset
specified
----
> Returning incorrect number of rows while querying using both nested select
> and offset
> -------------------------------------------------------------------------------------
>
> 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: Sudheesh Katkam
> 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)
