[DISCUSS] Assigning reviewers

2022-02-03 Thread Julian Hyde
I make many contributions to this project, in the form of code, answering questions, leading design discussions, and clarifying bugs and feature requests. I review more changes than any other project member. My reward is that I am pestered, daily, with people pleading for me to review their

Re: MaterializedViewRule is not applied for queries on aggregate views that truncate timestamp

2022-02-03 Thread Julian Hyde
These kinds of roll ups are very common. They have simple mathematical properties. There is a simplifying abstraction to be found here. Please find it and use it. Julian > On Feb 2, 2022, at 7:47 PM, Thomas D'Silva wrote: > > Hi Stamatis, > > Thanks for your response. Your suggestion of

Re: Simplification of "x != x"

2022-02-03 Thread Julian Hyde
Using SQL syntax (which is less confusing, since we are talking about shortcut evaluation) UNKNOWN AND (x IS NULL) is equivalent to (x IS NULL) AND UNKNOWN Just write out the truth table. If you get different results, are you perhaps incorrectly using some kind of shortcut evaluation?

Simplification of "x != x"

2022-02-03 Thread Abhishek Agarwal
Hello, While debugging a druid query that involves an operation such as "A <> A", I found out that in RexSimplify, such an expression is converted to "null && isnull(A)". That seems wrong since it will always evaluate to null even if A is not null in some row. The right conversion should be

Build failed in Jenkins: Calcite » Calcite-snapshots #61

2022-02-03 Thread Apache Jenkins Server
See Changes: [Stamatis Zampetakis] [CALCITE-4702] Error when executing query with GROUP BY constant via JDBC adapter -- [...truncated 427.48 KB...] >