[jira] [Comment Edited] (CALCITE-5642) Add SHA256, SHA512 functions

2023-04-12 Thread Dan Zou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17711653#comment-17711653 ] Dan Zou edited comment on CALCITE-5642 at 4/13/23 3:13 AM: --- [~tanclary]

[jira] [Commented] (CALCITE-5642) Add SHA256, SHA512 functions

2023-04-12 Thread Dan Zou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17711653#comment-17711653 ] Dan Zou commented on CALCITE-5642: -- [~tanclary] Thanks for your willingness to help > Add SHA256,

[jira] [Commented] (CALCITE-5642) Add SHA256, SHA512 functions

2023-04-12 Thread Dan Zou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17711652#comment-17711652 ] Dan Zou commented on CALCITE-5642: -- [~julianhyde] IMO, these functions would not trigger any of those

[jira] [Commented] (CALCITE-5615) Run SQLLogicTests using Calcite

2023-04-12 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17711625#comment-17711625 ] Mihai Budiu commented on CALCITE-5615: -- Thank you Stamatis for your comments. # Regarding the

[jira] [Updated] (CALCITE-5644) Implement BigQuery CONTAINS_SUBSTR

2023-04-12 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5644?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5644: Labels: pull-request-available (was: ) > Implement BigQuery CONTAINS_SUBSTR >

[jira] [Updated] (CALCITE-5636) Consult type mappings when coercing types

