liuyuhanalex opened a new pull request, #4464: URL: https://github.com/apache/calcite/pull/4464
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 is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
