[GitHub] [calcite] olivrlee commented on pull request #3168: CALCITE-5662/ Allow CAST(BOOLEAN as INTEGER)

2023-04-25 Thread via GitHub
olivrlee commented on PR #3168: URL: https://github.com/apache/calcite/pull/3168#issuecomment-1522613693 @julianhyde, commit `5d36106677b705a522dbde324c854e08e284300c` is pretty nasty, let me know if you have other suggestions. The goal was so that we have access to `conformance` in

[GitHub] [calcite] cgivre commented on pull request #3174: CALCITE-5671: Add Option to Disable SSL Certificate Validation to ES Adapter

2023-04-25 Thread via GitHub
cgivre commented on PR #3174: URL: https://github.com/apache/calcite/pull/3174#issuecomment-1522565801 @libenchao Thanks for the review. This is my first contribution to Calcite, so is there anything left for me to do to get this merged? -- This is an automated message from the Apache

[GitHub] [calcite] cgivre commented on a diff in pull request #3174: CALCITE-5671: Add Option to Disable SSL Certificate Validation to ES Adapter

2023-04-25 Thread via GitHub
cgivre commented on code in PR #3174: URL: https://github.com/apache/calcite/pull/3174#discussion_r1177173873 ## elasticsearch/src/main/java/org/apache/calcite/adapter/elasticsearch/ElasticsearchSchemaFactory.java: ## @@ -173,6 +189,16 @@ private static RestClient connect(List

[GitHub] [calcite] cgivre commented on a diff in pull request #3174: CALCITE-5671: Add Option to Disable SSL Certificate Validation to ES Adapter

2023-04-25 Thread via GitHub
cgivre commented on code in PR #3174: URL: https://github.com/apache/calcite/pull/3174#discussion_r1177173654 ## elasticsearch/src/main/java/org/apache/calcite/adapter/elasticsearch/UnsafeX509ExtendedTrustManager.java: ## @@ -0,0 +1,75 @@ +/* + * Licensed to the Apache Software

[GitHub] [calcite] cgivre commented on a diff in pull request #3174: CALCITE-5671: Add Option to Disable SSL Certificate Validation to ES Adapter

2023-04-25 Thread via GitHub
cgivre commented on code in PR #3174: URL: https://github.com/apache/calcite/pull/3174#discussion_r1177173476 ## elasticsearch/src/main/java/org/apache/calcite/adapter/elasticsearch/ElasticsearchSchemaFactory.java: ## @@ -151,18 +188,20 @@ public ElasticsearchSchemaFactory() {

[GitHub] [calcite] cgivre commented on a diff in pull request #3174: CALCITE-5671: Add Option to Disable SSL Certificate Validation to ES Adapter

2023-04-25 Thread via GitHub
cgivre commented on code in PR #3174: URL: https://github.com/apache/calcite/pull/3174#discussion_r1177173369 ## elasticsearch/src/main/java/org/apache/calcite/adapter/elasticsearch/ElasticsearchSchemaFactory.java: ## @@ -93,6 +98,27 @@ public class ElasticsearchSchemaFactory

[GitHub] [calcite] olivrlee commented on a diff in pull request #3162: CALCITE-5659/ Allow CAST in an INTERVAL literal

2023-04-25 Thread via GitHub
olivrlee commented on code in PR #3162: URL: https://github.com/apache/calcite/pull/3162#discussion_r1176990788 ## testkit/src/main/java/org/apache/calcite/sql/parser/SqlParserTest.java: ## @@ -5223,6 +5223,8 @@ private static Matcher isCharLiteral(String s) {

[GitHub] [calcite] sonarcloud[bot] commented on pull request #3175: [CALCITE-5402] RelToSql generates invalid code if left and right side field names clash

2023-04-25 Thread via GitHub
sonarcloud[bot] commented on PR #3175: URL: https://github.com/apache/calcite/pull/3175#issuecomment-1522186551 Kudos, SonarCloud Quality Gate passed! [![Quality Gate passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/passed-16px.png

[GitHub] [calcite] sonarcloud[bot] commented on pull request #3170: [CALCITE-5669] Add rule to transform correlate to join when correlation variable is unused

