Zhen Chen created CALCITE-7089:
----------------------------------
Summary: 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
Reporter: Zhen Chen
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)
