Re: [PR] [CALCITE-6380] Casts from INTERVAL and STRING to DECIMAL are incorrect [calcite]

2024-05-20 Thread via GitHub
caicancai commented on code in PR #3790: URL: https://github.com/apache/calcite/pull/3790#discussion_r1607483761 ## testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java: ## @@ -770,41 +773,39 @@ void testCastIntervalToNumeric(CastType castType, SqlOperatorFixture

Re: [PR] [CALCITE-6340] RelBuilder drops traits when aggregating over duplicate projected fields [calcite]

2024-05-20 Thread via GitHub
asolimando merged PR #3757: URL: https://github.com/apache/calcite/pull/3757 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail:

Re: [PR] [CALCITE-6400] MAP_ENTRIES function should throw if a key value is null [calcite]

2024-05-19 Thread via GitHub
macroguo-ghy merged PR #3787: URL: https://github.com/apache/calcite/pull/3787 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail:

Re: [PR] [CALCITE-5737] Support jdk21 and jdk22 [calcite]

2024-05-19 Thread via GitHub
snuyanzin commented on code in PR #3793: URL: https://github.com/apache/calcite/pull/3793#discussion_r1606094164 ## build.gradle.kts: ## @@ -792,6 +808,9 @@ allprojects { inputs.property("java.vm.version", System.getProperty("java.vm.version"))

Re: [PR] [CALCITE-5737] Support jdk21 and jdk22 [calcite]

2024-05-19 Thread via GitHub
sonarcloud[bot] commented on PR #3793: URL: https://github.com/apache/calcite/pull/3793#issuecomment-2119343581 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

[PR] [CALCITE-5737] Support jdk21 and jdk22 [calcite]

2024-05-19 Thread via GitHub
snuyanzin opened a new pull request, #3793: URL: https://github.com/apache/calcite/pull/3793 The PR is based on https://github.com/apache/calcite/pull/3591 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above

Re: [PR] [CALCITE-6174] Upgrade gradle from 7.6.1 to 8.7 [calcite]

2024-05-19 Thread via GitHub
sonarcloud[bot] commented on PR #3591: URL: https://github.com/apache/calcite/pull/3591#issuecomment-2119261052 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6174] Upgrade gradle from 7.6.1 to 8.7 [calcite]

2024-05-19 Thread via GitHub
sonarcloud[bot] commented on PR #3591: URL: https://github.com/apache/calcite/pull/3591#issuecomment-2119250564 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6174] Upgrade gradle from 7.6.1 to 8.7 [calcite]

2024-05-19 Thread via GitHub
snuyanzin commented on code in PR #3591: URL: https://github.com/apache/calcite/pull/3591#discussion_r1606034141 ## build.gradle.kts: ## @@ -66,15 +67,6 @@ repositories { mavenCentral() } -tasks.wrapper { Review Comment: now this task is embedded into gradle, so no

Re: [PR] [CALCITE-6174] Upgrade gradle from 7.6.1 to 8.7 [calcite]

2024-05-19 Thread via GitHub
sonarcloud[bot] commented on PR #3591: URL: https://github.com/apache/calcite/pull/3591#issuecomment-2119237724 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6174] Upgrade gradle from 7.6.1 to 8.7 [calcite]

2024-05-19 Thread via GitHub
sonarcloud[bot] commented on PR #3591: URL: https://github.com/apache/calcite/pull/3591#issuecomment-2119220601 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6174] Upgrade gradle from 7.6.1 to 8.7 [calcite]

2024-05-19 Thread via GitHub
sonarcloud[bot] commented on PR #3591: URL: https://github.com/apache/calcite/pull/3591#issuecomment-2119210168 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6174] Upgrade gradle from 7.6.1 to 8.7 [calcite]

2024-05-19 Thread via GitHub
snuyanzin commented on code in PR #3591: URL: https://github.com/apache/calcite/pull/3591#discussion_r1605994680 ## Jenkinsfile: ## @@ -44,9 +44,9 @@ node('ubuntu') { withEnv(["Path+JDK=$JAVA_JDK_17/bin","JAVA_HOME=$JAVA_JDK_17"]) {

Re: [PR] [CALCITE-6174] Upgrade gradle from 7.6.1 to 8.5 [calcite]

