Dear Devs in Calcite. It's my first time to send an email to a public open source project, if the below question description is not clear. feel free to contact me.
Question: The HepPlanner optimizes with the rule *CoreRules.FILTER_INTO_JOIN* not working. The SQL used for test: select u.id as user_id, u.name as user_name, o.id as order_id from users u INNER JOIN orders o ON u.id=o.user_id WHERE u.id>50 The converted RelNode result (version: 1.25.0): [image: image.png] The filter wasn't pushed past the LogicalJoin operator. But I have tried the Calcite 1.19.0. seems to work correctly. (Result when using calcite 1.19.0) [image: image.png] Does anyone help me to figure it out? Thanks Xiao Mingxing