2023-04-12 Thread Will Noble (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5636?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Will Noble updated CALCITE-5636: Summary: Consult type mappings when coercing types (was: Consult type mappings when coercing

[jira] [Commented] (CALCITE-5642) Add SHA256, SHA512 functions

2023-04-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17711519#comment-17711519 ] Julian Hyde commented on CALCITE-5642: -- There are (or used to be) export controls if software

[jira] [Commented] (CALCITE-5624) Cannot parse array function for Spark Dialect

2023-04-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17711517#comment-17711517 ] Julian Hyde commented on CALCITE-5624: -- When you revise a PR, the best think is to just add

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

2023-04-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17711506#comment-17711506 ] Julian Hyde commented on CALCITE-5639: -- It's quite possible that the Javadoc on {{class Strong}}

[jira] [Commented] (CALCITE-5644) Implement BigQuery CONTAINS_SUBSTR

2023-04-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17711504#comment-17711504 ] Julian Hyde commented on CALCITE-5644: -- The example makes it look a little more complicated than

[jira] [Commented] (CALCITE-5642) Add SHA256, SHA512 functions

2023-04-12 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17711498#comment-17711498 ] Tanner Clary commented on CALCITE-5642: --- Feel free to tag me as a reviewer once you open PR(s)

[jira] [Assigned] (CALCITE-5644) Implement BigQuery CONTAINS_SUBSTR

2023-04-12 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5644?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary reassigned CALCITE-5644: - Assignee: Tanner Clary > Implement BigQuery CONTAINS_SUBSTR >

[jira] [Updated] (CALCITE-5644) Implement BigQuery CONTAINS_SUBSTR

2023-04-12 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5644?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary updated CALCITE-5644: -- Description: BigQuery offers the

[jira] [Updated] (CALCITE-5644) Implement BigQuery CONTAINS_SUBSTR

2023-04-12 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5644?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary updated CALCITE-5644: -- Description: BigQuery offers the

[jira] [Updated] (CALCITE-5644) Implement BigQuery CONTAINS_SUBSTR

2023-04-12 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5644?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary updated CALCITE-5644: -- Description: BigQuery offers the

[jira] [Updated] (CALCITE-5644) Implement BigQuery CONTAINS_SUBSTR

2023-04-12 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5644?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary updated CALCITE-5644: -- Description: BigQuery offers the

[jira] [Updated] (CALCITE-5644) Implement BigQuery CONTAINS_SUBSTR

2023-04-12 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5644?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary updated CALCITE-5644: -- Description: BigQuery offers the

[jira] [Updated] (CALCITE-5644) Implement BigQuery CONTAINS_SUBSTR

2023-04-12 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5644?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary updated CALCITE-5644: -- Description: BigQuery offers the

[jira] [Updated] (CALCITE-5644) Implement BigQuery CONTAINS_SUBSTR

2023-04-12 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5644?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary updated CALCITE-5644: -- Description: BigQuery offers the

[jira] [Created] (CALCITE-5644) Implement BigQuery CONTAINS_SUBSTR

2023-04-12 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5644: - Summary: Implement BigQuery CONTAINS_SUBSTR Key: CALCITE-5644 URL: https://issues.apache.org/jira/browse/CALCITE-5644 Project: Calcite Issue Type: Task

[jira] [Updated] (CALCITE-5644) Implement BigQuery CONTAINS_SUBSTR

2023-04-12 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5644?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary updated CALCITE-5644: -- Description: BigQuery offers the

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

2023-04-12 Thread Leonid Chistov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17711387#comment-17711387 ] Leonid Chistov edited comment on CALCITE-5639 at 4/12/23 1:34 PM: --

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

2023-04-12 Thread Leonid Chistov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17711387#comment-17711387 ] Leonid Chistov edited comment on CALCITE-5639 at 4/12/23 1:34 PM: --

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

2023-04-12 Thread Leonid Chistov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17711387#comment-17711387 ] Leonid Chistov commented on CALCITE-5639: - [~julianhyde]  I can try to do that. After looking

[jira] [Updated] (CALCITE-5615) Run SQLLogicTests using Calcite

2023-04-12 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-5615: - Labels: pull-request-available (was: ) > Run SQLLogicTests using Calcite >

[jira] [Commented] (CALCITE-5615) Run SQLLogicTests using Calcite

2023-04-12 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17711291#comment-17711291 ] Stamatis Zampetakis commented on CALCITE-5615: -- Thanks for the PR [~mbudiu]! Some high

[jira] [Assigned] (CALCITE-5615) Run SQLLogicTests using Calcite

2023-04-12 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis reassigned CALCITE-5615: Assignee: Mihai Budiu > Run SQLLogicTests using Calcite >

[jira] [Commented] (CALCITE-5615) Run SQLLogicTests using Calcite

2023-04-12 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17711280#comment-17711280 ] LakeShen commented on CALCITE-5615: --- Hi [~mbudiu],thank you for your reply,it makes sense to me.:D >

[jira] [Updated] (CALCITE-5643) Query with CROSS JOIN UNNEST(array) executed by BigQuery adaptor isn't supported

2023-04-12 Thread Jia-Xuan Liu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5643?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jia-Xuan Liu updated CALCITE-5643: -- Description: Given a query like {code:sql} WITH tmp1 (custkey, name, orders) AS ( SELECT

[jira] [Created] (CALCITE-5643) Query with CROSS JOIN UNNEST(array) executed by BigQuery adaptor isn't supported

2023-04-12 Thread Jia-Xuan Liu (Jira)
Jia-Xuan Liu created CALCITE-5643: - Summary: Query with CROSS JOIN UNNEST(array) executed by BigQuery adaptor isn't supported Key: CALCITE-5643 URL: https://issues.apache.org/jira/browse/CALCITE-5643

[jira] [Assigned] (CALCITE-5642) Add SHA256, SHA512 functions

2023-04-12 Thread Dan Zou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5642?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dan Zou reassigned CALCITE-5642: Assignee: Dan Zou > Add SHA256, SHA512 functions > > >

[jira] [Created] (CALCITE-5642) Add SHA256, SHA512 functions

2023-04-12 Thread Dan Zou (Jira)
Dan Zou created CALCITE-5642: Summary: Add SHA256, SHA512 functions Key: CALCITE-5642 URL: https://issues.apache.org/jira/browse/CALCITE-5642 Project: Calcite Issue Type: New Feature