2023-04-25 Thread via GitHub
sonarcloud[bot] commented on PR #3170: URL: https://github.com/apache/calcite/pull/3170#issuecomment-1522102376 Kudos, SonarCloud Quality Gate passed! [![Quality Gate passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/passed-16px.png

[GitHub] [calcite] sonarcloud[bot] commented on pull request #3175: [CALCITE-5402] RelToSql generates invalid code if left and right side field names clash

2023-04-25 Thread via GitHub
sonarcloud[bot] commented on PR #3175: URL: https://github.com/apache/calcite/pull/3175#issuecomment-1522100647 Kudos, SonarCloud Quality Gate passed! [![Quality Gate passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/passed-16px.png

[GitHub] [calcite] sonarcloud[bot] commented on pull request #3176: [CALCITE-5675] Infer predicates for anti-join

2023-04-25 Thread via GitHub
sonarcloud[bot] commented on PR #3176: URL: https://github.com/apache/calcite/pull/3176#issuecomment-1521909406 Kudos, SonarCloud Quality Gate passed! [![Quality Gate passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/passed-16px.png

[GitHub] [calcite] jnturton commented on a diff in pull request #3174: CALCITE-5671: Add Option to Disable SSL Certificate Validation to ES Adapter

2023-04-25 Thread via GitHub
jnturton commented on code in PR #3174: URL: https://github.com/apache/calcite/pull/3174#discussion_r1176608199 ## elasticsearch/src/main/java/org/apache/calcite/adapter/elasticsearch/ElasticsearchSchemaFactory.java: ## @@ -93,6 +98,27 @@ public class ElasticsearchSchemaFactory

[calcite] branch main updated: [CALCITE-5639] RexSimplify should remove IS NOT NULL check when LIKE comparison is present

2023-04-25 Thread asolimando
This is an automated email from the ASF dual-hosted git repository. asolimando 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 0305067459 [CALCITE-5639] RexSimplify should

[GitHub] [calcite] asolimando merged pull request #3143: [CALCITE-5639] eliminate IS_NOT_NULL check if LIKE expression on the same column is present

2023-04-25 Thread via GitHub
asolimando merged PR #3143: URL: https://github.com/apache/calcite/pull/3143 -- 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:

[GitHub] [calcite] sonarcloud[bot] commented on pull request #3143: [CALCITE-5639] eliminate IS_NOT_NULL check if LIKE expression on the same column is present

2023-04-25 Thread via GitHub
sonarcloud[bot] commented on PR #3143: URL: https://github.com/apache/calcite/pull/3143#issuecomment-1521812880 Kudos, SonarCloud Quality Gate passed! [![Quality Gate passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/passed-16px.png

[calcite] branch main updated: [CALCITE-5670] Assertion error in SemiJoinJoinTransposeRule when Semi-Join has keys from both tables of the bottom Join

2023-04-25 Thread rubenql
This is an automated email from the ASF dual-hosted git repository. rubenql 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 cc3c5fed07 [CALCITE-5670] Assertion error in

[GitHub] [calcite] rubenada merged pull request #3172: [CALCITE-5670] Assertion error in SemiJoinJoinTransposeRule when Semi-Join has keys from both tables of the bottom Join

2023-04-25 Thread via GitHub
rubenada merged PR #3172: URL: https://github.com/apache/calcite/pull/3172 -- 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:

[GitHub] [calcite] asolimando commented on a diff in pull request #3143: [CALCITE-5639] eliminate IS_NOT_NULL check if LIKE expression on the same column is present

2023-04-25 Thread via GitHub
asolimando commented on code in PR #3143: URL: https://github.com/apache/calcite/pull/3143#discussion_r1176360488 ## core/src/main/java/org/apache/calcite/rex/RexSimplify.java: ## @@ -1793,16 +1761,53 @@ private > RexNode simplifyAnd2ForUnknownAsFalse( return

[GitHub] [calcite] libenchao commented on pull request #3161: [CALCITE-5657] Add ARRAY_DISTINCT function (enabled in Spark library).

2023-04-25 Thread via GitHub
libenchao commented on PR #3161: URL: https://github.com/apache/calcite/pull/3161#issuecomment-1521594850 @liuyongvs Since @JiajunBernoulli has started to review the PR, and he has the commit authority, I would like to defer this to him unless he is not available. -- This is an

