[
https://issues.apache.org/jira/browse/CALCITE-7089?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18012260#comment-18012260
]
Zhen Chen commented on CALCITE-7089:
------------------------------------
Fixed in
https://github.com/apache/calcite/commit/0febc55f1773dd4221f501e97caa7ef8a6211045
Thanks for contribution [~yuhanliu]
Thanks for review [~cancai]
> 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
> Assignee: YuhanLiu
> Priority: Minor
> Labels: pull-request-available
>
> 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)
