Hi,
I have a query like
SELECT * FROM MYTABLE WHERE v = 1 and v is null

I am expecting Calcite to simplify it to
SELECT * FROM MYTABLE WHERE v = 1

but this does not happen.

Is any rule I should enable in order to make it happen ?

This is the configuration of my Volcano planner:

  final FrameworkConfig config = Frameworks.newConfigBuilder()
                .parserConfig(....)
                .defaultSchema(...)
                .traitDefs(....)
                .programs(Programs.ofRules(Programs.RULE_SET))
                .build();

Best regards
Enrico

Reply via email to