2024-05-19 Thread via GitHub
sonarcloud[bot] commented on PR #3591: URL: https://github.com/apache/calcite/pull/3591#issuecomment-2119174966 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6174] Upgrade gradle from 7.6.1 to 8.5 [calcite]

2024-05-19 Thread via GitHub
sonarcloud[bot] commented on PR #3591: URL: https://github.com/apache/calcite/pull/3591#issuecomment-2119164346 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6340] RelBuilder drops traits when aggregating over duplicate projected fields [calcite]

2024-05-16 Thread via GitHub
sonarcloud[bot] commented on PR #3757: URL: https://github.com/apache/calcite/pull/3757#issuecomment-2116279381 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] Bump rexml from 3.2.5 to 3.2.8 in /site [calcite-avatica]

2024-05-16 Thread via GitHub
F21 merged PR #243: URL: https://github.com/apache/calcite-avatica/pull/243 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail:

Re: [PR] [CALCITE-6340] RelBuilder drops traits when aggregating over duplicate projected fields [calcite]

2024-05-16 Thread via GitHub
jduo commented on PR #3757: URL: https://github.com/apache/calcite/pull/3757#issuecomment-2116136876 > LGTM, thanks @jduo for taking care of the comments, can you squash the commits into a single one and make sure the commit message matches exactly the title of the Jira ticket preceded by

[PR] Bump rexml from 3.2.5 to 3.2.8 in /site [calcite-avatica]

2024-05-16 Thread via GitHub
dependabot[bot] opened a new pull request, #243: URL: https://github.com/apache/calcite-avatica/pull/243 Bumps [rexml](https://github.com/ruby/rexml) from 3.2.5 to 3.2.8. Release notes Sourced from https://github.com/ruby/rexml/releases;>rexml's releases. REXML 3.2.8 -

Re: [PR] [CALCITE-6340] RelBuilder drops set conventions when aggregating over duplicate projected fields [calcite]

2024-05-16 Thread via GitHub
asolimando commented on PR #3757: URL: https://github.com/apache/calcite/pull/3757#issuecomment-2115825722 > > Few more minor changes and for me we are good to go. > > Please don't force-push until the review process is on-going as it makes incremental reviewing more difficult. >

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Oracle, Spark library) [calcite]

2024-05-16 Thread via GitHub
caicancai commented on code in PR #3785: URL: https://github.com/apache/calcite/pull/3785#discussion_r1603471671 ## core/src/main/java/org/apache/calcite/sql/type/ReturnTypes.java: ## @@ -551,6 +551,13 @@ public static SqlCall stripSeparator(SqlCall call) { opBinding ->

Re: [PR] [CALCITE-6400] MAP_ENTRIES function should throw if a key value is null [calcite]

2024-05-16 Thread via GitHub
caicancai commented on PR #3787: URL: https://github.com/apache/calcite/pull/3787#issuecomment-2115472024 @mihaibudiu Can it be merged? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the

Re: [PR] [CALCITE-6352] The map_contains_key function may return true when the key and mapkeytype types are different [calcite]

2024-05-16 Thread via GitHub
caicancai commented on PR #3786: URL: https://github.com/apache/calcite/pull/3786#issuecomment-2115470679 @mihaibudiu Can it be merged? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Oracle, Spark library) [calcite]

2024-05-16 Thread via GitHub
caicancai commented on code in PR #3785: URL: https://github.com/apache/calcite/pull/3785#discussion_r1603529235 ## core/src/main/java/org/apache/calcite/sql/type/ReturnTypes.java: ## @@ -551,6 +551,13 @@ public static SqlCall stripSeparator(SqlCall call) { opBinding ->

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Oracle, Spark library) [calcite]

2024-05-16 Thread via GitHub
caicancai commented on code in PR #3785: URL: https://github.com/apache/calcite/pull/3785#discussion_r1603471671 ## core/src/main/java/org/apache/calcite/sql/type/ReturnTypes.java: ## @@ -551,6 +551,13 @@ public static SqlCall stripSeparator(SqlCall call) { opBinding ->

Re: [PR] [CALCITE-6322] Casts to DECIMAL types are ignored [calcite]

2024-05-16 Thread via GitHub
zabetak commented on code in PR #3733: URL: https://github.com/apache/calcite/pull/3733#discussion_r1602910060 ## druid/src/test/java/org/apache/calcite/test/DruidAdapter2IT.java: ## @@ -1912,7 +1912,11 @@ private void checkGroupBySingleSortLimit(boolean approx) { +

Re: [PR] [CALCITE-6340] RelBuilder drops set conventions when aggregating over duplicate projected fields [calcite]

2024-05-15 Thread via GitHub
sonarcloud[bot] commented on PR #3757: URL: https://github.com/apache/calcite/pull/3757#issuecomment-2113237120 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6340] RelBuilder drops set conventions when aggregating over duplicate projected fields [calcite]

2024-05-15 Thread via GitHub
sonarcloud[bot] commented on PR #3757: URL: https://github.com/apache/calcite/pull/3757#issuecomment-2113195784 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6358] Support all PostgreSQL 14 date/time patterns for to_char [calcite]

2024-05-15 Thread via GitHub
sonarcloud[bot] commented on PR #3792: URL: https://github.com/apache/calcite/pull/3792#issuecomment-2113157600 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6358] Support all PostgreSQL 14 date/time patterns [calcite]

2024-05-15 Thread via GitHub
mihaibudiu commented on PR #3773: URL: https://github.com/apache/calcite/pull/3773#issuecomment-2113141295 Anything that works correctly is fine for me. Please note that I am on vacation so I won't have time to review this soon. -- This is an automated message from the Apache Git

Re: [PR] [CALCITE-6358] Support all PostgreSQL 14 date/time patterns [calcite]

2024-05-15 Thread via GitHub
sonarcloud[bot] commented on PR #3773: URL: https://github.com/apache/calcite/pull/3773#issuecomment-2113069331 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6340] RelBuilder drops set conventions when aggregating over duplicate projected fields [calcite]

2024-05-15 Thread via GitHub
jduo commented on code in PR #3757: URL: https://github.com/apache/calcite/pull/3757#discussion_r1601998815 ## core/src/test/java/org/apache/calcite/test/RelBuilderTest.java: ## @@ -1450,6 +1452,225 @@ private RexNode caseCall(RelBuilder b, RexNode ref, RexNode... nodes) {

Re: [PR] [CALCITE-6340] RelBuilder drops set conventions when aggregating over duplicate projected fields [calcite]

2024-05-15 Thread via GitHub
jduo commented on PR #3757: URL: https://github.com/apache/calcite/pull/3757#issuecomment-2113060675 > Few more minor changes and for me we are good to go. > > Please don't force-push until the review process is on-going as it makes incremental reviewing more difficult. In

Re: [PR] [CALCITE-6358] Support all PostgreSQL 14 date/time patterns for to_char [calcite]

2024-05-15 Thread via GitHub
normanj-bitquill commented on PR #3792: URL: https://github.com/apache/calcite/pull/3792#issuecomment-2113054134 This PR is the same as https://github.com/apache/calcite/pull/3773 Needed to recreate to fix CI issues. -- This is an automated message from the Apache Git Service.

Re: [PR] [CALCITE-6358] Support all PostgreSQL 14 date/time patterns [calcite]

2024-05-15 Thread via GitHub
normanj-bitquill commented on PR #3773: URL: https://github.com/apache/calcite/pull/3773#issuecomment-2113053216 @mihaibudiu I tried creating a new PR here, that did build correctly. https://github.com/apache/calcite/pull/3792 If you are OK with it, we should just use that PR and

Re: [PR] [CALCITE-6340] RelBuilder drops set conventions when aggregating over duplicate projected fields [calcite]

2024-05-15 Thread via GitHub
asolimando commented on code in PR #3757: URL: https://github.com/apache/calcite/pull/3757#discussion_r1601900134 ## core/src/test/java/org/apache/calcite/test/RelBuilderTest.java: ## @@ -1450,6 +1452,225 @@ private RexNode caseCall(RelBuilder b, RexNode ref, RexNode... nodes)

Re: [PR] [CALCITE-6358] Support all PostgreSQL 14 date/time patterns [calcite]

