Il mar 24 set 2019, 11:50 Feng Zhu <wellfeng...@gmail.com> ha scritto:
> 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?) > Yes, sorry Enrico > > 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 > > >