[jira] [Commented] (CALCITE-5539) GREATEST/LEAST/COALESCE OperandTypes is not correct, which should use AT_LEAST_ONE_SAME_VARIADIC like array_concat

2023-02-24 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17693413#comment-17693413 ] Benchao Li commented on CALCITE-5539: - Agree with [~Sergey Nuyanzin], we usually suggest to

[jira] [Commented] (CALCITE-5544) SCALAR_QUERY is nested within SCALAR_QUERY, and the inner SCALAR_QUERY is an associative subquery that references a variable of the external query, sql to rel will ma

2023-02-24 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5544?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17693411#comment-17693411 ] Benchao Li commented on CALCITE-5544: - [~leepb] Is this duplicated with CALCITE-5418? >

[jira] [Updated] (CALCITE-5545) Allow for overriding SqlValidator to enable custom SqlNode validation

2023-02-24 Thread Oliver Lee (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5545?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Oliver Lee updated CALCITE-5545: Description: Goal: Be able to enable custom SqlNode validation It will require overloading

[jira] [Commented] (CALCITE-5545) Allow for overriding SqlValidator to enable custom SqlNode validation

2023-02-24 Thread Oliver Lee (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5545?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17693379#comment-17693379 ] Oliver Lee commented on CALCITE-5545: - PR: https://github.com/apache/calcite/pull/3084 > Allow for

[jira] [Updated] (CALCITE-5545) Allow for overriding SqlValidator to enable custom SqlNode validation

2023-02-24 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5545?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5545: Labels: pull-request-available (was: ) > Allow for overriding SqlValidator to enable

[jira] [Created] (CALCITE-5545) Allow for overriding SqlValidator to enable custom SqlNode validation

2023-02-24 Thread Oliver Lee (Jira)
Oliver Lee created CALCITE-5545: --- Summary: Allow for overriding SqlValidator to enable custom SqlNode validation Key: CALCITE-5545 URL: https://issues.apache.org/jira/browse/CALCITE-5545 Project:

[jira] [Commented] (CALCITE-5357) Implement BigQuery FORMAT_TIMESTAMP, FORMAT_DATE

2023-02-24 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5357?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17693342#comment-17693342 ] Julian Hyde commented on CALCITE-5357: -- Glad you approve. I'll go ahead and merge. I think you

[jira] [Comment Edited] (CALCITE-5357) Implement BigQuery FORMAT_TIMESTAMP, FORMAT_DATE

2023-02-24 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5357?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17693279#comment-17693279 ] TJ Banghart edited comment on CALCITE-5357 at 2/24/23 5:17 PM: ---

[jira] [Commented] (CALCITE-5357) Implement BigQuery FORMAT_TIMESTAMP, FORMAT_DATE

2023-02-24 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5357?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17693279#comment-17693279 ] TJ Banghart commented on CALCITE-5357: -- [~julianhyde] those changes look great - thank you for

[jira] [Updated] (CALCITE-5544) SCALAR_QUERY is nested within SCALAR_QUERY, and the inner SCALAR_QUERY is an associative subquery that references a variable of the external query, sql to rel will make

2023-02-24 Thread libopeng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5544?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5544: -- Summary: SCALAR_QUERY is nested within SCALAR_QUERY, and the inner SCALAR_QUERY is an associative

[jira] [Created] (CALCITE-5544) SCALAR_QUERY is nested within SCALAR_QUERY, and the inner SCALAR_QUERY is an associative subquery that references a variable of the external query, sql to rel will fail

2023-02-24 Thread libopeng (Jira)
libopeng created CALCITE-5544: - Summary: SCALAR_QUERY is nested within SCALAR_QUERY, and the inner SCALAR_QUERY is an associative subquery that references a variable of the external query, sql to rel will fail Key: CALCITE-5544

[jira] [Updated] (CALCITE-5544) SCALAR_QUERY is nested within SCALAR_QUERY, and the inner SCALAR_QUERY is an associative subquery that references a variable of the external query, sql to rel will fail

2023-02-24 Thread libopeng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5544?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5544: -- Description:   {code:java} SELECT     *,     (     SELECT SUM         ( (SELECT SUM ( order_amt )

[jira] [Commented] (CALCITE-5357) Implement BigQuery FORMAT_TIMESTAMP, FORMAT_DATE

2023-02-24 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5357?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17693090#comment-17693090 ] Julian Hyde commented on CALCITE-5357: -- [~tjbanghart], I have reviewed your PR 3034 and it looks