2024-05-14 Thread via GitHub
sonarcloud[bot] commented on PR #3773: URL: https://github.com/apache/calcite/pull/3773#issuecomment-2111333588 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6358] Support all PostgreSQL 14 date/time patterns [calcite]

2024-05-14 Thread via GitHub
sonarcloud[bot] commented on PR #3773: URL: https://github.com/apache/calcite/pull/3773#issuecomment-2111330588 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6358] Support all PostgreSQL 14 date/time patterns [calcite]

2024-05-14 Thread via GitHub
sonarcloud[bot] commented on PR #3773: URL: https://github.com/apache/calcite/pull/3773#issuecomment-2111322200 Please retry analysis of this Pull-Request directly on SonarCloud -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub

Re: [PR] [CALCITE-6358] Support all PostgreSQL 14 date/time patterns [calcite]

2024-05-14 Thread via GitHub
sonarcloud[bot] commented on PR #3773: URL: https://github.com/apache/calcite/pull/3773#issuecomment-2111322103 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6358] Support all PostgreSQL 14 date/time patterns [calcite]

2024-05-14 Thread via GitHub
normanj-bitquill commented on PR #3773: URL: https://github.com/apache/calcite/pull/3773#issuecomment-2111284526 Locally with a fresh checkout I get: ``` Skipping task ':buildSrc:autostyleKotlinGradleCheck' as it is up-to-date. ``` For the Windows build, I get: ```

Re: [PR] [CALCITE-6358] Support all PostgreSQL 14 date/time patterns [calcite]

2024-05-14 Thread via GitHub
normanj-bitquill commented on PR #3773: URL: https://github.com/apache/calcite/pull/3773#issuecomment-2111278392 I have no idea about the Windows build errors. It fails trying to do task `:buildSrc:autostyleKotlinGradleCheck`. It fails since it can't find the class

Re: [PR] [CALCITE-6358] Support all PostgreSQL 14 date/time patterns [calcite]

2024-05-14 Thread via GitHub
sonarcloud[bot] commented on PR #3773: URL: https://github.com/apache/calcite/pull/3773#issuecomment-2111095551 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Oracle, Spark library) [calcite]

2024-05-14 Thread via GitHub
mihaibudiu commented on code in PR #3785: URL: https://github.com/apache/calcite/pull/3785#discussion_r1600522936 ## core/src/main/java/org/apache/calcite/sql/type/ReturnTypes.java: ## @@ -551,6 +551,13 @@ public static SqlCall stripSeparator(SqlCall call) { opBinding ->

Re: [PR] [CALCITE-6358] Support all PostgreSQL 14 date/time patterns [calcite]

2024-05-14 Thread via GitHub
sonarcloud[bot] commented on PR #3773: URL: https://github.com/apache/calcite/pull/3773#issuecomment-2110803385 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6358] Support all PostgreSQL 14 date/time patterns [calcite]

2024-05-14 Thread via GitHub
normanj-bitquill commented on PR #3773: URL: https://github.com/apache/calcite/pull/3773#issuecomment-2110538944 > I don't understand why the CI fails. Can you please rebase on main? Maybe it has something to do with the recent transition to 1.37 which had some build system changes.

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Oracle, Spark library) [calcite]

2024-05-14 Thread via GitHub
caicancai commented on PR #3785: URL: https://github.com/apache/calcite/pull/3785#issuecomment-2110531888 @mihaibudiu PATL -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment.

Re: [PR] [CALCITE-5748] Upgrade guava from 31.1-jre to 32.0.0-jre [calcite]

2024-05-14 Thread via GitHub
snuyanzin commented on PR #3240: URL: https://github.com/apache/calcite/pull/3240#issuecomment-2109559682 closing, since the issue was solved in later guava versions -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the

Re: [PR] [CALCITE-5748] Upgrade guava from 31.1-jre to 32.0.0-jre [calcite]

2024-05-14 Thread via GitHub
snuyanzin closed pull request #3240: [CALCITE-5748] Upgrade guava from 31.1-jre to 32.0.0-jre URL: https://github.com/apache/calcite/pull/3240 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the

Re: [PR] [CALCITE-6400] MAP_ENTRIES function should throw if a key value is null [calcite]

