Re: [PR] [CALCITE-5955] BigQuery PERCENTILE functions are unparsed incorrectly [calcite]

2023-12-21 Thread via GitHub
caicancai commented on PR #3438: URL: https://github.com/apache/calcite/pull/3438#issuecomment-1867349263 > > @tanclary Hello, should we add corresponding tests to SqlOperatorTest > > @caicancai Could you clarify what you mean? I believe there are already tests for these functions in

Re: [PR] [CALCITE-6165] Add DATE_ADD test and DATE_DIFF test on SqlOperatorTest [calcite]

2023-12-21 Thread via GitHub
caicancai commented on code in PR #3586: URL: https://github.com/apache/calcite/pull/3586#discussion_r1434803576 ## testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java: ## @@ -11948,6 +11984,25 @@ void testTimestampDiff(boolean coercionEnabled) {

Re: [PR] [CALCITE-6165] Add DATE_ADD test and DATE_DIFF test on SqlOperatorTest [calcite]

2023-12-21 Thread via GitHub
caicancai commented on code in PR #3586: URL: https://github.com/apache/calcite/pull/3586#discussion_r1434801168 ## testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java: ## @@ -11859,6 +11859,42 @@ void testTimestampDiff(boolean coercionEnabled) {

Re: [PR] Control simplification in RelBuilder#filter with `config.simplify()' [calcite]

2023-12-21 Thread via GitHub
TusharSthul closed pull request #3592: Control simplification in RelBuilder#filter with `config.simplify()' URL: https://github.com/apache/calcite/pull/3592 -- 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-6165] Add DATE_SUB test and DATE_DIFF test on SqlOperatorTest [calcite]

2023-12-21 Thread via GitHub
chucheng92 commented on PR #3586: URL: https://github.com/apache/calcite/pull/3586#issuecomment-1867156919 The commit name "Add DATE_SUB test and DATE_DIFF" but you actually add DATE_ADD and DATE_DIFF. could you recheck it? -- This is an automated message from the Apache Git Service. To

Re: [PR] [CALCITE-6165] Add DATE_SUB test and DATE_DIFF test on SqlOperatorTest [calcite]

2023-12-21 Thread via GitHub
chucheng92 commented on code in PR #3586: URL: https://github.com/apache/calcite/pull/3586#discussion_r1433384145 ## testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java: ## @@ -11859,6 +11859,42 @@ void testTimestampDiff(boolean coercionEnabled) {

Re: [PR] [CALCITE-6172] PoC for parameterized tests [calcite]

2023-12-21 Thread via GitHub
mihaibudiu commented on code in PR #3590: URL: https://github.com/apache/calcite/pull/3590#discussion_r1434660313 ## testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java: ## @@ -8897,56 +8898,44 @@ private void testCurrentDateFunc(Pair pair) {

Re: [PR] [CALCITE-6172] PoC for parameterized tests [calcite]

2023-12-21 Thread via GitHub
snuyanzin commented on code in PR #3590: URL: https://github.com/apache/calcite/pull/3590#discussion_r1434637134 ## testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java: ## @@ -8897,56 +8898,44 @@ private void testCurrentDateFunc(Pair pair) {

Re: [PR] [CALCITE-6172] PoC for parameterized tests [calcite]

2023-12-21 Thread via GitHub
sonarcloud[bot] commented on PR #3590: URL: https://github.com/apache/calcite/pull/3590#issuecomment-1867101890 ## [![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]

2023-12-21 Thread via GitHub
snuyanzin commented on code in PR #3591: URL: https://github.com/apache/calcite/pull/3591#discussion_r1434619460 ## gradle.properties: ## @@ -174,3 +174,5 @@ xercesImpl.version=2.9.1 systemProp.sonar.organization=apache systemProp.sonar.projectKey=apache_calcite

Re: [PR] [CALCITE-6138] Parser does not accept TIMESTAMP WITH TIME ZONE as a data type [calcite]

2023-12-21 Thread via GitHub
mihaibudiu commented on PR #3569: URL: https://github.com/apache/calcite/pull/3569#issuecomment-1867088799 I have simplified the naming of the types, as suggested by @julianhyde in a JIRA discussion for the uber-issue 208 that this PR is a part of:

Re: [PR] [CALCITE-6172] PoC for parameterized tests [calcite]

2023-12-21 Thread via GitHub
mihaibudiu commented on code in PR #3590: URL: https://github.com/apache/calcite/pull/3590#discussion_r1434613012 ## testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java: ## @@ -8897,56 +8898,44 @@ private void testCurrentDateFunc(Pair pair) {

Re: [PR] [CALCITE-6172] PoC for parameterized tests [calcite]

2023-12-21 Thread via GitHub
julianhyde commented on code in PR #3590: URL: https://github.com/apache/calcite/pull/3590#discussion_r1434597746 ## testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java: ## @@ -13686,6 +13673,31 @@ void testCastTruncates(CastType castType, SqlOperatorFixture f)

Re: [PR] [CALCITE-6172] PoC for parameterized tests [calcite]

2023-12-21 Thread via GitHub
julianhyde commented on PR #3590: URL: https://github.com/apache/calcite/pull/3590#issuecomment-1867061770 @mihaibudiu The danger with your approach is that, by working on the AST, you automatically fix errors. E.g. you might accidentally change STARTSWITH to STARTS_WITH and not notice

Re: [PR] [CALCITE-6172] PoC for parameterized tests [calcite]

2023-12-21 Thread via GitHub
julianhyde commented on code in PR #3590: URL: https://github.com/apache/calcite/pull/3590#discussion_r1434594909 ## testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java: ## @@ -8897,56 +8898,42 @@ private void testCurrentDateFunc(Pair pair) {

