You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "YuhanLiu (Jira)" <ji...@apache.org> on 2025/07/10 01:09:00 UTC
[jira] [Assigned] (CALCITE-7089) Implement a rule for converting a RIGHT JOIN to a LEFT JOIN
[ https://issues.apache.org/jira/browse/CALCITE-7089?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
YuhanLiu reassigned CALCITE-7089:
---------------------------------
Assignee: YuhanLiu
> 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
>
> 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)