2024-05-14 Thread via GitHub
sonarcloud[bot] commented on PR #3787: URL: https://github.com/apache/calcite/pull/3787#issuecomment-2109464195 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6400] MAP_ENTRIES allows null as a map key [calcite]

2024-05-13 Thread via GitHub
caicancai commented on PR #3787: URL: https://github.com/apache/calcite/pull/3787#issuecomment-2109072431 > The issue is about map_entries, but this PR fixes the arguments to the map constructor. Thanks, I will modify the jira summary, the description is being discussed in jira --

Re: [PR] [CALCITE-6358] Support all PostgreSQL 14 date/time patterns [calcite]

2024-05-13 Thread via GitHub
mihaibudiu commented on PR #3773: URL: https://github.com/apache/calcite/pull/3773#issuecomment-2109039604 I don't understand why the CI fails. Can you please rebase on main? Maybe it has something to do with the recent transition to 1.37 which had some build system changes. -- This

Re: [PR] [CALCITE-6313] Add POWER function for PostgreSQL [calcite]

2024-05-13 Thread via GitHub
mihaibudiu merged PR #3762: URL: https://github.com/apache/calcite/pull/3762 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail:

Re: [PR] [CALCITE-6392] Support all PostgreSQL 14 date/time patterns for to_date/to_timestamp [calcite]

2024-05-13 Thread via GitHub
mihaibudiu commented on PR #3791: URL: https://github.com/apache/calcite/pull/3791#issuecomment-2109036754 I have reverted these 6 commits merged by mistake in main. Can you please resubmit these as a separate PR? It looks like a merged PR cannot be reopened. -- This is an

Re: [PR] [CALCITE-6392] Support all PostgreSQL 14 date/time patterns for to_date/to_timestamp [calcite]

2024-05-13 Thread via GitHub
mihaibudiu commented on PR #3791: URL: https://github.com/apache/calcite/pull/3791#issuecomment-2109027856 oops, I merged the wrong PR -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the

Re: [PR] [CALCITE-6392] Support all PostgreSQL 14 date/time patterns for to_date/to_timestamp [calcite]

2024-05-13 Thread via GitHub
mihaibudiu merged PR #3791: URL: https://github.com/apache/calcite/pull/3791 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail:

Re: [PR] [CALCITE-6392] Support all PostgreSQL 14 date/time patterns for to_date/to_timestamp [calcite]

2024-05-13 Thread via GitHub
sonarcloud[bot] commented on PR #3791: URL: https://github.com/apache/calcite/pull/3791#issuecomment-2108867042 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6358] Support all PostgreSQL 14 date/time patterns [calcite]

2024-05-13 Thread via GitHub
sonarcloud[bot] commented on PR #3773: URL: https://github.com/apache/calcite/pull/3773#issuecomment-2108837190 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6400] MAP_ENTRIES allows null as a map key [calcite]

2024-05-13 Thread via GitHub
mihaibudiu commented on PR #3787: URL: https://github.com/apache/calcite/pull/3787#issuecomment-2108669763 The issue is about map_entries, but this PR fixes the arguments to the map constructor. -- This is an automated message from the Apache Git Service. To respond to the message,

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Oracle, Spark library) [calcite]

2024-05-13 Thread via GitHub
sonarcloud[bot] commented on PR #3785: URL: https://github.com/apache/calcite/pull/3785#issuecomment-2108615228 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6358] Support all PostgreSQL 14 date/time patterns [calcite]

2024-05-13 Thread via GitHub
normanj-bitquill commented on code in PR #3773: URL: https://github.com/apache/calcite/pull/3773#discussion_r1598814257 ## core/src/main/java/org/apache/calcite/sql/fun/SqlLibraryOperators.java: ## @@ -1651,13 +1652,22 @@ private static RelDataType

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Oracle, Spark library) [calcite]

2024-05-13 Thread via GitHub
caicancai commented on PR #3785: URL: https://github.com/apache/calcite/pull/3785#issuecomment-2107959410 @mihaibudiu Hello, I opened jira to discuss the comparability of character and boolean types because I'm not sure if this is a bug. https://issues.apache.org/jira/browse/CALCITE-6409

Re: [PR] [CALCITE-6358] Support all PostgreSQL 14 date/time patterns [calcite]

