[jira] [Created] (CALCITE-7124) JdbcAggregateRule should push aggregate functions FILTER clauses to underlying SQL via JDBC adapter

xiong duan created CALCITE-7124: --- Summary: JdbcAggregateRule should push aggregate functions FILTER clauses to underlying SQL via JDBC adapter Key: CALCITE-7124 URL: https://issues.apache.org/jira/browse/CALCITE

[jira] [Created] (CALCITE-7100) Invalid unparse for OVER() in OracleDialect

xiong duan created CALCITE-7100: --- Summary: Invalid unparse for OVER() in OracleDialect Key: CALCITE-7100 URL: https://issues.apache.org/jira/browse/CALCITE-7100 Project: Calcite Issue Type

Re: Draft: board report for 2025 Q2

Hi, Ruben. Thank you for preparing this board report. There is an omission of information regarding the PMC. - Xiong Duan was added to the PMC on 2025-04-02

[jira] [Created] (CALCITE-7076) IN-list that includes NULL converted to Values throws exception when When there is a non-null column being compared with a NULL value

xiong duan created CALCITE-7076: --- Summary: IN-list that includes NULL converted to Values throws exception when When there is a non-null column being compared with a NULL value Key: CALCITE-7076 URL: https

[jira] [Created] (CALCITE-7074) IN-list that includes NULL converted to Values return wrong result

xiong duan created CALCITE-7074: --- Summary: IN-list that includes NULL converted to Values return wrong result Key: CALCITE-7074 URL: https://issues.apache.org/jira/browse/CALCITE-7074 Project: Calcite

[jira] [Created] (CALCITE-7056) Convert RelNode to Sql failed when the RelNode includes quantify operators

xiong duan created CALCITE-7056: --- Summary: Convert RelNode to Sql failed when the RelNode includes quantify operators Key: CALCITE-7056 URL: https://issues.apache.org/jira/browse/CALCITE-7056 Project

[jira] [Created] (CALCITE-7053) In HepPlanner, move down the collectGarbage to topological order for better optimizer performance

xiong duan created CALCITE-7053: --- Summary: In HepPlanner, move down the collectGarbage to topological order for better optimizer performance Key: CALCITE-7053 URL: https://issues.apache.org/jira/browse/CALCITE-7053

[jira] [Created] (CALCITE-7050) Invalid unparse for FULL JOIN in MySQLDialect

xiong duan created CALCITE-7050: --- Summary: Invalid unparse for FULL JOIN in MySQLDialect Key: CALCITE-7050 URL: https://issues.apache.org/jira/browse/CALCITE-7050 Project: Calcite Issue Type

[jira] [Created] (CALCITE-7049) When performing garbage collection, HepPlanner should clear the metadata cache

xiong duan created CALCITE-7049: --- Summary: When performing garbage collection, HepPlanner should clear the metadata cache Key: CALCITE-7049 URL: https://issues.apache.org/jira/browse/CALCITE-7049

[jira] [Created] (CALCITE-7046) 'CASE a WHEN null THEN 1 ELSE b END' should return 1 when a is null

xiong duan created CALCITE-7046: --- Summary: 'CASE a WHEN null THEN 1 ELSE b END' should return 1 when a is null Key: CALCITE-7046 URL: https://issues.apache.org/jira/browse/CALCITE-7046 Projec

[jira] [Created] (CALCITE-7044) Add internal operator NOT NULL to enhance rewrite COALESCE operator

xiong duan created CALCITE-7044: --- Summary: Add internal operator NOT NULL to enhance rewrite COALESCE operator Key: CALCITE-7044 URL: https://issues.apache.org/jira/browse/CALCITE-7044 Project: Calcite

Re: [VOTE] Release Apache Calcite 1.40.0 (release candidate 1)

