[jira] [Created] (CALCITE-3890) Infer IS NOT NULL predicate from join

2020-03-31 Thread Chunwei Lei (Jira)
Chunwei Lei created CALCITE-3890: Summary: Infer IS NOT NULL predicate from join Key: CALCITE-3890 URL: https://issues.apache.org/jira/browse/CALCITE-3890 Project: Calcite Issue Type:

Re: Split Join condition with CAST which only widening nullability

2020-03-31 Thread Zoltan Haindrich
> we should consider that 'b IS TRUE' and 'b IS NOT FALSE' I think we already do that... UnknownAs.FALSE essentially means that the expression is enclosed in an "IS TRUE" - since we run filter/join condition simplification in UAF mode; its allowed to remove "_ IS TRUE" At the same time I

Re: Split Join condition with CAST which only widening nullability

2020-03-31 Thread Julian Hyde
Thanks Zoltan. I added a test to RelBuilderTest and I can confirm that '_ IS TRUE' is stripped. And I agree that we cannot safely strip '_ IS NOT FALSE'. On Tue, Mar 31, 2020 at 5:11 AM Zoltan Haindrich wrote: > > > we should consider that 'b IS TRUE' and 'b IS NOT FALSE' > > I think we already

[jira] [Created] (CALCITE-3889) Add apply(Mappings.Mapping) to RelTrait and RelTraitSet

2020-03-31 Thread Haisheng Yuan (Jira)
Haisheng Yuan created CALCITE-3889: -- Summary: Add apply(Mappings.Mapping) to RelTrait and RelTraitSet Key: CALCITE-3889 URL: https://issues.apache.org/jira/browse/CALCITE-3889 Project: Calcite