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

2025-03-11 Thread Xiong Duan
+1 Xiong Duan (committer) Thanks Stamatis for preparing the RC, this is what I have checked: - verified gpg signature: OK - verified package checksum: OK - verified gradle build from sources: OK - building commit and running tests: OK - checked release notes: I left some small suggestions in the

Re: [ANNOUNCE] Istvan Toth joins Calcite PMC

2025-03-11 Thread Stamatis Zampetakis
Very well deserved! Welcome Istvan! Best, Stamatis On Thu, Mar 6, 2025 at 8:33 AM suibianwanwan wrote: > > Congratulations! > > > 2025年3月6日 15:05,Sergey Nuyanzin 写道: > > > > Congratulations Istvan! > > > > On Thu, Mar 6, 2025, 02:35 Xiong Duan wrote: > > > >> Istvan, > >> Congratulations. >

Re: Questions about RelMdColumnUniqueness

2025-03-11 Thread Ian Bertolacci
Filed https://issues.apache.org/jira/browse/CALCITE-6882 Included a few demonstrations of the weirdness. I still think that *both* predicate pullup/refinement and analysis of the join are wrong, since any unique columns will cause a keyset of non-unique columns to become unique as a whole when th

[VOTE] Release Apache Calcite 1.39.0 (release candidate 0)

2025-03-11 Thread Stamatis Zampetakis
Hi all, I have created a build for Apache Calcite 1.39.0, release candidate 0. Thanks to everyone who has contributed to this release. You can read the release notes here: https://github.com/apache/calcite/blob/calcite-1.39.0-rc0/site/_docs/history.md The commit to be voted upon: https://gitbox

Re: RelFieldTrimmer not optimally trimming after filters under joins?

2025-03-11 Thread Julian Hyde
Probably this should be done by RelFieldTrimmer, but it should be a mode (boolean flag). If it started adding a bunch of new Project operators it might break existing clients. Maybe even several modes. Some people might not to add Project under an Aggregate (because Aggregate implicitly project

Re: Questions Regarding Type Coercion and CAST Transformations in SqlValidator and RexBuilder

2025-03-11 Thread Alessandro Solimando
The SQL standard hints into implicit casts into several places but it is not 100% explicit about it (no pun intended). For instance, "4.11 Data conversions" in Part 2 (2011 edition) states: > Implicit type conversion can occur in expressions, fetch operations, > single row select operations, inse

Re: Questions Regarding Type Coercion and CAST Transformations in SqlValidator and RexBuilder

2025-03-11 Thread Alessandro Solimando
For the custom equality I'd expect a few concrete implementations out of all the cartesian product of all data types, that's why I was suggesting to make the typing explicit with some custom functions with the right overloaded signatures. What I wanted to say is that I agree that we might be overd

Re: [DISCUSS] Towards Calcite 1.39.0

2025-03-11 Thread Stamatis Zampetakis
Hi everyone, I am starting the release process. Please hold off your commits to main. Best, Stamatis On Wed, Mar 5, 2025 at 1:05 AM Xiong Duan wrote: > > +1 for the first RC on March 10, 2025. > > Julian Hyde 于2025年3月5日周三 03:40写道: > > > > +1 for March 10th RC > > > > There are only 4 open iss

Re: Questions Regarding Type Coercion and CAST Transformations in SqlValidator and RexBuilder

2025-03-11 Thread Mihai Budiu
If you have 20 different base types and you allow any pairwise comparisons, then you have to consider 400 functions just for equality, which decide what happens for every pair of types. Since Calcite supports parameterized types (e.g., TIME(3)) and generic types (like arrays or maps), the number

[jira] [Created] (CALCITE-6881) Druid Adapter can not handle for strlen call

2025-03-11 Thread Yu Xu (Jira)
Yu Xu created CALCITE-6881: -- Summary: Druid Adapter can not handle for strlen call Key: CALCITE-6881 URL: https://issues.apache.org/jira/browse/CALCITE-6881 Project: Calcite Issue Type: Bug

Apache Calcite on .NET

2025-03-11 Thread Jerome Haltom
Hello folks. I'm the present maintainer of the IKVM project. IKVM is a JVM that runs 'inside' .NET. Translates byte code to MSIL. So, you can run Java code in .NET. For personal reasons (a client), I have been working to get Apache Calcite running inside .NET. I succeeded. And I am now working

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

2025-03-11 Thread Alessandro Solimando
+1 asolimando (committer) Thanks Stamatis for preparing the RC, this is what I have checked: - verified gpg signature: OK [1] - verified package checksum: OK [2] - verified gradle build from sources: OK [3] - building commit and running tests: OK [4] - checked release notes: OK - checked a f

[jira] [Created] (CALCITE-6884) RelToSqlConverter generates invalid MySQL syntax for Correlate operator with multiple tables

2025-03-11 Thread Jie Yang (Jira)
Jie Yang created CALCITE-6884: - Summary: RelToSqlConverter generates invalid MySQL syntax for Correlate operator with multiple tables Key: CALCITE-6884 URL: https://issues.apache.org/jira/browse/CALCITE-6884

[jira] [Created] (CALCITE-6883) Move RelRoot tests to dedicated test class

2025-03-11 Thread Niels Pardon (Jira)
Niels Pardon created CALCITE-6883: - Summary: Move RelRoot tests to dedicated test class Key: CALCITE-6883 URL: https://issues.apache.org/jira/browse/CALCITE-6883 Project: Calcite Issue Type: