[jira] [Resolved] (CALCITE-6340) RelBuilder drops traits when aggregating over duplicate projected fields

2024-05-20 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando resolved CALCITE-6340. --- Resolution: Fixed Fixed via

[jira] [Created] (CALCITE-6388) PsTableFunction throws NumberFormatException when the 'user' column has spaces

2024-04-27 Thread Alessandro Solimando (Jira)
Alessandro Solimando created CALCITE-6388: - Summary: PsTableFunction throws NumberFormatException when the 'user' column has spaces Key: CALCITE-6388 URL:

[jira] [Commented] (CALCITE-6387) Calcite build while compiliation with jdk17+

2024-04-27 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6387?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17841522#comment-17841522 ] Alessandro Solimando commented on CALCITE-6387: --- Same for me, it runs fine with

[jira] [Updated] (CALCITE-6340) RelBuilder always creates Project with Convention.NONE during aggregate_

2024-04-18 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-6340: -- Fix Version/s: 1.37.0 > RelBuilder always creates Project with

[jira] [Updated] (CALCITE-5289) Assertion failure in MultiJoinOptimizeBushyRule

2024-04-18 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5289?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-5289: -- Fix Version/s: 1.37.0 > Assertion failure in MultiJoinOptimizeBushyRule >

[jira] [Assigned] (CALCITE-5289) Assertion failure in MultiJoinOptimizeBushyRule

2024-04-18 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5289?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando reassigned CALCITE-5289: - Assignee: Mihai Budiu (was: Mou Wu) > Assertion failure in

[jira] [Commented] (CALCITE-6365) Support for RETURNING clause of JSON_QUERY

2024-04-15 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6365?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17837223#comment-17837223 ] Alessandro Solimando commented on CALCITE-6365: --- It would be nice to add at least a

[jira] [Commented] (CALCITE-6362) JSON_OBJECT. Internal representation of DATE values leaks into resulting JSON object

2024-04-11 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836420#comment-17836420 ] Alessandro Solimando commented on CALCITE-6362: --- [~mzhuravkov] if you consider the

[jira] [Commented] (CALCITE-6362) JSON_OBJECT. Internal representation DATE values leaks into resulting JSON object

2024-04-11 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836181#comment-17836181 ] Alessandro Solimando commented on CALCITE-6362: --- I agree that getting a string with the

[jira] [Created] (CALCITE-6307) Sonar analysis in CI fails with 'java.lang.OutOfMemoryError: Java heap space'

2024-03-07 Thread Alessandro Solimando (Jira)
Alessandro Solimando created CALCITE-6307: - Summary: Sonar analysis in CI fails with 'java.lang.OutOfMemoryError: Java heap space' Key: CALCITE-6307 URL: https://issues.apache.org/jira/browse/CALCITE-6307

[jira] [Updated] (CALCITE-6305) Increase coverage of unit tests for the Arrow adapter

