[
https://issues.apache.org/jira/browse/CALCITE-7089?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18003954#comment-18003954
]
Yu Xu edited comment on CALCITE-7089 at 7/9/25 2:17 AM:
--------------------------------------------------------
IMO， the rule is necessary，wait for others' suggestion. Two ways to handle
these condition:
# support this rule to adapter lower version dialect or other possible
dialects；
# error out for with detail message for dialect.
was (Author: JIRAUSER307770):
IMO， the rule is necessary，wait for others' suggestion.
> Implement a rule for converting a RIGHT JOIN to a LEFT JOIN
> -----------------------------------------------------------
>
> Key: CALCITE-7089
> URL: https://issues.apache.org/jira/browse/CALCITE-7089
> Project: Calcite
> Issue Type: Improvement
> Affects Versions: 1.40.0
> Reporter: Zhen Chen
> Priority: Minor
>
> This is because SQLite versions before 3.39.0 do not support RIGHT/FULL JOIN.
> Currently, the rule for converting FULL JOIN to LEFT + RIGHT JOIN has been
> implemented. There is a lack of a rule for converting RIGHT JOIN to LEFT JOIN
> (which may also be used in other scenarios). This rule can be implemented
> with the help of the static method in JoinCommuteRule. The reason for not
> using JoinCommuteRule directly is that it supports both LEFT JOIN to RIGHT
> JOIN and RIGHT JOIN to LEFTJOIN, and there is no way to control only RIGHT
> JOIN to LEFT JOIN.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