[GitHub] [calcite] LeonidChistov commented on a diff in pull request #3143: [CALCITE-5639] eliminate IS_NOT_NULL check if LIKE expression on the same column is present

2023-04-25 Thread via GitHub
LeonidChistov commented on code in PR #3143: URL: https://github.com/apache/calcite/pull/3143#discussion_r1176334622 ## core/src/main/java/org/apache/calcite/rex/RexSimplify.java: ## @@ -1793,16 +1761,53 @@ private > RexNode simplifyAnd2ForUnknownAsFalse( return

[GitHub] [calcite] libenchao commented on pull request #3174: CALCITE-5671: Add Option to Disable SSL Certificate Validation to ES Adapter

2023-04-25 Thread via GitHub
libenchao commented on PR #3174: URL: https://github.com/apache/calcite/pull/3174#issuecomment-1521568037 > I'm using this in Drill, so once this is merged, and https://github.com/apache/drill/pull/2795 is merged, there will be end-to-end tests for this capability. This sounds

[GitHub] [calcite] sonarcloud[bot] commented on pull request #3172: [CALCITE-5670] Assertion error in SemiJoinJoinTransposeRule when Semi-Join has keys from both tables of the bottom Join

2023-04-25 Thread via GitHub
sonarcloud[bot] commented on PR #3172: URL: https://github.com/apache/calcite/pull/3172#issuecomment-1521346574 Kudos, SonarCloud Quality Gate passed! [![Quality Gate passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/passed-16px.png

[calcite] branch main updated: [CALCITE-5642] Add SHA256, SHA512 functions (enabled in BigQuery and PostgreSQL libraries)

2023-04-25 Thread rubenql
This is an automated email from the ASF dual-hosted git repository. rubenql 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 febd06b2cc [CALCITE-5642] Add SHA256, SHA512

[GitHub] [calcite] rubenada merged pull request #3148: [CALCITE-5642] Add SHA256, SHA512 functions (enabled in BigQuery and PostgreSQL libraries)

2023-04-25 Thread via GitHub
rubenada merged PR #3148: URL: https://github.com/apache/calcite/pull/3148 -- 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:

[GitHub] [calcite] sonarcloud[bot] commented on pull request #3169: [CALCITE-5665] Reducing ineffective matches for MaterializedViewRules

2023-04-25 Thread via GitHub
sonarcloud[bot] commented on PR #3169: URL: https://github.com/apache/calcite/pull/3169#issuecomment-1521309486 Kudos, SonarCloud Quality Gate passed! [![Quality Gate passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/passed-16px.png

[GitHub] [calcite] rkondakov commented on a diff in pull request #3172: [CALCITE-5670] Assertion error in SemiJoinJoinTransposeRule when Semi-Join has keys from both tables of the bottom Join

2023-04-25 Thread via GitHub
rkondakov commented on code in PR #3172: URL: https://github.com/apache/calcite/pull/3172#discussion_r1176131109 ## core/src/main/java/org/apache/calcite/rel/rules/SemiJoinJoinTransposeRule.java: ## @@ -102,16 +101,18 @@ public SemiJoinJoinTransposeRule(RelBuilderFactory

[GitHub] [calcite] asdfgh19 commented on a diff in pull request #3169: [CALCITE-5665] Reducing ineffective matches for MaterializedViewRules

2023-04-25 Thread via GitHub
asdfgh19 commented on code in PR #3169: URL: https://github.com/apache/calcite/pull/3169#discussion_r1176113352 ## core/src/main/java/org/apache/calcite/rel/rules/materialize/MaterializedViewRule.java: ## @@ -92,6 +96,16 @@ public abstract class MaterializedViewRule

[GitHub] [calcite] LeonidChistov commented on pull request #3163: [CALCITE-5402] RelToSql generates invalid code if left and right side field names clash

2023-04-25 Thread via GitHub
LeonidChistov commented on PR #3163: URL: https://github.com/apache/calcite/pull/3163#issuecomment-1521214338 @zinking I mean that old approach works wrong when field names from left hand side and right hide collide: ``` SELECT * FROM DEPT WHERE DEPTNO > 10 AND EXISTS