[
https://issues.apache.org/jira/browse/DRILL-8137?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vova Vysotskyi updated DRILL-8137:
----------------------------------
Description:
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}
> 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
>
> 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.1#820001)
