[jira] [Assigned] (CALCITE-5546) Code style: Break long assignment expressions after '='

2023-02-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-5546: Assignee: Julian Hyde > Code style: Break long assignment expressions after '=' > --

[jira] [Commented] (CALCITE-111) Support CONVERT function, for changing character sets

2023-02-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-111?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17694884#comment-17694884 ] Julian Hyde commented on CALCITE-111: - [~VAE], I just reviewed, rebased and fixed up

[jira] [Updated] (CALCITE-111) Support CONVERT function, for changing character sets

2023-02-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-111?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-111: Fix Version/s: 1.34.0 > Support CONVERT function, for changing character sets > --

[jira] [Updated] (CALCITE-111) Support CONVERT function, for changing character sets

2023-02-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-111?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-111: Description: Support the CONVERT function, to convert strings from one character set to another.

[jira] [Resolved] (CALCITE-5546) Code style: Break long assignment expressions after '='

2023-02-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5546. -- Fix Version/s: 1.34.0 Resolution: Fixed Fixed in [2dba40e7|https://github.com/apache/

[jira] [Updated] (CALCITE-4326) NullPointerException possible in EnumerableWindow when agg.call.name is null

2023-02-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4326?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4326: - Summary: NullPointerException possible in EnumerableWindow when agg.call.name is null (was: NP

[jira] [Commented] (CALCITE-2989) Use ISO-8601 calendar when converting between java.sql types and UNIX timestamps

2023-02-28 Thread John Wright (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2989?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17694789#comment-17694789 ] John Wright commented on CALCITE-2989: -- Sorry, my comment got written before I cou

[jira] [Commented] (CALCITE-2989) Use ISO-8601 calendar when converting between java.sql types and UNIX timestamps

2023-02-28 Thread John Wright (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2989?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17694787#comment-17694787 ] John Wright commented on CALCITE-2989: -- [~freastro] , I see in java.util.Date#Date

[jira] [Updated] (CALCITE-5476) Add DATETIME_TRUNC for BigQuery

2023-02-28 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5476?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5476: Labels: pull-request-available (was: ) > Add DATETIME_TRUNC for BigQuery > -

[jira] [Assigned] (CALCITE-5290) Add DATE_TRUNC function consistent with Postgres

2023-02-28 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5290?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart reassigned CALCITE-5290: Assignee: TJ Banghart > Add DATE_TRUNC function consistent with Postgres > -

[jira] [Commented] (CALCITE-2989) Use ISO-8601 calendar when converting between java.sql types and UNIX timestamps

2023-02-28 Thread Gregory Hart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2989?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17694771#comment-17694771 ] Gregory Hart commented on CALCITE-2989: --- [~jdw], do you have any suggestions? The

[jira] [Commented] (CALCITE-2989) Use ISO-8601 calendar when converting between java.sql types and UNIX timestamps

2023-02-28 Thread John Wright (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2989?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17694764#comment-17694764 ] John Wright commented on CALCITE-2989: -- [~freastro] we have legacy dates represent

[jira] [Commented] (CALCITE-5548) Add support for MSSQL CONVERT function

2023-02-28 Thread Askar Bozcan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5548?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17694725#comment-17694725 ] Askar Bozcan commented on CALCITE-5548: --- (y) I have a question though (as I have

[jira] [Updated] (CALCITE-5548) Add support for MSSQL CONVERT function

2023-02-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5548?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5548: - Description: Add support for MSSQL CONVERT function (which is the same as CAST, with optional

[jira] [Commented] (CALCITE-5548) Add support for MSSQL CONVERT function

2023-02-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5548?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17694722#comment-17694722 ] Julian Hyde commented on CALCITE-5548: -- I agree that we should do it. You'll have

[jira] [Updated] (CALCITE-5548) Add support for MSSQL CONVERT function

2023-02-28 Thread Askar Bozcan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5548?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Askar Bozcan updated CALCITE-5548: -- Description: Add support for MSSQL CONVERT function (which is the same as CAST, with optiona

[jira] [Updated] (CALCITE-5516) RelOptRulesTest AggregateReduceFunctionsRule optimized plan not semantically equivalent to the original one after conversion

2023-02-28 Thread James Starr (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5516?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Starr updated CALCITE-5516: - Description: After converting the "plan before" and "plan after" of testReduceWithNonTypePredi

[jira] [Commented] (CALCITE-5517) Nested (correlated) subqueries fail at validation | No SELECT scope for inner subquery

2023-02-28 Thread James Starr (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5517?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17694700#comment-17694700 ] James Starr commented on CALCITE-5517: -- How is this a nested correlated sub-query?

[jira] [Updated] (CALCITE-5517) Nested (correlated) subqueries fail at validation | No SELECT scope for inner subquery

2023-02-28 Thread James Starr (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5517?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Starr updated CALCITE-5517: - Description: Testing with TPC-H Query 2 for reference: {code:sql} SELECT FIRST 100 s_acctbal, s

[jira] [Updated] (CALCITE-5517) Nested (correlated) subqueries fail at validation | No SELECT scope for inner subquery

2023-02-28 Thread James Starr (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5517?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Starr updated CALCITE-5517: - Description: Testing with TPC-H Query 2 for reference: {code:sql} SELECT FIRST 100 s_acctbal, s

[jira] [Commented] (CALCITE-5548) Add support for MSSQL CONVERT function

2023-02-28 Thread Askar Bozcan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5548?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17694676#comment-17694676 ] Askar Bozcan commented on CALCITE-5548: --- I had some questions however, as this is

[jira] [Updated] (CALCITE-5548) Add support for MSSQL CONVERT function

2023-02-28 Thread Askar Bozcan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5548?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Askar Bozcan updated CALCITE-5548: -- Description: Add support for CONVERT function (which is the same as CAST, with optional form

[jira] [Assigned] (CALCITE-5548) Add support for MSSQL CONVERT function

2023-02-28 Thread Askar Bozcan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5548?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Askar Bozcan reassigned CALCITE-5548: - Assignee: Askar Bozcan > Add support for MSSQL CONVERT function >

[jira] [Created] (CALCITE-5548) Add support for MSSQL CONVERT function

2023-02-28 Thread Askar Bozcan (Jira)
Askar Bozcan created CALCITE-5548: - Summary: Add support for MSSQL CONVERT function Key: CALCITE-5548 URL: https://issues.apache.org/jira/browse/CALCITE-5548 Project: Calcite Issue Type: Impr

[jira] [Updated] (CALCITE-5367) Implement missing spatial type functions

2023-02-28 Thread Bertil Chapuis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5367?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bertil Chapuis updated CALCITE-5367: Description: The following spatial type functions are yet to be implemented: * ST_AddPoi

[jira] [Updated] (CALCITE-5367) Implement missing spatial type functions

2023-02-28 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5367?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5367: Labels: pull-request-available (was: ) > Implement missing spatial type functions >

[jira] [Updated] (CALCITE-5367) Implement missing spatial type functions

2023-02-28 Thread Bertil Chapuis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5367?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bertil Chapuis updated CALCITE-5367: Summary: Implement missing spatial type functions (was: Implement geometry editing funct