Re: [PR] [CALCITE-6172] PoC for parameterized tests [calcite]

2023-12-21 Thread via GitHub
julianhyde commented on code in PR #3590: URL: https://github.com/apache/calcite/pull/3590#discussion_r1434594471 ## testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java: ## @@ -13686,6 +13673,31 @@ void testCastTruncates(CastType castType, SqlOperatorFixture f)

Re: [PR] [CALCITE-6172] PoC for parameterized tests [calcite]

2023-12-21 Thread via GitHub
mihaibudiu commented on PR #3590: URL: https://github.com/apache/calcite/pull/3590#issuecomment-1867056620 You leave the queries unchanged, and then you use a shuttle to replace the use of `starts_with` with `startswith`. -- This is an automated message from the Apache Git Service. To

Re: [PR] [CALCITE-6172] PoC for parameterized tests [calcite]

2023-12-21 Thread via GitHub
snuyanzin commented on PR #3590: URL: https://github.com/apache/calcite/pull/3590#issuecomment-1867055416 I didn't get how shuttle could help with different `SQLLibraries` per alias... -- This is an automated message from the Apache Git Service. To respond to the message, please log on

[PR] [CALCITE-3522] Sql validator limits decimal literals to 64 bits and [CALCITE-6169] EnumUtils.convert does not implement the correct SQL cast semantics [calcite]

2023-12-21 Thread via GitHub
mihaibudiu opened a new pull request, #3589: URL: https://github.com/apache/calcite/pull/3589 I initially started with the goal of fixing just [CALCITE-3522], https://issues.apache.org/jira/browse/CALCITE-3522, which is limiting the size of decimal literals to 64 bits. The fix is to

Re: [PR] [CALCITE-6156] Add ENDSWITH, STARTSWITH functions (enabled in Postgres, Snowflake libraries) [calcite]

2023-12-21 Thread via GitHub
tanclary merged PR #3565: URL: https://github.com/apache/calcite/pull/3565 -- 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:

(calcite) branch main updated: [CALCITE-6156] Add ENDSWITH, STARTSWITH functions (enabled in Postgres, Snowflake libraries)

2023-12-21 Thread tanner
This is an automated email from the ASF dual-hosted git repository. tanner pushed a commit to branch main in repository https://gitbox.apache.org/repos/asf/calcite.git The following commit(s) were added to refs/heads/main by this push: new e74ff3eaa0 [CALCITE-6156] Add ENDSWITH, STARTSWITH

Re: [PR] [CALCITE-6156] Add ENDSWITH, STARTSWITH functions (enabled in Postgres, Snowflake libraries) [calcite]

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

Re: [PR] [CALCITE-6156] Add ENDSWITH, STARTSWITH functions (enabled in Postgres, Snowflake libraries) [calcite]

2023-12-21 Thread via GitHub
tanclary commented on code in PR #3565: URL: https://github.com/apache/calcite/pull/3565#discussion_r1434526658 ## testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java: ## @@ -8878,51 +8878,106 @@ private void testCurrentDateFunc(Pair pair) { } @Test void

Re: [PR] [CALCITE-6156] Add ENDSWITH, STARTSWITH functions (enabled in Postgres, Snowflake libraries) [calcite]

2023-12-21 Thread via GitHub
julianhyde commented on code in PR #3565: URL: https://github.com/apache/calcite/pull/3565#discussion_r1434504495 ## testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java: ## @@ -8878,51 +8878,106 @@ private void testCurrentDateFunc(Pair pair) { } @Test

Re: [PR] [CALCITE-6165] Add DATE_SUB test and DATE_DIFF test on SqlOperatorTest [calcite]

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

Re: [PR] [CALCITE-6156] Add ENDSWITH, STARTSWITH functions (enabled in Postgres, Snowflake libraries) [calcite]

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

Re: [PR] [CALCITE-6165] Add DATE_SUB test and DATE_DIFF test on SqlOperatorTest [calcite]

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

Re: [PR] [CALCITE-6165] Add DATE_SUB test and DATE_DIFF test on SqlOperatorTest [calcite]

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

Re: [PR] [CALCITE-6165] Add DATE_SUB test and DATE_DIFF test on SqlOperatorTest [calcite]

2023-12-21 Thread via GitHub
caicancai commented on PR #3586: URL: https://github.com/apache/calcite/pull/3586#issuecomment-1866257065 @chucheng92 Regarding the failure information related to date_add(date '2011-02-24', CAST(NULL AS interval)), I will add it in the next pr. Because date_sub does not have a

(calcite-site) branch main updated: Website deployed from calcite@a816267808f2aea93ef5831783d9d7f0f3dd7d3f

2023-12-21 Thread asf-ci-deploy
This is an automated email from the ASF dual-hosted git repository. asf-ci-deploy pushed a commit to branch main in repository https://gitbox.apache.org/repos/asf/calcite-site.git The following commit(s) were added to refs/heads/main by this push: new 121010a0c Website deployed from

(calcite) branch site updated: Site: Switch PMC Chair to Benchao Li

2023-12-21 Thread github-bot
This is an automated email from the ASF dual-hosted git repository. github-bot pushed a commit to branch site in repository https://gitbox.apache.org/repos/asf/calcite.git The following commit(s) were added to refs/heads/site by this push: new 9d75a8faf8 Site: Switch PMC Chair to Benchao

(calcite) branch main updated: Site: Switch PMC Chair to Benchao Li

2023-12-21 Thread zabetak
This is an automated email from the ASF dual-hosted git repository. zabetak pushed a commit to branch main in repository https://gitbox.apache.org/repos/asf/calcite.git The following commit(s) were added to refs/heads/main by this push: new a816267808 Site: Switch PMC Chair to Benchao Li