[
https://issues.apache.org/jira/browse/SPARK-59626?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Luka Zdravic updated SPARK-59626:
---------------------------------
Affects Version/s: 4.4.0
(was: 5.0.0)
> ASOF JOIN parser-stage defects
> ------------------------------
>
> Key: SPARK-59626
> URL: https://issues.apache.org/jira/browse/SPARK-59626
> Project: Spark
> Issue Type: Umbrella
> Components: SQL
> Affects Versions: 4.4.0
> Reporter: Luka Zdravic
> Priority: Minor
>
> ASOF JOIN enforces two grammar rules at parse time in a way that is either
> unclear or unsafe.
> This umbrella tracks two parser-stage issues, one sub-task each:
> 1. An unsupported join type before ASOF (for example RIGHT, FULL, CROSS,
> NATURAL, SEMI, ANTI, LATERAL) fails with a generic PARSE_SYNTAX_ERROR
> instead of an error that names the incompatible join type.
> 2. A missing MATCH_CONDITION is silently ignored when the left table has no
> alias, so ASOF JOIN degrades to a plain INNER JOIN with no error.
>
> Issue 1 is a diagnostics gap: the rejection is correct but the message is
> unhelpful. Issue 2 is a correctness bug: the query runs and returns wrong
> results instead of failing.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
