[jira] [Closed] (DRILL-8137) Prevent reading union inputs after cancellation request

["James Turton (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-8137?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

James Turton closed DRILL-8137.
-------------------------------

> Prevent reading union inputs after cancellation request
> -------------------------------------------------------
>
>                 Key: DRILL-8137
>                 URL: https://issues.apache.org/jira/browse/DRILL-8137
>             Project: Apache Drill
>          Issue Type: Bug
>    Affects Versions: 1.19.0
>            Reporter: Vova Vysotskyi
>            Assignee: Vova Vysotskyi
>            Priority: Critical
>             Fix For: 1.20.0
>
>
> When running a union all query that has right side operators like join or aggregate, and limit on top of the union, such query will fail for the case when right input shouldn't read because the left one had required number of records for limit.
> Example of such failing query (thanks to [~dzamo] for helping to minimize it):
> {code:sql}
> WITH foo AS
>   (SELECT 1 AS a
>    FROM cp.`/tpch/nation.parquet`
>    UNION ALL SELECT 1 AS a
>    FROM cp.`/tpch/nation.parquet`
>    WHERE n_nationkey >
>        (SELECT 1) )
> SELECT *
> FROM foo
> LIMIT 1
> {code}



--
This message was sent by Atlassian Jira
(v8.20.7#820007)