2024-05-12 Thread via GitHub
arkanovicz commented on code in PR #3773: URL: https://github.com/apache/calcite/pull/3773#discussion_r1597705152 ## core/src/main/java/org/apache/calcite/sql/fun/SqlLibraryOperators.java: ## @@ -1651,13 +1652,22 @@ private static RelDataType

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Spark library) [calcite]

2024-05-12 Thread via GitHub
caicancai commented on code in PR #3785: URL: https://github.com/apache/calcite/pull/3785#discussion_r1597624347 ## testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java: ## @@ -10036,6 +10036,34 @@ void assertSubFunReturns(boolean binary, String s, int start,

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Spark library) [calcite]

2024-05-12 Thread via GitHub
sonarcloud[bot] commented on PR #3785: URL: https://github.com/apache/calcite/pull/3785#issuecomment-2106181478 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Spark library) [calcite]

2024-05-12 Thread via GitHub
caicancai commented on code in PR #3785: URL: https://github.com/apache/calcite/pull/3785#discussion_r1597579339 ## site/_docs/reference.md: ## @@ -2812,6 +2812,7 @@ In the following: | b m p s | MD5(string) | Calculates an MD5 128-bit checksum of

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Spark library) [calcite]

2024-05-12 Thread via GitHub
caicancai commented on code in PR #3785: URL: https://github.com/apache/calcite/pull/3785#discussion_r1597579306 ## core/src/main/java/org/apache/calcite/sql2rel/StandardConvertletTable.java: ## @@ -418,6 +419,32 @@ private static RexNode convertNvl(SqlRexContext cx, SqlCall

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Spark library) [calcite]

2024-05-12 Thread via GitHub
caicancai commented on code in PR #3785: URL: https://github.com/apache/calcite/pull/3785#discussion_r1597579143 ## core/src/main/java/org/apache/calcite/sql/type/ReturnTypes.java: ## @@ -551,6 +551,13 @@ public static SqlCall stripSeparator(SqlCall call) { opBinding ->

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Spark library) [calcite]

2024-05-12 Thread via GitHub
caicancai commented on code in PR #3785: URL: https://github.com/apache/calcite/pull/3785#discussion_r1597579090 ## core/src/main/java/org/apache/calcite/sql/SqlKind.java: ## @@ -421,9 +421,12 @@ public enum SqlKind { /** {@code DECODE} function (Oracle). */ DECODE, -

Re: [PR] [CALCITE-6400] MAP_ENTRIES allows null as a map key [calcite]

2024-05-10 Thread via GitHub
caicancai commented on PR #3787: URL: https://github.com/apache/calcite/pull/3787#issuecomment-2105578522 @mihaibudiu @chucheng92 Good to merge? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to

Re: [PR] [CALCITE-6400] MAP_ENTRIES allows null as a map key [calcite]

2024-05-10 Thread via GitHub
sonarcloud[bot] commented on PR #3787: URL: https://github.com/apache/calcite/pull/3787#issuecomment-2105505318 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6392] Support all PostgreSQL 14 date/time patterns for to_date/to_timestamp [calcite]

2024-05-10 Thread via GitHub
sonarcloud[bot] commented on PR #3791: URL: https://github.com/apache/calcite/pull/3791#issuecomment-2105369153 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6392] Support all PostgreSQL 14 date/time patterns for to_date/to_timestamp [calcite]

2024-05-10 Thread via GitHub
sonarcloud[bot] commented on PR #3791: URL: https://github.com/apache/calcite/pull/3791#issuecomment-2105359071 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6392] Support all PostgreSQL 14 date/time patterns for to_date/to_timestamp [calcite]

2024-05-10 Thread via GitHub
sonarcloud[bot] commented on PR #3791: URL: https://github.com/apache/calcite/pull/3791#issuecomment-2105338412 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6392] Support all PostgreSQL 14 date/time patterns for to_date/to_timestamp [calcite]

2024-05-10 Thread via GitHub
sonarcloud[bot] commented on PR #3791: URL: https://github.com/apache/calcite/pull/3791#issuecomment-2105334480 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6392] Support all PostgreSQL 14 date/time patterns for to_date/to_timestamp [calcite]

