> It's my first time to send an email to a public open source project Welcome!
It seems likely that you have found a valid issue. However, two of your three images were stripped from the email. I suggest that you create a JIRA case and attach the images to that case. Go to https://issues.apache.org/jira/browse/CALCITE and press 'CREATE'. Julian On Fri, Sep 25, 2020 at 11:44 AM 肖明星 <[email protected]> wrote: > > 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): > > > 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) > > > > Does anyone help me to figure it out? > > Thanks > Xiao Mingxing >