2024-03-07 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6305?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-6305: -- Summary: Increase coverage of unit tests for the Arrow adapter (was:

[jira] [Assigned] (CALCITE-6265) Type coercion is failing for numeric values in prepared statements

2024-03-07 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando reassigned CALCITE-6265: - Assignee: Tim Nieradzik (was: Alessandro Solimando) > Type coercion

[jira] [Assigned] (CALCITE-6265) Cannot provide different numeric type as placeholder

2024-03-06 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando reassigned CALCITE-6265: - Assignee: Alessandro Solimando (was: Tim Nieradzik) > Cannot provide

[jira] [Assigned] (CALCITE-6265) Cannot provide different numeric type as placeholder

2024-03-06 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando reassigned CALCITE-6265: - Assignee: Tim Nieradzik > Cannot provide different numeric type as

[jira] [Updated] (CALCITE-6265) Cannot provide different numeric type as placeholder

2024-03-06 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-6265: -- Fix Version/s: 1.37.0 > Cannot provide different numeric type as placeholder

[jira] [Commented] (CALCITE-6301) Extend ‘Must-filter’ columns to support a conditional bypass list

2024-03-06 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17824124#comment-17824124 ] Alessandro Solimando commented on CALCITE-6301: --- Thanks [~oliverlee], it's clear now with

[jira] [Commented] (CALCITE-2040) Create adapter for Apache Arrow

2024-03-06 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17824121#comment-17824121 ] Alessandro Solimando commented on CALCITE-2040: --- [~hongyuguo] thanks for creating the

[jira] [Updated] (CALCITE-2040) Create adapter for Apache Arrow

2024-03-06 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2040?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-2040: -- Fix Version/s: 1.37.0 > Create adapter for Apache Arrow >

[jira] [Commented] (CALCITE-6293) Support OR condition in arrow adapter

2024-03-06 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17823902#comment-17823902 ] Alessandro Solimando commented on CALCITE-6293: --- [~hongyuguo] is revamping the

[jira] [Commented] (CALCITE-6301) Extend ‘Must-filter’ columns to support a conditional bypass list

2024-03-05 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17823890#comment-17823890 ] Alessandro Solimando commented on CALCITE-6301: --- Isn't this equivalent to say that

[jira] [Comment Edited] (CALCITE-6301) Extend ‘Must-filter’ columns to support a conditional bypass list

2024-03-05 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17823890#comment-17823890 ] Alessandro Solimando edited comment on CALCITE-6301 at 3/6/24 7:42 AM:

[jira] [Resolved] (CALCITE-6280) Jetty version number leaked by Avatica http server

2024-02-29 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando resolved CALCITE-6280. --- Resolution: Fixed > Jetty version number leaked by Avatica http server >

[jira] [Reopened] (CALCITE-6280) Jetty version number leaked by Avatica http server

2024-02-29 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando reopened CALCITE-6280: --- > Jetty version number leaked by Avatica http server >

[jira] [Comment Edited] (CALCITE-2040) Create adapter for Apache Arrow

2024-02-25 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17820512#comment-17820512 ] Alessandro Solimando edited comment on CALCITE-2040 at 2/25/24 7:33 PM:

[jira] [Commented] (CALCITE-2040) Create adapter for Apache Arrow

2024-02-25 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17820512#comment-17820512 ] Alessandro Solimando commented on CALCITE-2040: --- [~hongyuguo], I have left a (partial)

[jira] [Commented] (CALCITE-6265) Cannot provide different numeric type as placeholder

2024-02-15 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817747#comment-17817747 ] Alessandro Solimando commented on CALCITE-6265: --- In principle I agree, but it seems that

[jira] [Commented] (CALCITE-6265) Cannot provide different numeric type as placeholder

2024-02-14 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817547#comment-17817547 ] Alessandro Solimando commented on CALCITE-6265: --- [~tnieradzik] I think it's worth

[jira] [Commented] (CALCITE-6243) Upgrade Cassandra to 4.1.3 and DataStax driver for Cassandra to 4.17.0

2024-02-10 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6243?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17816336#comment-17816336 ] Alessandro Solimando commented on CALCITE-6243: --- Fixed via

[jira] [Resolved] (CALCITE-6243) Upgrade Cassandra to 4.1.3 and DataStax driver for Cassandra to 4.17.0

2024-02-10 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6243?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando resolved CALCITE-6243. --- Resolution: Fixed > Upgrade Cassandra to 4.1.3 and DataStax driver for

[jira] [Created] (CALCITE-6243) Upgrade Cassandra to 4.1.3 and DataStax driver for Cassandra to 4.17.0

2024-02-04 Thread Alessandro Solimando (Jira)
Alessandro Solimando created CALCITE-6243: - Summary: Upgrade Cassandra to 4.1.3 and DataStax driver for Cassandra to 4.17.0 Key: CALCITE-6243 URL: https://issues.apache.org/jira/browse/CALCITE-6243

[jira] [Commented] (CALCITE-6237) Using fractions in LOG function does not return correct results

2024-02-03 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6237?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17813889#comment-17813889 ] Alessandro Solimando commented on CALCITE-6237: --- Calcite is a powerful but complex SW,

[jira] [Commented] (CALCITE-6236) EnumerableBatchNestedLoopJoin uses wrong row count for cost calculation

2024-02-01 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17813303#comment-17813303 ] Alessandro Solimando commented on CALCITE-6236: --- Equivalent in terms of cardinality

[jira] [Comment Edited] (CALCITE-6230) Jira case collections

2024-01-26 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17811192#comment-17811192 ] Alessandro Solimando edited comment on CALCITE-6230 at 1/26/24 9:57 AM:

[jira] [Commented] (CALCITE-6230) Jira case collections

2024-01-26 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17811192#comment-17811192 ] Alessandro Solimando commented on CALCITE-6230: --- [~hongyuguo], what's the purpose of this

[jira] [Comment Edited] (CALCITE-6195) SqlValidator validateParameterizedExpression is not supporting qualified paths

2024-01-10 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17805212#comment-17805212 ] Alessandro Solimando edited comment on CALCITE-6195 at 1/10/24 4:20 PM:

[jira] [Comment Edited] (CALCITE-6195) SqlValidator validateParameterizedExpression is not supporting qualified paths

2024-01-10 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17805212#comment-17805212 ] Alessandro Solimando edited comment on CALCITE-6195 at 1/10/24 4:19 PM:

[jira] [Commented] (CALCITE-6195) SqlValidator validateParameterizedExpression is not supporting qualified paths

2024-01-10 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17805212#comment-17805212 ] Alessandro Solimando commented on CALCITE-6195: --- I think it's just a matter of finding

[jira] [Commented] (CALCITE-6145) Function 'TRIM' without parameters throw NullPointerException

2023-12-25 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6145?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17800275#comment-17800275 ] Alessandro Solimando commented on CALCITE-6145: --- [~simonalexs] no need to be a committer

[jira] [Commented] (CALCITE-6145) Function 'TRIM' without parameters throw NullPointerException

2023-12-20 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6145?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17798891#comment-17798891 ] Alessandro Solimando commented on CALCITE-6145: --- [~simonalexs], that kind conversations

[jira] [Resolved] (CALCITE-6115) Interval type specifier with zero fractional second precision does not pass validation

2023-12-14 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6115?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando resolved CALCITE-6115. --- Resolution: Fixed > Interval type specifier with zero fractional second

[jira] [Updated] (CALCITE-6115) Interval type specifier with zero fractional second precision does not pass validation

2023-12-14 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6115?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-6115: -- Affects Version/s: 1.36.0 > Interval type specifier with zero fractional

[jira] [Updated] (CALCITE-6115) Interval type specifier with zero fractional second precision does not pass validation

2023-12-14 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6115?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-6115: -- Component/s: core > Interval type specifier with zero fractional second

[jira] [Updated] (CALCITE-6115) Interval type specifier with zero fractional second precision does not pass validation

2023-12-14 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6115?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-6115: -- Fix Version/s: 1.37.0 > Interval type specifier with zero fractional second

[jira] [Commented] (CALCITE-6115) Interval type specifier with zero fractional second precision does not pass validation

2023-12-14 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6115?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17796800#comment-17796800 ] Alessandro Solimando commented on CALCITE-6115: --- Fixed via

[jira] [Assigned] (CALCITE-5981) TIMESTAMPDIFF function returns incorrect result

2023-09-14 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5981?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando reassigned CALCITE-5981: - Assignee: Mihai Budiu (was: Alessandro Solimando) > TIMESTAMPDIFF

[jira] [Updated] (CALCITE-5981) TIMESTAMPDIFF function returns incorrect result

2023-09-14 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5981?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-5981: -- Affects Version/s: 1.23.0 (was: 1.35.0) >

[jira] [Updated] (CALCITE-5981) TIMESTAMPDIFF function returns incorrect result

2023-09-14 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5981?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-5981: -- Component/s: avatica (was: core) > TIMESTAMPDIFF

[jira] [Updated] (CALCITE-5981) TIMESTAMPDIFF function returns incorrect result

2023-09-14 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5981?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-5981: -- Fix Version/s: 1.24.0 > TIMESTAMPDIFF function returns incorrect result >

[jira] [Resolved] (CALCITE-5981) TIMESTAMPDIFF function returns incorrect result

2023-09-14 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5981?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando resolved CALCITE-5981. --- Resolution: Fixed Fixed via

[jira] [Assigned] (CALCITE-5981) TIMESTAMPDIFF function returns incorrect result

2023-09-14 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5981?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando reassigned CALCITE-5981: - Assignee: Alessandro Solimando (was: Mihai Budiu) > TIMESTAMPDIFF

[jira] [Assigned] (CALCITE-5981) TIMESTAMPDIFF function returns incorrect result

2023-09-14 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5981?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando reassigned CALCITE-5981: - Assignee: Mihai Budiu > TIMESTAMPDIFF function returns incorrect

[jira] [Resolved] (CALCITE-5889) Add the RelRule that converts Minus into UNION ALL..GROUP BY...WHERE

2023-09-12 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5889?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando resolved CALCITE-5889. --- Resolution: Fixed Fixed via

[jira] [Commented] (CALCITE-5972) cannot execute a sql like 'insert into A select * from B'

2023-09-04 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17761712#comment-17761712 ] Alessandro Solimando commented on CALCITE-5972: --- For now I suggest to keep it open and

[jira] [Resolved] (CALCITE-5861) ReduceExpressionsRule rules should constant-fold expressions in window bounds

2023-09-01 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5861?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando resolved CALCITE-5861. --- Resolution: Fixed Merged via

[jira] [Assigned] (CALCITE-5861) ReduceExpressionsRule rules should constant-fold expressions in window bounds

2023-09-01 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5861?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando reassigned CALCITE-5861: - Assignee: Mihai Budiu > ReduceExpressionsRule rules should

[jira] [Commented] (CALCITE-5972) cannot execute a sql like 'insert into A select * from B'

2023-09-01 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17761252#comment-17761252 ] Alessandro Solimando commented on CALCITE-5972: --- [~moccy] this seems more a question for

[jira] [Resolved] (CALCITE-5907) Unexpected boolean expression simplification for And expression

2023-08-11 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando resolved CALCITE-5907. --- Resolution: Not A Problem > Unexpected boolean expression simplification

[jira] [Commented] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if sort fields contains unique key

2023-08-04 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17751001#comment-17751001 ] Alessandro Solimando commented on CALCITE-5894: --- [~libenchao], I see your point but since

[jira] [Commented] (CALCITE-5880) When the association condition of the association subquery is 'is not distinct from', the join condition becomes '=' after decorrelation.

2023-08-03 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5880?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17750789#comment-17750789 ] Alessandro Solimando commented on CALCITE-5880: --- [~leepb], it seems we need some help

[jira] [Commented] (CALCITE-5884) Type Inference rule for ARRAY_TO_STRING is incorrect

2023-08-03 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5884?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17750595#comment-17750595 ] Alessandro Solimando commented on CALCITE-5884: --- [~mbudiu], I am a bit confused, the

[jira] [Resolved] (CALCITE-5859) Compile-time evaluation of LEFT(NULL, n) should not throw RuntimeException

2023-08-02 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5859?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando resolved CALCITE-5859. --- Resolution: Fixed Merged via

[jira] [Assigned] (CALCITE-5859) Compile-time evaluation of LEFT(NULL, n) should not throw RuntimeException

2023-08-02 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5859?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando reassigned CALCITE-5859: - Assignee: Mihai Budiu > Compile-time evaluation of LEFT(NULL, n)

[jira] [Resolved] (CALCITE-5837) RexUtil#pullFactors output's order should be deterministic even when the RexNode kind is OR

2023-08-02 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5837?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando resolved CALCITE-5837. --- Resolution: Fixed Fixed via

[jira] [Commented] (CALCITE-5837) RexUtil#pullFactors output's order should be deterministic even when the RexNode kind is OR

2023-08-01 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5837?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17749941#comment-17749941 ] Alessandro Solimando commented on CALCITE-5837: --- Just a general tip [~shenlang], you can

[jira] [Comment Edited] (CALCITE-5872) JoinPushTransitivePredicatesRule will repeatedly insert the condition "is not null"

2023-07-31 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5872?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17749259#comment-17749259 ] Alessandro Solimando edited comment on CALCITE-5872 at 7/31/23 4:22 PM:

[jira] [Commented] (CALCITE-5872) JoinPushTransitivePredicatesRule will repeatedly insert the condition "is not null"

2023-07-31 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5872?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17749259#comment-17749259 ] Alessandro Solimando commented on CALCITE-5872: --- The query does not look like a minimal

[jira] [Commented] (CALCITE-5756) Expand ProjectJoinRemoveRule to support inner join removal by using the foreign-unique constraints

2023-07-28 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17748462#comment-17748462 ] Alessandro Solimando commented on CALCITE-5756: --- I agree with you, [~jingda], it's good

[jira] [Comment Edited] (CALCITE-5872) JoinPushTransitivePredicatesRule will repeatedly insert the condition "is not null"

2023-07-25 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5872?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17747043#comment-17747043 ] Alessandro Solimando edited comment on CALCITE-5872 at 7/25/23 3:17 PM:

[jira] [Commented] (CALCITE-5872) JoinPushTransitivePredicatesRule will repeatedly insert the condition "is not null"

2023-07-25 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5872?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17747043#comment-17747043 ] Alessandro Solimando commented on CALCITE-5872: --- [~grandfisher], can you add to the

[jira] [Commented] (CALCITE-5837) After RexUtil.pullFactors method,sometimes the condition order of RexNode is not the same as before

2023-07-11 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5837?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741893#comment-17741893 ] Alessandro Solimando commented on CALCITE-5837: --- +1 from me too, we should always strive

[jira] [Commented] (CALCITE-5756) Expand ProjectJoinRemoveRule to support inner join removal by using the foreign-unique constraints

2023-06-28 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17738176#comment-17738176 ] Alessandro Solimando commented on CALCITE-5756: --- I have removed the fixVersion previously

[jira] [Updated] (CALCITE-5756) Expand ProjectJoinRemoveRule to support inner join removal by using the foreign-unique constraints

2023-06-28 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-5756: -- Fix Version/s: (was: 1.35.0) > Expand ProjectJoinRemoveRule to support

[jira] [Updated] (CALCITE-5756) Expand ProjectJoinRemoveRule to support inner join removal by using the foreign-unique constraints

2023-06-25 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-5756: -- Summary: Expand ProjectJoinRemoveRule to support inner join removal by using

[jira] [Updated] (CALCITE-5756) Expand ProjectJoinRemoveRule to support inner join remove by the foreign-unique constraint in the catalog

2023-06-25 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-5756: -- Fix Version/s: 1.35.0 > Expand ProjectJoinRemoveRule to support inner join

[jira] [Updated] (CALCITE-5756) Expand ProjectJoinRemoveRule to support inner join remove by the foreign-unique constraint in the catalog

2023-06-25 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-5756: -- Priority: Major (was: Minor) > Expand ProjectJoinRemoveRule to support

[jira] [Commented] (CALCITE-5720) improve FilterJoinRule to push filter into both join sides

2023-05-30 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17727441#comment-17727441 ] Alessandro Solimando commented on CALCITE-5720: --- {quote}`SELECT * FROM MyTable1 join

[jira] [Commented] (CALCITE-5720) improve FilterJoinRule to push filter into both join sides

2023-05-24 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17725690#comment-17725690 ] Alessandro Solimando commented on CALCITE-5720: --- [~maosuhan], thanks for sharing!

[jira] [Commented] (CALCITE-5720) improve FilterJoinRule to push filter into both join sides

2023-05-23 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17725277#comment-17725277 ] Alessandro Solimando commented on CALCITE-5720: --- Have you checked

[jira] [Updated] (CALCITE-5639) RexSimplify should remove IS NOT NULL check when LIKE comparison is present

2023-04-25 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-5639: -- Component/s: core > RexSimplify should remove IS NOT NULL check when LIKE

[jira] [Resolved] (CALCITE-5639) RexSimplify should remove IS NOT NULL check when LIKE comparison is present

2023-04-25 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando resolved CALCITE-5639. --- Fix Version/s: 1.35.0 Resolution: Fixed Fixed via

[jira] [Commented] (CALCITE-5639) RexSimplify should remove IS NOT NULL check when LIKE comparison is present

2023-04-14 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17712316#comment-17712316 ] Alessandro Solimando commented on CALCITE-5639: --- I have reviewed the PR and LGTM module

[jira] [Commented] (CALCITE-5501) SqlToRelConverterTest.checkActualAndReferenceFiles fails intermittently in Jenkins CI

2023-02-11 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17687461#comment-17687461 ] Alessandro Solimando commented on CALCITE-5501: --- I think that will help with

[jira] [Updated] (CALCITE-5501) SqlToRelConverterTest.checkActualAndReferenceFiles fails intermittently in Jenkins CI

2023-02-10 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5501?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-5501: -- Fix Version/s: 1.34.0 > SqlToRelConverterTest.checkActualAndReferenceFiles

[jira] [Resolved] (CALCITE-5501) SqlToRelConverterTest.checkActualAndReferenceFiles fails intermittently in Jenkins CI

2023-02-10 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5501?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando resolved CALCITE-5501. --- Resolution: Fixed Fixed via

[jira] [Reopened] (CALCITE-5253) NATURAL join and USING should fail if join columns are not unique - expression validation partially broken

2023-02-03 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5253?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando reopened CALCITE-5253: --- > NATURAL join and USING should fail if join columns are not unique - >

[jira] [Resolved] (CALCITE-5253) NATURAL join and USING should fail if join columns are not unique - expression validation partially broken

2023-02-03 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5253?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando resolved CALCITE-5253. --- Resolution: Fixed > NATURAL join and USING should fail if join columns are

[jira] [Commented] (CALCITE-5512) why not support FOR SYSTEM_VERSION AS OF

2023-02-01 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5512?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17682908#comment-17682908 ] Alessandro Solimando commented on CALCITE-5512: --- Removing the fixVersion as it's to be

[jira] [Updated] (CALCITE-5512) why not support FOR SYSTEM_VERSION AS OF

2023-02-01 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5512?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-5512: -- Fix Version/s: (was: 1.26.0) > why not support FOR SYSTEM_VERSION AS OF

[jira] [Updated] (CALCITE-5505) JavaCC warns about missing LOOKAHEAD directives in Parser.jj

2023-01-28 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-5505: -- Priority: Minor (was: Major) > JavaCC warns about missing LOOKAHEAD

[jira] [Created] (CALCITE-5505) JavaCC warns about missing LOOKAHEAD directives in Parser.jj

2023-01-28 Thread Alessandro Solimando (Jira)
Alessandro Solimando created CALCITE-5505: - Summary: JavaCC warns about missing LOOKAHEAD directives in Parser.jj Key: CALCITE-5505 URL: https://issues.apache.org/jira/browse/CALCITE-5505

[jira] [Comment Edited] (CALCITE-5501) SqlToRelConverterTest.checkActualAndReferenceFiles fails intermittently in Jenkins CI

2023-01-27 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17681535#comment-17681535 ] Alessandro Solimando edited comment on CALCITE-5501 at 1/28/23 7:53 AM:

[jira] [Commented] (CALCITE-5501) SqlToRelConverterTest.checkActualAndReferenceFiles fails intermittently in Jenkins CI

2023-01-27 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17681535#comment-17681535 ] Alessandro Solimando commented on CALCITE-5501: --- >From your description I think you are

[jira] [Comment Edited] (CALCITE-5501) SqlToRelConverterTest.checkActualAndReferenceFiles fails intermittently in Jenkins CI

2023-01-27 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17681468#comment-17681468 ] Alessandro Solimando edited comment on CALCITE-5501 at 1/28/23 7:42 AM:

[jira] [Commented] (CALCITE-5501) SqlToRelConverterTest.checkActualAndReferenceFiles fails intermittently in Jenkins CI

2023-01-27 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17681468#comment-17681468 ] Alessandro Solimando commented on CALCITE-5501: ---

[jira] [Assigned] (CALCITE-5501) SqlToRelConverterTest.checkActualAndReferenceFiles fails intermittently in Jenkins CI

2023-01-27 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5501?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando reassigned CALCITE-5501: - Assignee: Alessandro Solimando >

[jira] [Commented] (CALCITE-5501) SqlToRelConverterTest.checkActualAndReferenceFiles fails intermittently in Jenkins CI

2023-01-27 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17681456#comment-17681456 ] Alessandro Solimando commented on CALCITE-5501: --- Unfortunately

[jira] [Commented] (CALCITE-5501) SqlToRelConverterTest.checkActualAndReferenceFiles fails intermittently in Jenkins CI

2023-01-27 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17681409#comment-17681409 ] Alessandro Solimando commented on CALCITE-5501: --- I haven't had time to look in-depth yet

[jira] [Commented] (CALCITE-5501) SqlToRelConverterTest.checkActualAndReferenceFiles fails intermittently in Jenkins CI

2023-01-26 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17681023#comment-17681023 ] Alessandro Solimando commented on CALCITE-5501: --- This seems to be happening only on the

[jira] [Commented] (CALCITE-2989) Use ISO-8601 calendar when converting between java.sql types and unix timestamps

2022-12-07 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2989?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17644259#comment-17644259 ] Alessandro Solimando commented on CALCITE-2989: --- I have added some comments too, the PR

[jira] [Updated] (CALCITE-5414) Use DateTimeUtils to correctly convert between java.sql types and unix timestamps

2022-12-02 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-5414: -- Affects Version/s: 1.32.0 > Use DateTimeUtils to correctly convert between

  1   2   3   4   >