2024-05-10 Thread via GitHub
sonarcloud[bot] commented on PR #3791: URL: https://github.com/apache/calcite/pull/3791#issuecomment-2105310353 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

[PR] [CALCITE-6392] Support all PostgreSQL 14 date/time patterns for to_date/to_timestamp [calcite]

2024-05-10 Thread via GitHub
normanj-bitquill opened a new pull request, #3791: URL: https://github.com/apache/calcite/pull/3791 * First phase, mostly reorganizing classes * Does not yet implement to_date or to_timestamp * Fixed up fill mode handling * Isolated the unit test class so that it can make Locale

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Spark library) [calcite]

2024-05-10 Thread via GitHub
julianhyde commented on code in PR #3785: URL: https://github.com/apache/calcite/pull/3785#discussion_r1597166998 ## testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java: ## @@ -10036,6 +10036,34 @@ void assertSubFunReturns(boolean binary, String s, int start,

[PR] [CALCITE-6380] Casts from INTERVAL and STRING to DECIMAL are incorrect [calcite]

2024-05-10 Thread via GitHub
mihaibudiu opened a new pull request, #3790: URL: https://github.com/apache/calcite/pull/3790 (no comment) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe,

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Spark library) [calcite]

2024-05-10 Thread via GitHub
julianhyde commented on code in PR #3785: URL: https://github.com/apache/calcite/pull/3785#discussion_r1597164314 ## testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java: ## @@ -10397,6 +10397,50 @@ void assertSubFunReturns(boolean binary, String s, int start,

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Spark library) [calcite]

2024-05-10 Thread via GitHub
julianhyde commented on code in PR #3785: URL: https://github.com/apache/calcite/pull/3785#discussion_r1597163878 ## site/_docs/reference.md: ## @@ -2812,6 +2812,7 @@ In the following: | b m p s | MD5(string) | Calculates an MD5 128-bit checksum

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Spark library) [calcite]

2024-05-10 Thread via GitHub
julianhyde commented on code in PR #3785: URL: https://github.com/apache/calcite/pull/3785#discussion_r1597162522 ## core/src/main/java/org/apache/calcite/sql/type/ReturnTypes.java: ## @@ -551,6 +551,13 @@ public static SqlCall stripSeparator(SqlCall call) { opBinding ->

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Spark library) [calcite]

2024-05-10 Thread via GitHub
julianhyde commented on code in PR #3785: URL: https://github.com/apache/calcite/pull/3785#discussion_r1597162056 ## core/src/main/java/org/apache/calcite/sql2rel/StandardConvertletTable.java: ## @@ -418,6 +419,32 @@ private static RexNode convertNvl(SqlRexContext cx, SqlCall

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Spark library) [calcite]

2024-05-10 Thread via GitHub
julianhyde commented on code in PR #3785: URL: https://github.com/apache/calcite/pull/3785#discussion_r1597161501 ## core/src/main/java/org/apache/calcite/sql2rel/StandardConvertletTable.java: ## @@ -418,6 +419,32 @@ private static RexNode convertNvl(SqlRexContext cx, SqlCall

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Spark library) [calcite]

2024-05-10 Thread via GitHub
julianhyde commented on code in PR #3785: URL: https://github.com/apache/calcite/pull/3785#discussion_r1597157484 ## core/src/main/java/org/apache/calcite/sql/type/ReturnTypes.java: ## @@ -551,6 +551,13 @@ public static SqlCall stripSeparator(SqlCall call) { opBinding ->

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Spark library) [calcite]

2024-05-10 Thread via GitHub
julianhyde commented on code in PR #3785: URL: https://github.com/apache/calcite/pull/3785#discussion_r1597156525 ## core/src/main/java/org/apache/calcite/sql/SqlKind.java: ## @@ -421,9 +421,12 @@ public enum SqlKind { /** {@code DECODE} function (Oracle). */ DECODE, -

Re: [PR] [CALCITE-6322] Casts to DECIMAL types are ignored [calcite]

2024-05-10 Thread via GitHub
sonarcloud[bot] commented on PR #3733: URL: https://github.com/apache/calcite/pull/3733#issuecomment-2105155879 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6322] Casts to DECIMAL types are ignored [calcite]

