[jira] [Commented] (CALCITE-5483) ProjectAggregateMergeRule throws exception if literal is non-numeric

2023-01-19 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17679016#comment-17679016 ] Benchao Li commented on CALCITE-5483: - The new [PR|https://github.com/apache/calcite/pull/3038] is

[jira] [Commented] (CALCITE-5483) ProjectAggregateMergeRule throws exception if literal is non-numeric

2023-01-19 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17678985#comment-17678985 ] Benchao Li commented on CALCITE-5483: - [~birschick] I'll continue your work and finish it. Thanks

[jira] [Resolved] (CALCITE-5466) Constant condition can't be reduced after correlate

2023-01-19 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li resolved CALCITE-5466. - Fix Version/s: 1.33.0 Resolution: Fixed Fixed via

[jira] [Updated] (CALCITE-5486) Subquery not support HAVING alias in condition

2023-01-19 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5486?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5486: Summary: Subquery not support HAVING alias in condition (was: Subquery not support having alias

[jira] [Updated] (CALCITE-5486) Subquery not support having alias in condition

2023-01-19 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5486?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5486: Description: Spark can allow HAVING alias in condition. We also should allow HAVING alias in

[jira] [Commented] (CALCITE-5446) Support TIMESTAMP WITH LOCAL TIME ZONE type in JDBC driver

2023-01-19 Thread Oliver Lee (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5446?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17678956#comment-17678956 ] Oliver Lee commented on CALCITE-5446: - (Continuing separating out changes from [PR

[jira] [Comment Edited] (CALCITE-5446) Support TIMESTAMP WITH LOCAL TIME ZONE type in JDBC driver

2023-01-19 Thread Oliver Lee (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5446?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17678956#comment-17678956 ] Oliver Lee edited comment on CALCITE-5446 at 1/20/23 2:13 AM: -- (Continuing

[jira] [Comment Edited] (CALCITE-5446) Support TIMESTAMP WITH LOCAL TIME ZONE type in JDBC driver

2023-01-19 Thread Oliver Lee (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5446?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17678956#comment-17678956 ] Oliver Lee edited comment on CALCITE-5446 at 1/20/23 2:13 AM: -- (Continuing

[jira] [Commented] (CALCITE-5424) Customize handling of literals based on type system

2023-01-19 Thread Oliver Lee (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5424?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17678954#comment-17678954 ] Oliver Lee commented on CALCITE-5424: - I have been working on separating PR 3023 into contained

[jira] [Comment Edited] (CALCITE-5424) Customize handling of literals based on type system

2023-01-19 Thread Oliver Lee (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5424?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17678954#comment-17678954 ] Oliver Lee edited comment on CALCITE-5424 at 1/20/23 2:04 AM: -- I have been

[jira] [Updated] (CALCITE-5465) Rule of AGGREGATE_EXPAND_DISTINCT_AGGREGATES transforms wrong plan, when sql has distinct agg-call with rollup

2023-01-19 Thread Xurenhe (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xurenhe updated CALCITE-5465: - Description: The rule _*AGGREGATE_EXPAND_DISTINCT_AGGREGATES*_ transform wrong plan, when the sql is

[jira] [Created] (CALCITE-5488) Calcite double-adjusts timestamps when calling Array.getResultSet()

2023-01-19 Thread Will Noble (Jira)
Will Noble created CALCITE-5488: --- Summary: Calcite double-adjusts timestamps when calling Array.getResultSet() Key: CALCITE-5488 URL: https://issues.apache.org/jira/browse/CALCITE-5488 Project: Calcite

[jira] [Assigned] (CALCITE-5488) Calcite double-adjusts timestamps when calling Array.getResultSet()

2023-01-19 Thread Will Noble (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5488?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Will Noble reassigned CALCITE-5488: --- Assignee: Will Noble > Calcite double-adjusts timestamps when calling

[jira] [Updated] (CALCITE-5424) Customize handling of literals based on type system

2023-01-19 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5424?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5424: Labels: pull-request-available (was: ) > Customize handling of literals based on type

[jira] [Commented] (CALCITE-5486) Subquery not support having alias in condition

2023-01-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5486?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17678921#comment-17678921 ] Julian Hyde commented on CALCITE-5486: -- Remember to capitalize SQL keywords (e.g. HAVING) in bug

[jira] [Commented] (CALCITE-5120) UnregisteredDriver#connect should throw SQLException, not NullPointerException, if url is null

2023-01-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17678920#comment-17678920 ] Julian Hyde commented on CALCITE-5120: -- [~FrankZou], OK, thanks, I added you to the [release

[jira] [Closed] (CALCITE-4651) Try to get the SPENGO specific Jetty fixes/overrides in Avatica into Jetty

2023-01-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4651?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde closed CALCITE-4651. Closing on release of avatica-1.23.0 (2023-01-19) > Try to get the SPENGO specific Jetty

[jira] [Closed] (CALCITE-5189) Add support for constant HTTP path prefixes to Avatica server

2023-01-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5189?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde closed CALCITE-5189. Closing on release of avatica-1.23.0 (2023-01-19) > Add support for constant HTTP path prefixes to

[jira] [Closed] (CALCITE-5463) Revert removing usage of SqlValidator.deriveAlias

2023-01-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde closed CALCITE-5463. Closing on release of avatica-1.23.0 (2023-01-19) > Revert removing usage of

[jira] [Closed] (CALCITE-5379) Upgrade protobuf version to 3.21.9 because of CVE

2023-01-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5379?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde closed CALCITE-5379. Resolved in release avatica-1.23.0 (2023-01-19) > Upgrade protobuf version to 3.21.9 because of CVE

[jira] [Reopened] (CALCITE-5379) Upgrade protobuf version to 3.21.9 because of CVE

2023-01-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5379?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reopened CALCITE-5379: -- > Upgrade protobuf version to 3.21.9 because of CVE >

[jira] [Resolved] (CALCITE-5379) Upgrade protobuf version to 3.21.9 because of CVE

2023-01-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5379?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5379. -- Resolution: Fixed > Upgrade protobuf version to 3.21.9 because of CVE >

[jira] [Updated] (CALCITE-5136) Avatica build (or CI) must fail if there are deprecation warnings

2023-01-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5136?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5136: - Fix Version/s: (was: avatica-1.23.0) > Avatica build (or CI) must fail if there are

[jira] [Resolved] (CALCITE-5480) Release Avatica 1.23.0

2023-01-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5480?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5480. -- Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-5487) Avatica Result Sets do not properly handle TIMESTAMP WITH LOCAL TIME ZONE

2023-01-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5487?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17678869#comment-17678869 ] Julian Hyde commented on CALCITE-5487: -- Is string the right representation? If {{TIMESTAMP}} is

[jira] [Commented] (CALCITE-5483) ProjectAggregateMergeRule throws exception if literal is non-numeric

2023-01-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17678866#comment-17678866 ] Julian Hyde commented on CALCITE-5483: -- [~birschick], That makes sense. Thanks for what you've

[jira] [Updated] (CALCITE-5487) Avatica Result Sets do not properly handle TIMESTAMP WITH LOCAL TIME ZONE

2023-01-19 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5487?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5487: Labels: pull-request-available (was: ) > Avatica Result Sets do not properly handle

[jira] [Created] (CALCITE-5487) Avatica Result Sets do not properly handle TIMESTAMP WITH LOCAL TIME ZONE

2023-01-19 Thread Will Noble (Jira)
Will Noble created CALCITE-5487: --- Summary: Avatica Result Sets do not properly handle TIMESTAMP WITH LOCAL TIME ZONE Key: CALCITE-5487 URL: https://issues.apache.org/jira/browse/CALCITE-5487 Project:

[jira] [Updated] (CALCITE-5424) Customize handling of literals based on type system

2023-01-19 Thread Oliver Lee (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5424?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Oliver Lee updated CALCITE-5424: Description: Currently if you write {{TIMESTAMP '1969-07-20 22:56:00'}}  it will be converted

[jira] [Commented] (CALCITE-5483) ProjectAggregateMergeRule throws exception if literal is non-numeric

2023-01-19 Thread Bruce Irschick (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17678851#comment-17678851 ] Bruce Irschick commented on CALCITE-5483: - [~julianhyde] - So, I'm afraid I'm not enough of an

[jira] [Commented] (CALCITE-5283) Add ARG_MIN, ARG_MAX (aka MIN_BY, MAX_BY) aggregate functions

2023-01-19 Thread Zou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5283?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17678685#comment-17678685 ] Zou commented on CALCITE-5283: -- [~julianhyde]The PR is updated, please have a look. > Add ARG_MIN,

[jira] [Updated] (CALCITE-5486) Subquery not support having alias in condition

2023-01-19 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5486?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5486: Summary: Subquery not support having alias in condition (was: Subquery not support having alias

[jira] [Created] (CALCITE-5486) Subquery not support having alias in condition.

2023-01-19 Thread Jiajun Xie (Jira)
Jiajun Xie created CALCITE-5486: --- Summary: Subquery not support having alias in condition. Key: CALCITE-5486 URL: https://issues.apache.org/jira/browse/CALCITE-5486 Project: Calcite Issue

[jira] [Commented] (CALCITE-5466) Constant condition can't be reduced after correlate

2023-01-19 Thread Aitozi (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5466?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17678547#comment-17678547 ] Aitozi commented on CALCITE-5466: - I have opened a PR for this, I would appreciate if anyone can help