drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-5051) DRILL-5051: Fix incorrect result returned in nest query with offset specified
Date Tue, 20 Dec 2016 02:47:58 GMT

    [ https://issues.apache.org/jira/browse/DRILL-5051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15763031#comment-15763031
] 

ASF GitHub Bot commented on DRILL-5051:
---------------------------------------

Github user zbdzzg commented on a diff in the pull request:

    https://github.com/apache/drill/pull/662#discussion_r93163164
  
    --- 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 --
    
    Thank you for the catch!


> 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)

Mime
View raw message