+1 Xiong Duan (PMC) Thanks Alessandro for preparing the RC, this is what I have checked: - verified gpg signature: OK - verified package checksum: OK - verified gradle build from sources: OK - checked release notes: OK - checked gradlew build: OK Environment: ➜ calcite git:(calcite

Re: Apache Calcite 1.40.0 release

I have merged and resolved 7030. Konstantin Orlov 于2025年5月21日周三 14:04写道： > > Folks, any chance to include > https://issues.apache.org/jira/browse/CALCITE-7009 in the upcoming > release? The patch is really small, we only need to find someone with good > expertise in correlates to take a look. > >

[jira] [Created] (CALCITE-7032) Simplify 'NULL>ALL (ARRAY[1,2,NULL])' to 'NULL'

xiong duan created CALCITE-7032: --- Summary: Simplify 'NULL>ALL (ARRAY[1,2,NULL])' to 'NULL' Key: CALCITE-7032 URL: https://issues.apache.org/jira/browse/CALCITE-7032 Project: Calci

[jira] [Created] (CALCITE-7030) Enhance TopologicalOrderIterator to support BOTTOM_UP

xiong duan created CALCITE-7030: --- Summary: Enhance TopologicalOrderIterator to support BOTTOM_UP Key: CALCITE-7030 URL: https://issues.apache.org/jira/browse/CALCITE-7030 Project: Calcite

Re: [ANNOUNCE] New committer: Zhen Chen

Congratulations! Alessandro Solimando 于2025年5月20日周二 14:24写道： > > Congratulations, very well deserved and welcome aboard! > > Alessandro > > On Tue, May 20, 2025, 02:12 Zhengqiang Duan > wrote: > > > Congratulations! > > > > Best regards, > > Zhengqiang > > > > Mihai Budiu 于2025年5月20日周二 04:32写道：

[jira] [Created] (CALCITE-7025) Validating the Quantify Operator, which doesn’t have compatible types, should throw an exception about the Quantify Operator

xiong duan created CALCITE-7025: --- Summary: Validating the Quantify Operator, which doesn’t have compatible types, should throw an exception about the Quantify Operator Key: CALCITE-7025 URL: https

[jira] [Created] (CALCITE-7021) Support parse 'CAST('1' AS INTERVAL)'

xiong duan created CALCITE-7021: --- Summary: Support parse 'CAST('1' AS INTERVAL)' Key: CALCITE-7021 URL: https://issues.apache.org/jira/browse/CALCITE-7021 Project: Calcite

[jira] [Created] (CALCITE-7019) Simplify 'NULL in (20, 10)' to 'NULL'

xiong duan created CALCITE-7019: --- Summary: Simplify 'NULL in (20, 10)' to 'NULL' Key: CALCITE-7019 URL: https://issues.apache.org/jira/browse/CALCITE-7019 Project: Calcite

Re: [ANNOUNCE] Alessandro Solimando joins Calcite PMC

Alessandro, Congratulations! Thank you for always being very generous and clear in answering all the questions in the PR, which has greatly improved our PR! Best, Xiong Duan Stamatis Zampetakis 于2025年5月2日周五 19:25写道： > > Congratulations Alessandro, very well deserved! > > Many th

[jira] [Created] (CALCITE-6994) Enhance RexBuilder#makeIn to create SEARCH for MULTISET literals

xiong duan created CALCITE-6994: --- Summary: Enhance RexBuilder#makeIn to create SEARCH for MULTISET literals Key: CALCITE-6994 URL: https://issues.apache.org/jira/browse/CALCITE-6994 Project: Calcite

[jira] [Created] (CALCITE-6993) Enhance the digest of Sarg to show whether the collection type is nullable

xiong duan created CALCITE-6993: --- Summary: Enhance the digest of Sarg to show whether the collection type is nullable Key: CALCITE-6993 URL: https://issues.apache.org/jira/browse/CALCITE-6993 Project

[jira] [Created] (CALCITE-6981) The query failed when attempting to convert DECIMAL ARRAY to INTEGER ARRAY

xiong duan created CALCITE-6981: --- Summary: The query failed when attempting to convert DECIMAL ARRAY to INTEGER ARRAY Key: CALCITE-6981 URL: https://issues.apache.org/jira/browse/CALCITE-6981 Project

[jira] [Created] (CALCITE-6957) Unit tests should fail when there are redundant methods in RelOptRulesTest.xml

xiong duan created CALCITE-6957: --- Summary: Unit tests should fail when there are redundant methods in RelOptRulesTest.xml Key: CALCITE-6957 URL: https://issues.apache.org/jira/browse/CALCITE-6957

[jira] [Created] (CALCITE-6952) JDBC adapter for StarRocks generates incorrect SQL for REAL datatype

xiong duan created CALCITE-6952: --- Summary: JDBC adapter for StarRocks generates incorrect SQL for REAL datatype Key: CALCITE-6952 URL: https://issues.apache.org/jira/browse/CALCITE-6952 Project

[jira] [Created] (CALCITE-6951) Add STRING_TO_ARRAY function(enabled in PostgreSQL Library)

xiong duan created CALCITE-6951: --- Summary: Add STRING_TO_ARRAY function(enabled in PostgreSQL Library) Key: CALCITE-6951 URL: https://issues.apache.org/jira/browse/CALCITE-6951 Project: Calcite

[jira] [Created] (CALCITE-6950) Use ANY operator to check if an element exists in an array throws exception

xiong duan created CALCITE-6950: --- Summary: Use ANY operator to check if an element exists in an array throws exception Key: CALCITE-6950 URL: https://issues.apache.org/jira/browse/CALCITE-6950 Project

[jira] [Created] (CALCITE-6945) Use LITERAL_AGG to simplify SubQueryRemoveRule by avoiding the extra Project

xiong duan created CALCITE-6945: --- Summary: Use LITERAL_AGG to simplify SubQueryRemoveRule by avoiding the extra Project Key: CALCITE-6945 URL: https://issues.apache.org/jira/browse/CALCITE-6945

[jira] [Created] (CALCITE-6935) JdbcJoinRule should support SEARCH in JdbcJoin condition

xiong duan created CALCITE-6935: --- Summary: JdbcJoinRule should support SEARCH in JdbcJoin condition Key: CALCITE-6935 URL: https://issues.apache.org/jira/browse/CALCITE-6935 Project: Calcite

[jira] [Created] (CALCITE-6924) FilterIntoJoinRule make JdbcJoin contains expressions that it does not support

xiong duan created CALCITE-6924: --- Summary: FilterIntoJoinRule make JdbcJoin contains expressions that it does not support Key: CALCITE-6924 URL: https://issues.apache.org/jira/browse/CALCITE-6924

[jira] [Created] (CALCITE-6901) SINGLE_VALUE rewrite to wrong sql in MySQL dialect

xiong duan created CALCITE-6901: --- Summary: SINGLE_VALUE rewrite to wrong sql in MySQL dialect Key: CALCITE-6901 URL: https://issues.apache.org/jira/browse/CALCITE-6901 Project: Calcite Issue

Re: Draft: board report for 2025 Q1

+1 LGTM Alessandro Solimando 于2025年3月18日周二 17:30写道： > > LGTM too, thanks Ruben! > > On Tue, 18 Mar 2025 at 09:53, Francis Chuang > wrote: > > > +1 LGTM! > > > > On 18/03/2025 7:12 pm, Stamatis Zampetakis wrote: > > > Looks good, thanks for preparing this Ruben! > > > > > > On Tue, Mar 18, 2025 a

[jira] [Created] (CALCITE-6899) Mismatch of Trait information results in a missing conversion exception

xiong duan created CALCITE-6899: --- Summary: Mismatch of Trait information results in a missing conversion exception Key: CALCITE-6899 URL: https://issues.apache.org/jira/browse/CALCITE-6899 Project

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

+1 Xiong Duan (Committer) Thanks Stamatis for preparing the RC1, 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: OK - Smoke-test sqlline with

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

+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

[jira] [Created] (CALCITE-6874) FilterCalcMergeRule/ProjectCalcMergeRule should not merge a Filter/Project to Calc when it contains Subquery

xiong duan created CALCITE-6874: --- Summary: FilterCalcMergeRule/ProjectCalcMergeRule should not merge a Filter/Project to Calc when it contains Subquery Key: CALCITE-6874 URL: https://issues.apache.org/jira/browse

[jira] [Created] (CALCITE-6875) EnumerableFilterRule/EnumerableProjectRule should not convert a Logical Filter/Project to Enumerable Filter/Project when it contains Subquery

xiong duan created CALCITE-6875: --- Summary: EnumerableFilterRule/EnumerableProjectRule should not convert a Logical Filter/Project to Enumerable Filter/Project when it contains Subquery Key: CALCITE-6875 URL: https

Re: [ANNOUNCE] Istvan Toth joins Calcite PMC

Istvan, Congratulations. Francis Chuang 于2025年3月6日周四 05:03写道： > > I am pleased to announce that Istvan has accepted an invitation to > join the Calcite PMC. Istvan has been a consistent and helpful figure > in the Calcite community for which we are very grateful. We look > forward to the conti

[jira] [Created] (CALCITE-6873) The FilterProjectTransposeRule should not push the Filter past the Project when the Filter contains a Subquery with correlation

xiong duan created CALCITE-6873: --- Summary: The FilterProjectTransposeRule should not push the Filter past the Project when the Filter contains a Subquery with correlation Key: CALCITE-6873 URL: https

Re: [DISCUSS] Towards Calcite 1.39.0

+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 issues tagged 1.39 [ > https://issues.apache.org/jira/issues/?jql=project%20%3D%20CALCITE%20AND%20fixVersion%20%3D%201.39.0%20%20AND%20%20%20statusCategory%20%20!%3D%20Don

[jira] [Created] (CALCITE-6870) The FilterToCalcRule/ProjectToCalcRule should not convert a Filter/Project to Calc when it contains Subquery

xiong duan created CALCITE-6870: --- Summary: The FilterToCalcRule/ProjectToCalcRule should not convert a Filter/Project to Calc when it contains Subquery Key: CALCITE-6870 URL: https://issues.apache.org/jira/browse

Re: SQL Validation Issue - Need help

Hi Dipti, It seems to be caused by the mixed usage of data types. There is a conflict between JavaType and SqlType. You can try to check whether there is any problem with the mapping of SQL Server's metadata types to Calcite's types. I recommend uniformly using Sqltype. Yu Xu 于2025年2月27日周四 16:

[jira] [Created] (CALCITE-6866) PostgreSQLDialect support to unparse LISTAGG aggregate function

xiong duan created CALCITE-6866: --- Summary: PostgreSQLDialect support to unparse LISTAGG aggregate function Key: CALCITE-6866 URL: https://issues.apache.org/jira/browse/CALCITE-6866 Project: Calcite

Re: [ANNOUNCE] New committer: Fanyuan Qiu

Congratulations! Francis Chuang 于2025年2月27日周四 04:41写道： > > Congratulations! > > On 27/02/2025 7:06 am, Hugh Pearse wrote: > > Congratulations Fanyuan 🎉🥳 > > > > On Wed, 26 Feb 2025, 19:41 Tanner Clary, > > wrote: > > > >> Congrats! > >> > >> On Wed, Feb 26, 2025 at 11:40 AM Stamatis Zampetakis

Re: [DISCUSS] Apache Calcite Meetup February 2025

Thank you for doing this! Hugh Pearse 于2025年2月27日周四 03:32写道： > > Thank you so much 😊 > > On Wed, 26 Feb 2025, 19:11 Stamatis Zampetakis, wrote: > > > Hey everyone, > > > > The recording from the Meetup is now available online at > > https://youtu.be/PHm5vZ1A43I > > > > Best, > > Stamatis > > > >

[jira] [Created] (CALCITE-6849) Support specific default type systems for differnent DatabaseProduct

xiong duan created CALCITE-6849: --- Summary: Support specific default type systems for differnent DatabaseProduct Key: CALCITE-6849 URL: https://issues.apache.org/jira/browse/CALCITE-6849 Project

[jira] [Created] (CALCITE-6839) The SUM function sometimes throws overflow exceptions due to incorrect return types

xiong duan created CALCITE-6839: --- Summary: The SUM function sometimes throws overflow exceptions due to incorrect return types Key: CALCITE-6839 URL: https://issues.apache.org/jira/browse/CALCITE-6839

Re: Fragmentation of dialect tests

Julian, Thank you for doing these. After merging your first PR, I will see what I can do. Julian Hyde 于2025年2月15日周六 04:20写道： > > Calcite committers, > > We have too many dialect tests (RelToSqlConverterTest alone is 10,000 > lines long) and we have too few (for many functions and operators, we

[jira] [Created] (CALCITE-6838) ReloSqlConverter should generate double parentheses when the input to Unnest is a query statement

xiong duan created CALCITE-6838: --- Summary: ReloSqlConverter should generate double parentheses when the input to Unnest is a query statement Key: CALCITE-6838 URL: https://issues.apache.org/jira/browse/CALCITE-6838

[jira] [Created] (CALCITE-6836) Add Rule to convert INTERSECT to EXISTS

xiong duan created CALCITE-6836: --- Summary: Add Rule to convert INTERSECT to EXISTS Key: CALCITE-6836 URL: https://issues.apache.org/jira/browse/CALCITE-6836 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-6835) Invalid unparse for IS TRUE,IS FALSE,IS NOT TRUE and IS NOT FALSE in StarRocksDialect

xiong duan created CALCITE-6835: --- Summary: Invalid unparse for IS TRUE,IS FALSE,IS NOT TRUE and IS NOT FALSE in StarRocksDialect Key: CALCITE-6835 URL: https://issues.apache.org/jira/browse/CALCITE-6835

Re: [ANNOUNCE] New committer: Cancai Cai

Congratulations Cancai ! Zhe Hu 于2025年1月21日周二 08:00写道： > > Congratulations and welcome aboard, Cancai ! > > > Best > ZheHu > > > Replied Message > | From | Bertil Chapuis | > | Date | 01/21/2025 04:56 | > | To | | > | Subject | Re: [ANNOUNCE] New committer: Cancai Cai | > Congratulatio

[jira] [Created] (CALCITE-6785) RelToSqlConverter generate wrong sql when UNNEST has a correlate variable

xiong duan created CALCITE-6785: --- Summary: RelToSqlConverter generate wrong sql when UNNEST has a correlate variable Key: CALCITE-6785 URL: https://issues.apache.org/jira/browse/CALCITE-6785 Project

[jira] [Created] (CALCITE-6757) Elasticsearch adapter returns wrong result when aggregating sub-query with aggregation

xiong duan created CALCITE-6757: --- Summary: Elasticsearch adapter returns wrong result when aggregating sub-query with aggregation Key: CALCITE-6757 URL: https://issues.apache.org/jira/browse/CALCITE-6757

[jira] [Created] (CALCITE-6756) Preserving CAST of STRING operand in binary comparison for PostgreSQL

xiong duan created CALCITE-6756: --- Summary: Preserving CAST of STRING operand in binary comparison for PostgreSQL Key: CALCITE-6756 URL: https://issues.apache.org/jira/browse/CALCITE-6756 Project

Re: String comparison with DEFAULT conformance

Hi Zhe Hu, I remember there was a comparison-type configuration between char and varchar. Can you check if 'shouldConvertRaggedUnionTypesToVarying' has affected it? Zhe Hu 于2024年12月23日周一 08:48写道： > > Thank you, Mihai! > I’ll take a look at how the implicit cast works here. > > > Best regards >

Re: [ANNOUNCE] New Calcite PMC chair: Ruben Quesada Lopez

Congratulations, Ruben! Thank you for the remarkable work, Benchao! Zhe Hu 于2024年12月20日周五 21:53写道： > > Congratulations, Ruben! > > > Thank you for the remarkable work so far, Benchao! > > > Best regards, > ZheHu > > > > > Replied Message > | From | Michael Mior | > | Date | 12/20/2024

[jira] [Created] (CALCITE-6719) CODE_POINTS_TO_STRING、CODE_POINTS_TO_BYTES and TO_CODE_POINTS's return type should be nullable when return the NULL value

xiong duan created CALCITE-6719: --- Summary: CODE_POINTS_TO_STRING、CODE_POINTS_TO_BYTES and TO_CODE_POINTS's return type should be nullable when return the NULL value Key: CALCITE-6719 URL: https://issues.apach

[jira] [Created] (CALCITE-6713) NVL2's return data type should be nullable if and only if at least one of the second and third parameters are nullable

xiong duan created CALCITE-6713: --- Summary: NVL2's return data type should be nullable if and only if at least one of the second and third parameters are nullable Key: CALCITE-6713 URL: https://issues.apach

[jira] [Created] (CALCITE-6712) FROM_BASE64 and PARSE_URL's return data type should always be nullable

xiong duan created CALCITE-6712: --- Summary: FROM_BASE64 and PARSE_URL's return data type should always be nullable Key: CALCITE-6712 URL: https://issues.apache.org/jira/browse/CALCITE-6712 Pr

[jira] [Created] (CALCITE-6711) Functions whose output value can be null should return a nullable type

xiong duan created CALCITE-6711: --- Summary: Functions whose output value can be null should return a nullable type Key: CALCITE-6711 URL: https://issues.apache.org/jira/browse/CALCITE-6711 Project

Re: Column authorization development guidance

Hi Stephen, Maybe you can complete authentication by building a sub-table. For example: select * from "scott".emp You can try converting this SQL to: select * from (select EMPNO, ENAME, JOB from "scott".emp) The column EMPNO,ENAME and JOB have the authorization. Yanjing Wang 于2024年11月20日周三 10:3

[jira] [Created] (CALCITE-6665) Add isEmpty metadata to check if a relational expression returns no rows

xiong duan created CALCITE-6665: --- Summary: Add isEmpty metadata to check if a relational expression returns no rows Key: CALCITE-6665 URL: https://issues.apache.org/jira/browse/CALCITE-6665 Project

[jira] [Created] (CALCITE-6650) Optimize the IN sub-query and SOME sub-query by Metadata RowCount

xiong duan created CALCITE-6650: --- Summary: Optimize the IN sub-query and SOME sub-query by Metadata RowCount Key: CALCITE-6650 URL: https://issues.apache.org/jira/browse/CALCITE-6650 Project: Calcite

[jira] [Created] (CALCITE-6649) Enhance RelMdPredicates pull up predicate from PROJECT

xiong duan created CALCITE-6649: --- Summary: Enhance RelMdPredicates pull up predicate from PROJECT Key: CALCITE-6649 URL: https://issues.apache.org/jira/browse/CALCITE-6649 Project: Calcite

Re: TypeCoercion and OperandTypeCheckers

Hi Abbas, I don't understand what you mean. Can you use an SQL statement to express what kind of output you want and What the Calcite's output is? Then we will discuss the details. Abbas Gadhia 于2024年10月23日周三 19:12写道： > > Hello, > I noticed that in an update statement, when you assign a INT to a

Re: Help with filter that is turned into a LogicalJoin -> (LogicalTableScan, (LogicalAggregate -> LogicalUnion))

Hi, You can try to set `InSubQueryThreshold` to be larger. If the IN-LIST size is under the threshold, the IN-List will be converted to an OR condition. If it is greater than the threshold, the IN-LIST will be converted to use a join against an inline table (LogicalValues) rather than a predicate(I

[jira] [Created] (CALCITE-6638) Simplify '1 > a or 1 <= a or a is null' to TRUE when a has lossless casts

xiong duan created CALCITE-6638: --- Summary: Simplify '1 > a or 1 <= a or a is null' to TRUE when a has lossless casts Key: CALCITE-6638 URL: https://issues.apache.org/jira/browse/CALCITE-6638

Re: Calcite 1.38.0 still marked as unreleased in Jira

t it doesn’t look like you added the message 'Resolved in > > release 1.38.0 (2024-10-15)’ per the release instructions. > > > > > > > On Oct 17, 2024, at 3:22 AM, Xiong Duan wrote: > > > > > > I have marked all Jira cases in 1.38 closed. > >

Re: Calcite 1.38.0 still marked as unreleased in Jira

I have marked all Jira cases in 1.38 closed. Julian Hyde 于2024年10月17日周四 15:20写道： > > I still need to mark all jira cases in 1.38 closed. Sorry I haven’t had time. > I’ll get to it today. > > Julian > > > On Oct 16, 2024, at 18:29, Xiong Duan wrote: > > > > 

Re: Calcite 1.38.0 still marked as unreleased in Jira

The Jira issue status is RESOLVED at about 1.38, it should be CLOSED. So I update it. Alessandro Solimando 于2024年10月16日周三 16:07写道： > > Thanks Francis! > > On Wed, 16 Oct 2024 at 10:02, Francis Chuang > wrote: > > > I've marked it as released. > > > > On 16/10/2024 6:58 pm, Alessandro Solimando w

[jira] [Created] (CALCITE-6631) The common type for a comparison operator returns the wrong type when comparing a Java type long with a SQL type INTEGER

xiong duan created CALCITE-6631: --- Summary: The common type for a comparison operator returns the wrong type when comparing a Java type long with a SQL type INTEGER Key: CALCITE-6631 URL: https://issues.apache.org

Re: [VOTE] Release Apache Calcite 1.38.0 (release candidate 1)

+1 Xiong Duan(Committer) Ruben Q L 于2024年10月11日周五 01:24写道： > > Thanks Julian for preparing this release; and thanks Mihai for providing > those fixes super-quick. > > - Release notes: ok > - Checksum: ok > - Signature: ok > - Diff source release and git repository:

Re: [DISCUSS] Tidying up Calcite's branches

+1. Can we prohibit pushing the non-standard branch to the main repository？If we can do this, there won't be have new wrong branch. Francis Chuang 于2024年10月7日 周一05:27写道： > I think this is a good plan, the 26 trivial branches serve no purpose at > all. > > On 6/10/2024 9:09 am, Julian Hyde wrote:

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

+1 Xiong Duan(Committer) The Tag's web link is invalid. Julian Hyde 于2024年10月5日周六 11:36写道： > > Hi all, > > I have created a build for Apache Calcite 1.38.0, release > candidate 0. > > Thanks to everyone who has contributed to this release. > > You can read

Re: vulnerabilities: dependency scan

; > https://github.com/apache/calcite/blob/main/site/Gemfile#L18 > > https://github.com/apache/calcite/blob/main/site/Gemfile.lock#L56 > > Used for the website documentation, not the exported jar files. > > On Wed, 2 Oct 2024, 23:41 Xiong Duan, wrote: > > > Hi, We ha

Re: vulnerabilities: dependency scan

here a Gradle task to update dependencies? > (Analogous to 'mvn versions:update-properties’.) > > If so, we should do this every release. > > Julian > > > > > On Oct 2, 2024, at 9:06 AM, Xiong Duan wrote: > > > > Hi, Hugh Pearse. Thanks for checking t

Re: vulnerabilities: dependency scan

Hi, Hugh Pearse. Thanks for checking the dependency's vulnerabilities in Calcite. It is precious. We can create an ISSUE in JIRA. Hugh Pearse 于2024年10月2日周三 15:56写道： > > Our security team found these issues: > > >- Scan of *https://github.com/apache/calcite.git >

Re: Draft: board report for 2024 Q3

+1, thanks for the report. Ruben Q L 于2024年10月2日周三 16:52写道： > > +1, thanks for preparing the report. > > > On Wed, Oct 2, 2024 at 9:42 AM Francis Chuang > wrote: > > > +1, great work, Benchao! > > > > On 2/10/2024 5:54 pm, Stamatis Zampetakis wrote: > > > Looks good thanks for putting this toget

[jira] [Created] (CALCITE-6599) RelMdPredicates pull up wrong predicate from VALUES

xiong duan created CALCITE-6599: --- Summary: RelMdPredicates pull up wrong predicate from VALUES Key: CALCITE-6599 URL: https://issues.apache.org/jira/browse/CALCITE-6599 Project: Calcite Issue

[jira] [Created] (CALCITE-6592) RelMdPredicates pull up wrong predicate from UNION when it's input include NULL VALUE

xiong duan created CALCITE-6592: --- Summary: RelMdPredicates pull up wrong predicate from UNION when it's input include NULL VALUE Key: CALCITE-6592 URL: https://issues.apache.org/jira/browse/CALCITE

Re: [DISCUSS] Towards Avatica 1.26.0

+1. Apache Pig hasn't released a new version for a long time. The last version was released in 2017. [1] https://pig.apache.org/releases.html Francis Chuang 于2024年9月20日周五 05:22写道： > > I can be RM for Avatica 1.26.0. > > Francis > > On 20/09/2024 4:45 am, Ruben Q L wrote: > > +1, I think the p

Re: Questions Regarding Implementing LIMIT Clause Pushdown in Apache Calcite JDBC Driver

As far as I know, you may need to customize the implementation of SortFilterableTable to support pushing limits. Like FilterableTable, then you need to implement SortFilterTableScanRule to make sure can generate the SortFilterableTable. Mihai Budiu 于2024年9月17日周二 16:37写道： > > Isn't limit stored in

Re: [DISCUSS] Towards Calcite 1.38.0

+1 We start voting in about ten days. We will merge the almost-ready PR. Cancai Cai 于2024年9月14日周六 08:55写道： > > +1，There are still many valuable PRs in Calcite. We can try to merge them > before 1.38. > > [1] https://github.com/apache/calcite/pulls > > Best wishes, > Cancai Cai > > > 2024年9月14日 0

Re: [DISCUSS] Vote format

+1 xiong(Committer) Stamatis Zampetakis 于2024年9月14日周六 05:22写道： > > It's easier to understand who is who without checking the index [1] > that I do occasionally. > > +1 zabetak (PMC) > > [1] https://people.apache.org/committer-index.html > > On Fri, Sep 13, 2024 at 10:16 PM Julian Hyde wrote: > >

[jira] [Created] (CALCITE-6578) RelToSql throws exception when unparse TIMESTAMPDIFF function

xiong duan created CALCITE-6578: --- Summary: RelToSql throws exception when unparse TIMESTAMPDIFF function Key: CALCITE-6578 URL: https://issues.apache.org/jira/browse/CALCITE-6578 Project: Calcite

[jira] [Created] (CALCITE-6560) Add supportsNegativeScale RelDataTypeSystem

xiong duan created CALCITE-6560: --- Summary: Add supportsNegativeScale RelDataTypeSystem Key: CALCITE-6560 URL: https://issues.apache.org/jira/browse/CALCITE-6560 Project: Calcite Issue Type

[jira] [Created] (CALCITE-6548) Result type inferred for COVAR_SAMP、COVAR_POP is incorrect

xiong duan created CALCITE-6548: --- Summary: Result type inferred for COVAR_SAMP、COVAR_POP is incorrect Key: CALCITE-6548 URL: https://issues.apache.org/jira/browse/CALCITE-6548 Project: Calcite

[jira] [Created] (CALCITE-6546) Hive dialect does not support a sub-query in the FROM clause without alias

xiong duan created CALCITE-6546: --- Summary: Hive dialect does not support a sub-query in the FROM clause without alias Key: CALCITE-6546 URL: https://issues.apache.org/jira/browse/CALCITE-6546 Project

[jira] [Created] (CALCITE-6542) Jdbc adapter support use a unified alias when generating SQL

xiong duan created CALCITE-6542: --- Summary: Jdbc adapter support use a unified alias when generating SQL Key: CALCITE-6542 URL: https://issues.apache.org/jira/browse/CALCITE-6542 Project: Calcite

[jira] [Created] (CALCITE-6515) Remove constants describing which bugs have been fixed in Bug

xiong duan created CALCITE-6515: --- Summary: Remove constants describing which bugs have been fixed in Bug Key: CALCITE-6515 URL: https://issues.apache.org/jira/browse/CALCITE-6515 Project: Calcite

[jira] [Created] (CALCITE-6514) Enable tests about AssertionError while translating IN list that contains null

xiong duan created CALCITE-6514: --- Summary: Enable tests about AssertionError while translating IN list that contains null Key: CALCITE-6514 URL: https://issues.apache.org/jira/browse/CALCITE-6514

Re: [ANNOUNCE] Mihai Budiu joins Calcite PMC

Congratulations, Mihai! Thanks for your great work! Julian Hyde 于2024年7月26日周五 23:44写道： > > Welcome, Mihai! You have been showing leadership in Calcite for some time - > reviewing many PRs and starting discussions about how to make our code and > processes better - and it is appropriate that you

[jira] [Created] (CALCITE-6491) SqlOperatorFixture's checkString doesn't check the actual value against the expected result

xiong duan created CALCITE-6491: --- Summary: SqlOperatorFixture's checkString doesn't check the actual value against the expected result Key: CALCITE-6491 URL: https://issues.apache.org/jira/browse/CA

[jira] [Created] (CALCITE-6485) IN-list contains NULL throws Exception

xiong duan created CALCITE-6485: --- Summary: IN-list contains NULL throws Exception Key: CALCITE-6485 URL: https://issues.apache.org/jira/browse/CALCITE-6485 Project: Calcite Issue Type

[jira] [Created] (CALCITE-6481) Optimize 'VALUES...UNION ALL...VALUES' to a single 'VALUES' when IN-list that the values include NULL is converted to Values

xiong duan created CALCITE-6481: --- Summary: Optimize 'VALUES...UNION ALL...VALUES' to a single 'VALUES' when IN-list that the values include NULL is converted to Values Key: CALCITE-6481

[jira] [Created] (CALCITE-6478) JSON functions should return NULL when input is NULL

xiong duan created CALCITE-6478: --- Summary: JSON functions should return NULL when input is NULL Key: CALCITE-6478 URL: https://issues.apache.org/jira/browse/CALCITE-6478 Project: Calcite

[jira] [Created] (CALCITE-6475) RelToSql converter fails when IN-list that the values include NULL is converted to Values

xiong duan created CALCITE-6475: --- Summary: RelToSql converter fails when IN-list that the values include NULL is converted to Values Key: CALCITE-6475 URL: https://issues.apache.org/jira/browse/CALCITE-6475

[jira] [Created] (CALCITE-6469) Join on condition generates wrong plan when the condition is IN sub-query

xiong duan created CALCITE-6469: --- Summary: Join on condition generates wrong plan when the condition is IN sub-query Key: CALCITE-6469 URL: https://issues.apache.org/jira/browse/CALCITE-6469 Project

[jira] [Created] (CALCITE-6462) VolcanoPlanner internal valid may throw exception when log trace is enabled

xiong duan created CALCITE-6462: --- Summary: VolcanoPlanner internal valid may throw exception when log trace is enabled Key: CALCITE-6462 URL: https://issues.apache.org/jira/browse/CALCITE-6462 Project

  1   2   3   >