[
https://issues.apache.org/jira/browse/DRILL-8137?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Turton updated DRILL-8137:
--------------------------------
Fix Version/s: 1.20.0
> 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)