2024-05-10 Thread via GitHub
mihaibudiu commented on PR #3733: URL: https://github.com/apache/calcite/pull/3733#issuecomment-2105146098 @zabetak I think I have addressed your comments. I moved part of this PR into in a separate one which has been merged https://github.com/apache/calcite/pull/3779. So what's left

Re: [PR] [CALCITE-6389] RexBuilder.removeCastFromLiteral does not preserve semantics for some… [calcite]

2024-05-10 Thread via GitHub
mihaibudiu merged PR #3779: URL: https://github.com/apache/calcite/pull/3779 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail:

Re: [PR] [CALCITE-6389] RexBuilder.removeCastFromLiteral does not preserve semantics for some… [calcite]

2024-05-10 Thread via GitHub
snuyanzin commented on code in PR #3779: URL: https://github.com/apache/calcite/pull/3779#discussion_r1597039588 ## core/src/main/java/org/apache/calcite/sql/type/SqlTypeUtil.java: ## @@ -1822,6 +1823,35 @@ public static RelDataType extractLastNFields(RelDataTypeFactory

Re: [PR] [CALCITE-6389] RexBuilder.removeCastFromLiteral does not preserve semantics for some… [calcite]

2024-05-10 Thread via GitHub
mihaibudiu commented on code in PR #3779: URL: https://github.com/apache/calcite/pull/3779#discussion_r1597033016 ## core/src/main/java/org/apache/calcite/sql/type/SqlTypeUtil.java: ## @@ -1822,6 +1823,35 @@ public static RelDataType extractLastNFields(RelDataTypeFactory

Re: [PR] [CALCITE-6365] Support for RETURNING clause of JSON_QUERY [calcite]

2024-05-10 Thread via GitHub
mihaibudiu merged PR #3771: URL: https://github.com/apache/calcite/pull/3771 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail:

Re: [PR] [CALCITE-6358] Support all PostgreSQL 14 date/time patterns [calcite]

2024-05-10 Thread via GitHub
sonarcloud[bot] commented on PR #3773: URL: https://github.com/apache/calcite/pull/3773#issuecomment-2104930854 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6358] Support all PostgreSQL 14 date/time patterns [calcite]

2024-05-10 Thread via GitHub
sonarcloud[bot] commented on PR #3773: URL: https://github.com/apache/calcite/pull/3773#issuecomment-2104906834 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Spark library) [calcite]

2024-05-10 Thread via GitHub
sonarcloud[bot] commented on PR #3785: URL: https://github.com/apache/calcite/pull/3785#issuecomment-2104898121 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Spark library) [calcite]

2024-05-10 Thread via GitHub
caicancai commented on PR #3785: URL: https://github.com/apache/calcite/pull/3785#issuecomment-2104872020 @mihaibudiu I would like to ask a question. The type check of NVL2 (2.0, 'abc', true) in calcite is allowed. The string type and the boolean type are comparable. I am not sure about

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Spark library) [calcite]

2024-05-10 Thread via GitHub
caicancai commented on code in PR #3785: URL: https://github.com/apache/calcite/pull/3785#discussion_r1596944009 ## testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java: ## @@ -10036,6 +10036,45 @@ void assertSubFunReturns(boolean binary, String s, int start,

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Spark library) [calcite]

2024-05-10 Thread via GitHub
caicancai commented on code in PR #3785: URL: https://github.com/apache/calcite/pull/3785#discussion_r1596942382 ## testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java: ## @@ -10036,6 +10036,45 @@ void assertSubFunReturns(boolean binary, String s, int start,

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Spark library) [calcite]

2024-05-10 Thread via GitHub
caicancai commented on code in PR #3785: URL: https://github.com/apache/calcite/pull/3785#discussion_r1596920047 ## testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java: ## @@ -10036,6 +10036,45 @@ void assertSubFunReturns(boolean binary, String s, int start,

Re: [PR] [CALCITE-6397] Add NVL2 function (enabled in Spark library) [calcite]

2024-05-10 Thread via GitHub
caicancai commented on code in PR #3785: URL: https://github.com/apache/calcite/pull/3785#discussion_r1596920047 ## testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java: ## @@ -10036,6 +10036,45 @@ void assertSubFunReturns(boolean binary, String s, int start,

  1   2   3   4   5   6   7   8   9   10   >