Re: Why we cannot get all predicates for outer join query?

2023-01-16 Thread 徐仁和
Hi jiajun Here is a jira about this problem. JIRA: https://issues.apache.org/jira/browse/CALCITE-5109 I've been too busy for a while, and I will continue to improve this jira in the next month. Best, XuRenhe Benchao Li 于2023年1月17日周二 10:21写道: > The comment for `AllPredicates`[1] has explained

Re: Why we cannot get all predicates for outer join query?

2023-01-16 Thread Benchao Li
The comment for `AllPredicates`[1] has explained the difference. Can this answer your question? The difference with respect to BuiltInMetadata.Predicates provider is that > this provider tries to extract ALL predicates even if they are not applied > on the output expressions of the relational

[jira] [Created] (CALCITE-5483) ProjectAggregateMergeRule throws exception if literal is non-numeric

2023-01-16 Thread Bruce Irschick (Jira)
Bruce Irschick created CALCITE-5483: --- Summary: ProjectAggregateMergeRule throws exception if literal is non-numeric Key: CALCITE-5483 URL: https://issues.apache.org/jira/browse/CALCITE-5483

[DISCUSS] CAST DOUBLE to BOOLEAN

2023-01-16 Thread Николай Ижиков
Hello. Right now, Calcite allows to cast FLOAT, DOUBLE expressions to BOOLEAN. But, results is always `false`. Cast works as `java.lang.Boolean.parseBoolean` call and always return false for anything except «true» string(`Primitive#parse`). Simple additional test for `InterpreterTest` shows

Re: [DISCUSS] Towards Calcite-Avatica 1.23.0

2023-01-16 Thread Stamatis Zampetakis
+1 Thanks for the initiative Julian! On Sun, Jan 15, 2023 at 9:46 PM Francis Chuang wrote: > +1 Great idea, Julian! Avatica is way overdue for a release. > > On 16/01/2023 7:08 am, Julian Hyde wrote: > > I'm thinking of making a quick release of Avatica, so that Calcite > > 1.33 (which is

Re: [VOTE] Release Apache Calcite Avatica 1.23.0 (release candidate 0)

2023-01-16 Thread Stamatis Zampetakis
Ubuntu 20.04.4 LTS, jdk1.8.0_261, Gradle wrapper, Gradle 7.4.2 * Checked signatures and checksums OK * Went over release note OK * Checked README, NOTICE, and LICENSE files OK * Built from git tag and run tests (./gradlew test) OK * Built from release sources and run tests (gradle test) OK

[jira] [Created] (CALCITE-5482) JVM error when running tests via docker-compose in Avatica

2023-01-16 Thread Stamatis Zampetakis (Jira)
Stamatis Zampetakis created CALCITE-5482: Summary: JVM error when running tests via docker-compose in Avatica Key: CALCITE-5482 URL: https://issues.apache.org/jira/browse/CALCITE-5482 Project:

Re: Why we cannot get all predicates for outer join query?

2023-01-16 Thread Jiajun Xie
Hi Benchao, Thanks very much for your email. I understand `RelMetadataQuery#getAllPredicates` cannot get all predicates because some optimized cases cannot push/pull predicates. But I think the function name and code comment[1] are misleading, *getAllPredicates* cannot get all predicates. And