[
https://issues.apache.org/jira/browse/CALCITE-7089?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18003954#comment-18003954
]
Yu Xu commented on CALCITE-7089:
--------------------------------
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)
