Hi Wail, I think that's what the comment implies (I could not produce an expression where it used in a sub-plan and not visible to upper operators?). If you want to make it happen, a workaround might be introducing a project operator within the subplan of the subplan operator? Actually, if a variable is not used, isn't project operator supposed to remove them automatically by IntroduceProjectsRule?
Best, Taewoo On Sat, Oct 19, 2019 at 10:05 AM Wail Alkowaileet <[email protected]> wrote: > Hi Dev, > > I'm not sure about the commented code in [1]. I could not produce an > expression where it used in a sub-plan and not visible to upper operators? > Also, all SQL++ runtime integration tests seem to work just fine. > > > [1] ExtractCommonExpressionsRule.java#L192 > < > https://github.com/apache/asterixdb/blob/f2c18aa9646238ab2487ce3a964edfe3e61dd6e1/hyracks-fullstack/algebricks/algebricks-rewriter/src/main/java/org/apache/hyracks/algebricks/rewriter/rules/ExtractCommonExpressionsRule.java#L192 > > > > -- > > *Regards,* > Wail Alkowaileet >
