[
https://issues.apache.org/jira/browse/DRILL-5051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15676604#comment-15676604
]
ASF GitHub Bot commented on DRILL-5051:
---------------------------------------
GitHub user zbdzzg opened a pull request:
https://github.com/apache/drill/pull/658
DRILL-5051: Fix incorrect result returned in nest query with offset
specified
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 master
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/drill/pull/658.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 #658
----
commit 982b8c2bfa742feffb551ba5bfb66ba01b38d839
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
> 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)
