[jira] [Commented] (CALCITE-5739) Add MAP_FROM_ARRAYS for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5739?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728921#comment-17728921 ] jackylau commented on CALCITE-5739: --- and some pr is simple whether it is be merged fa

[jira] [Commented] (CALCITE-5739) Add MAP_FROM_ARRAYS for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5739?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728920#comment-17728920 ] jackylau commented on CALCITE-5739: --- [~jiajunbernoulli] thanks for your review, i add

[jira] [Comment Edited] (CALCITE-5730) Initial null values can be dropped by EnumerableLimitSort with offset

[ https://issues.apache.org/jira/browse/CALCITE-5730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728586#comment-17728586 ] Julian Hyde edited comment on CALCITE-5730 at 6/3/23 5:35 AM: ---

[jira] [Comment Edited] (CALCITE-5714) Add MAP_ENTRIES for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5714?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728737#comment-17728737 ] Julian Hyde edited comment on CALCITE-5714 at 6/3/23 5:33 AM: ---

[jira] [Comment Edited] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728849#comment-17728849 ] Julian Hyde edited comment on CALCITE-5722 at 6/3/23 5:32 AM: ---

[jira] [Commented] (CALCITE-5745) CONCAT2 function(enabled in Oracle library) gets wrong result when one of the argument is NULL

[ https://issues.apache.org/jira/browse/CALCITE-5745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728910#comment-17728910 ] ZheHu commented on CALCITE-5745: Hi [~julianhyde], I also checked CONCAT function in My

[jira] [Commented] (CALCITE-1924) Support operator "+" as string concat operator(enabled in MSSQL library)

[ https://issues.apache.org/jira/browse/CALCITE-1924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728909#comment-17728909 ] ZheHu commented on CALCITE-1924: According to [mssql-concat-doc|https://learn.microsof

[jira] [Commented] (CALCITE-5745) CONCAT2 function(enabled in Oracle library) gets wrong result when one of the argument is NULL

[ https://issues.apache.org/jira/browse/CALCITE-5745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728900#comment-17728900 ] ZheHu commented on CALCITE-5745: Per [Oracle-19-release|https://docs.oracle.com/en/dat

[jira] [Commented] (CALCITE-5739) Add MAP_FROM_ARRAYS for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5739?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728899#comment-17728899 ] Jiajun Xie commented on CALCITE-5739: - [~jackylau] , Can you try to do similar func

[jira] [Comment Edited] (CALCITE-5740) Support for AggToSemiJoinRule

[ https://issues.apache.org/jira/browse/CALCITE-5740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728894#comment-17728894 ] Rong Rong edited comment on CALCITE-5740 at 6/3/23 1:00 AM:

[jira] [Commented] (CALCITE-5740) Support for AggToSemiJoinRule

[ https://issues.apache.org/jira/browse/CALCITE-5740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728894#comment-17728894 ] Rong Rong commented on CALCITE-5740: forgot to post an example As an example: ```

[jira] [Commented] (CALCITE-5740) Support for AggToSemiJoinRule

[ https://issues.apache.org/jira/browse/CALCITE-5740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728893#comment-17728893 ] Rong Rong commented on CALCITE-5740: hmm. IIUC the PROJECT_TO_SEMI_JOIN doesn't act

[jira] [Resolved] (CALCITE-5567) Failed to apply plugin 'de.thetaphi.forbiddenapis' when running ./gradlew build w/ java19

[ https://issues.apache.org/jira/browse/CALCITE-5567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5567. -- Resolution: Fixed Fixed in Avatica [92edd93e|https://github.com/apache/calcite-avatica/commi

[jira] [Updated] (CALCITE-5747) Conflicting FLOOR return type between Calcite and BigQuery

[ https://issues.apache.org/jira/browse/CALCITE-5747?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary updated CALCITE-5747: -- Description: In Calcite, the {{FLOOR}} function return type is set to {{ARG0_OR_EXACT_NO_SCA

[jira] [Updated] (CALCITE-5747) Conflicting FLOOR return type between Calcite and BigQuery

[ https://issues.apache.org/jira/browse/CALCITE-5747?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary updated CALCITE-5747: -- Description: In Calcite, the {{FLOOR}} function return type is set to {{ARG0_OR_EXACT_NO_SCA

[jira] [Updated] (CALCITE-5747) Conflicting FLOOR return type between Calcite and BigQuery

[ https://issues.apache.org/jira/browse/CALCITE-5747?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary updated CALCITE-5747: -- Description: In Calcite, the {{FLOOR}} function return type is set to {{ARG0_OR_EXACT_NO_SCA

[jira] [Updated] (CALCITE-5747) Conflicting FLOOR return type between Calcite and BigQuery

[ https://issues.apache.org/jira/browse/CALCITE-5747?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary updated CALCITE-5747: -- Summary: Conflicting FLOOR return type between Calcite and BigQuery (was: FLOOR() return typ

[jira] [Created] (CALCITE-5747) FLOOR() return type differs from BigQuery

Tanner Clary created CALCITE-5747: - Summary: FLOOR() return type differs from BigQuery Key: CALCITE-5747 URL: https://issues.apache.org/jira/browse/CALCITE-5747 Project: Calcite Issue Type: B

[jira] [Commented] (CALCITE-5745) CONCAT2 function(enabled in Oracle library) gets wrong result when one of the argument is NULL

[ https://issues.apache.org/jira/browse/CALCITE-5745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728866#comment-17728866 ] Julian Hyde commented on CALCITE-5745: -- Oracle has a mode where NULL values are in

[jira] [Comment Edited] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728849#comment-17728849 ] Julian Hyde edited comment on CALCITE-5722 at 6/2/23 7:19 PM: ---

[jira] [Resolved] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5722. -- Fix Version/s: 1.35.0 Resolution: Fixed Fixed in [8ea4160f10https://github.com/apache

[jira] [Updated] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5722: Labels: pull-request-available (was: ) > Sarg.isComplementedPoints fails with anti-point

[jira] [Updated] (CALCITE-5746) Support JDK 19

[ https://issues.apache.org/jira/browse/CALCITE-5746?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5746: - Description: Support JDK 19 in Calcite. Modify history.md and remove calls to deprecated Local

[jira] [Updated] (CALCITE-5737) Support JDK 20

[ https://issues.apache.org/jira/browse/CALCITE-5737?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5737: - Summary: Support JDK 20 (was: Support JDK 19, JDK 20) > Support JDK 20 > -- > >

[jira] [Updated] (CALCITE-5737) Support JDK 19, JDK 20

[ https://issues.apache.org/jira/browse/CALCITE-5737?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5737: - Description: Support JDK 20. We currently support JDK (and OpenJDK) versions up to 18. (CALCIT

[jira] [Commented] (CALCITE-5737) Support JDK 19, JDK 20

[ https://issues.apache.org/jira/browse/CALCITE-5737?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728847#comment-17728847 ] Julian Hyde commented on CALCITE-5737: -- Oops, I see that CALCITE-5567 is an Avatic

[jira] [Created] (CALCITE-5746) Support JDK 19

Julian Hyde created CALCITE-5746: Summary: Support JDK 19 Key: CALCITE-5746 URL: https://issues.apache.org/jira/browse/CALCITE-5746 Project: Calcite Issue Type: Bug Reporter: Juli

[jira] [Commented] (CALCITE-5737) Support JDK 19, JDK 20

[ https://issues.apache.org/jira/browse/CALCITE-5737?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728845#comment-17728845 ] Julian Hyde commented on CALCITE-5737: -- [~Sergey Nuyanzin], I agree that JDK 20 wi

[jira] [Updated] (CALCITE-5724) Generated SQL uses literal values in ORDER BY clauses

[ https://issues.apache.org/jira/browse/CALCITE-5724?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5724: Labels: pull-request-available (was: ) > Generated SQL uses literal values in ORDER BY c

[jira] [Updated] (CALCITE-5676) Appropriately set JDBC `DATA_TYPE` and `TYPE_NAME` metadata values for `MEASURE` types

[ https://issues.apache.org/jira/browse/CALCITE-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-5676: - Description: Subtask of CALCITE-5549 to focus on the metadata we can control in calcite-core.

[jira] [Updated] (CALCITE-5676) Appropriately set JDBC `DATA_TYPE` and `TYPE_NAME` metadata values for `MEASURE` types

[ https://issues.apache.org/jira/browse/CALCITE-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-5676: - Summary: Appropriately set JDBC `DATA_TYPE` and `TYPE_NAME` metadata values for `MEASURE` types

[jira] [Commented] (CALCITE-5676) Appropriately set `DATA_TYPE` and `TYPE_NAME` metadata values for `MEASURE` types

[ https://issues.apache.org/jira/browse/CALCITE-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728820#comment-17728820 ] Julian Hyde commented on CALCITE-5676: -- I guess you're talking about the JDBC driv

[jira] [Commented] (CALCITE-5743) An error occurs when count appears in the correlated subquery select list

[ https://issues.apache.org/jira/browse/CALCITE-5743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728792#comment-17728792 ] Julian Hyde commented on CALCITE-5743: -- I believe that decorrelation is converting

[jira] [Created] (CALCITE-5745) CONCAT2 function(enabled in Oracle library) gets wrong result when one of the argument is NULL

ZheHu created CALCITE-5745: -- Summary: CONCAT2 function(enabled in Oracle library) gets wrong result when one of the argument is NULL Key: CALCITE-5745 URL: https://issues.apache.org/jira/browse/CALCITE-5745

[jira] [Resolved] (CALCITE-5714) Add MAP_ENTRIES for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5714?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5714. - Resolution: Fixed > Add MAP_ENTRIES for Spark dialect > - > >

[jira] [Commented] (CALCITE-5714) Add MAP_ENTRIES for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5714?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728737#comment-17728737 ] Jiajun Xie commented on CALCITE-5714: - Fixed in [c14e071.|https://github.com/apach

[jira] [Updated] (CALCITE-5739) Add MAP_FROM_ARRAYS for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5739?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5739: Labels: pull-request-available (was: ) > Add MAP_FROM_ARRAYS for Spark dialect > ---

[jira] [Updated] (CALCITE-5744) Add STR_TO_MAP for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5744: Labels: pull-request-available (was: ) > Add STR_TO_MAP for Spark dialect >

[jira] [Updated] (CALCITE-5744) Add STR_TO_MAP for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5744: -- Description:  STR_TO_MAP(string[, stringDelimiter[, keyValueDelimiter]]) - Returns a map after split

[jira] [Created] (CALCITE-5744) Add STR_TO_MAP for Spark dialect

jackylau created CALCITE-5744: - Summary: Add STR_TO_MAP for Spark dialect Key: CALCITE-5744 URL: https://issues.apache.org/jira/browse/CALCITE-5744 Project: Calcite Issue Type: Improvement

[jira] [Updated] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL

[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-5708: Fix Version/s: 1.35.0 > Change SUBSTRING result if either of parameters is NULL >

[jira] [Commented] (CALCITE-5568) Decorrelate will fail. If the RelNode tree has LogicalValues

[ https://issues.apache.org/jira/browse/CALCITE-5568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728666#comment-17728666 ] libopeng commented on CALCITE-5568: --- I raised a new issue to record the problem [CAL

[jira] [Comment Edited] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL

[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17725091#comment-17725091 ] Evgeny Stanilovsky edited comment on CALCITE-5708 at 6/2/23 10:01 AM: ---

[jira] [Created] (CALCITE-5743) An error occurs when count appears in the correlated subquery select list

libopeng created CALCITE-5743: - Summary: An error occurs when count appears in the correlated subquery select list Key: CALCITE-5743 URL: https://issues.apache.org/jira/browse/CALCITE-5743 Project: Calcit

[jira] [Updated] (CALCITE-5742) SubstitutionVisitor Causes Infinite Loop when using AggregateOnCalcToAggregateUnifyRule

[ https://issues.apache.org/jira/browse/CALCITE-5742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] junheleo updated CALCITE-5742: -- Description: Here is a simple code snippet to reproduce the issue: {code:java} // Test case in Materi

[jira] [Created] (CALCITE-5742) SubstitutionVisitor Causes Infinite Loop when using AggregateOnCalcToAggregateUnifyRule

junheleo created CALCITE-5742: - Summary: SubstitutionVisitor Causes Infinite Loop when using AggregateOnCalcToAggregateUnifyRule Key: CALCITE-5742 URL: https://issues.apache.org/jira/browse/CALCITE-5742 P

[jira] [Comment Edited] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL

[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17725091#comment-17725091 ] Evgeny Stanilovsky edited comment on CALCITE-5708 at 6/2/23 9:13 AM:

[jira] [Comment Edited] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL

[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17725091#comment-17725091 ] Evgeny Stanilovsky edited comment on CALCITE-5708 at 6/2/23 9:08 AM:

[jira] [Commented] (CALCITE-5568) Decorrelate will fail. If the RelNode tree has LogicalValues

[ https://issues.apache.org/jira/browse/CALCITE-5568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728636#comment-17728636 ] libopeng commented on CALCITE-5568: --- {code:java} SELECT `t0`.`_c0` FROM ( SELECT `t`.

[jira] [Comment Edited] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL

[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17725091#comment-17725091 ] Evgeny Stanilovsky edited comment on CALCITE-5708 at 6/2/23 9:06 AM:

[jira] [Created] (CALCITE-5741) Add support for MSSQL CONCAT_WS function

ZheHu created CALCITE-5741: -- Summary: Add support for MSSQL CONCAT_WS function Key: CALCITE-5741 URL: https://issues.apache.org/jira/browse/CALCITE-5741 Project: Calcite Issue Type: Improvement

[jira] [Updated] (CALCITE-5728) Add ARRAY_TO_STRING function (enabled in BigQuery library)

[ https://issues.apache.org/jira/browse/CALCITE-5728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5728: Labels: pull-request-available (was: ) > Add ARRAY_TO_STRING function (enabled in BigQue

[jira] [Comment Edited] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL

[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17725091#comment-17725091 ] Evgeny Stanilovsky edited comment on CALCITE-5708 at 6/2/23 7:40 AM:

[jira] [Commented] (CALCITE-5740) Support for AggToSemiJoinRule

[ https://issues.apache.org/jira/browse/CALCITE-5740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728600#comment-17728600 ] Julian Hyde commented on CALCITE-5740: -- I don’t understand. When does it make sens