[
https://issues.apache.org/jira/browse/DRILL-5051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15762688#comment-15762688
]
ASF GitHub Bot commented on DRILL-5051:
---------------------------------------
Github user jinfengni commented on a diff in the pull request:
https://github.com/apache/drill/pull/662#discussion_r93146424
--- Diff: exec/java-exec/src/test/java/org/apache/drill/TestBugFixes.java
---
@@ -221,4 +221,14 @@ public void testDRILL4884() throws Exception {
.baselineRecords(baseline)
.go();
}
+
+ @Test
+ public void testDRILL5051() throws Exception {
+ testBuilder()
+ .sqlQuery("select count(1) as cnt from (select l_orderkey from
(select id from cp.`tpch/lineitem.parquet` limit 2) limit 1 offset 1)")
--- End diff --
This query seems to hit SQL validation error " Column 'l_orderkey' not
found in any table".
I'm going to change column "id" to "l_orderkey" in the inner subquery, in
order to skip this validation error.
> DRILL-5051: Fix incorrect result returned in nest query with offset 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)
