Re: Trivial query simplification

[Feng Zhu]

Hi, Enrico,
I'm a little confused about your expectations. Could you clarify it?
Moreover, is it right for the below simplification (do you mean v is not
null)?
(v=1 and v is null) -> v=1
(do you mean v is not null?)

Best regards

Enrico Olivelli <eolive...@gmail.com> 于2019年9月24日周二 下午5:41写道：

> 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
>