[jira] [Updated] (CALCITE-6190) Incorrect precision derivation for negative numeric types

2024-01-04 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-6190: Description: Test highlights the problem : {code:java} @Test void

[jira] [Created] (CALCITE-6190) Incorrect precision derivation for negative numeric types

2024-01-04 Thread Evgeny Stanilovsky (Jira)
Evgeny Stanilovsky created CALCITE-6190: --- Summary: Incorrect precision derivation for negative numeric types Key: CALCITE-6190 URL: https://issues.apache.org/jira/browse/CALCITE-6190 Project:

[jira] [Commented] (CALCITE-6185) Support more date format

2024-01-04 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6185?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17803420#comment-17803420 ] Caican Cai commented on CALCITE-6185: - [~julianhyde] Thank you for your reminder and reply, I will

[jira] [Updated] (CALCITE-6185) Support more date format

2024-01-04 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6185?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6185: Description: I am trying to support more date formats based on BigQuery and Postgres documents,

[jira] [Updated] (CALCITE-6189) Improve FormatElementEnumTest

2024-01-04 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6189?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6189: Labels: pull-request-available (was: ) > Improve FormatElementEnumTest >

[jira] [Created] (CALCITE-6189) Improve FormatElementEnumTest

2024-01-04 Thread Forward Xu (Jira)
Forward Xu created CALCITE-6189: --- Summary: Improve FormatElementEnumTest Key: CALCITE-6189 URL: https://issues.apache.org/jira/browse/CALCITE-6189 Project: Calcite Issue Type: Improvement

[jira] [Comment Edited] (CALCITE-6188) Multi-query optimization

2024-01-04 Thread Jay Narale (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17803376#comment-17803376 ] Jay Narale edited comment on CALCITE-6188 at 1/5/24 1:18 AM: - Not sure if

[jira] [Comment Edited] (CALCITE-6188) Multi-query optimization

2024-01-04 Thread Jay Narale (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17803376#comment-17803376 ] Jay Narale edited comment on CALCITE-6188 at 1/5/24 1:15 AM: - Not sure if

[jira] [Comment Edited] (CALCITE-6188) Multi-query optimization

2024-01-04 Thread Jay Narale (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17803376#comment-17803376 ] Jay Narale edited comment on CALCITE-6188 at 1/5/24 1:15 AM: - Not sure if

[jira] [Commented] (CALCITE-6188) Multi-query optimization

2024-01-04 Thread Jay Narale (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17803376#comment-17803376 ] Jay Narale commented on CALCITE-6188: - Not sure if it is the same but currently we treat the

[jira] [Comment Edited] (CALCITE-6186) Enable DATEDIFF for Snowflake, map to BigQuery equivalents

2024-01-04 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17803374#comment-17803374 ] Tanner Clary edited comment on CALCITE-6186 at 1/5/24 1:07 AM: --- Hey

[jira] [Commented] (CALCITE-6186) Enable DATEDIFF for Snowflake, map to BigQuery equivalents

2024-01-04 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17803374#comment-17803374 ] Tanner Clary commented on CALCITE-6186: --- Hey [~julianhyde] I added a Proof of Concept here:

[jira] [Commented] (CALCITE-6188) Multi-query optimization

2024-01-04 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17803373#comment-17803373 ] Julian Hyde commented on CALCITE-6188: -- Thank you, [~jaynarale]! The sequence node is not

[jira] [Updated] (CALCITE-6188) Multi-query optimization

2024-01-04 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6188: - Description: Devise extensions to SQL so that queries with multiple input tables, multiple

[jira] [Comment Edited] (CALCITE-6188) Multi-query optimization

2024-01-04 Thread Jay Narale (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17803368#comment-17803368 ] Jay Narale edited comment on CALCITE-6188 at 1/5/24 12:55 AM: -- We in

[jira] [Commented] (CALCITE-6188) Multi-query optimization

2024-01-04 Thread Jay Narale (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17803368#comment-17803368 ] Jay Narale commented on CALCITE-6188: - We in Presto have recently supported CTE materialization

[jira] [Created] (CALCITE-6188) Multi-query optimization

2024-01-04 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-6188: Summary: Multi-query optimization Key: CALCITE-6188 URL: https://issues.apache.org/jira/browse/CALCITE-6188 Project: Calcite Issue Type: Improvement

[jira] [Commented] (CALCITE-6186) Enable DATEDIFF for Snowflake, map to BigQuery equivalents

2024-01-04 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17803348#comment-17803348 ] Julian Hyde commented on CALCITE-6186: -- Yes, it's worth experimenting with stuff like that.

[jira] [Commented] (CALCITE-6186) Enable DATEDIFF for Snowflake, map to BigQuery equivalents

2024-01-04 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17803331#comment-17803331 ] Tanner Clary commented on CALCITE-6186: --- [~julianhyde] Yes I agree a more systematic approach

[jira] [Comment Edited] (CALCITE-6182) Add LENGTH/LEN function (enabled in Snowflake library)

2024-01-04 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6182?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17803321#comment-17803321 ] Julian Hyde edited comment on CALCITE-6182 at 1/4/24 8:53 PM: -- (I edited

[jira] [Commented] (CALCITE-6182) Add LENGTH/LEN function (enabled in Snowflake library)

2024-01-04 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6182?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17803321#comment-17803321 ] Julian Hyde commented on CALCITE-6182: -- (I edited the above message because I force-pushed to fix

[jira] [Comment Edited] (CALCITE-6182) Add LENGTH/LEN function (enabled in Snowflake library)

2024-01-04 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6182?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17802323#comment-17802323 ] Julian Hyde edited comment on CALCITE-6182 at 1/4/24 8:51 PM: -- Merged via

[jira] [Resolved] (CALCITE-6187) Linter should disallow tags such as '[MINOR]' in commit messages

2024-01-04 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-6187. -- Fix Version/s: 1.37.0 Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-6186) Enable DATEDIFF for Snowflake, map to BigQuery equivalents

2024-01-04 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17803314#comment-17803314 ] Julian Hyde commented on CALCITE-6186: -- Does this change cover incoming SQL (i.e.

[jira] [Created] (CALCITE-6187) Linter should disallow tags such as '[MINOR]' in commit messages

2024-01-04 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-6187: Summary: Linter should disallow tags such as '[MINOR]' in commit messages Key: CALCITE-6187 URL: https://issues.apache.org/jira/browse/CALCITE-6187 Project: Calcite

[jira] [Created] (CALCITE-6186) Enable DATEDIFF for Snowflake, map to BigQuery equivalents

2024-01-04 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-6186: - Summary: Enable DATEDIFF for Snowflake, map to BigQuery equivalents Key: CALCITE-6186 URL: https://issues.apache.org/jira/browse/CALCITE-6186 Project: Calcite

[jira] [Comment Edited] (CALCITE-6185) Support more date format

2024-01-04 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6185?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17803261#comment-17803261 ] Julian Hyde edited comment on CALCITE-6185 at 1/4/24 7:01 PM: -- The jira

[jira] [Comment Edited] (CALCITE-6185) Support more date format

2024-01-04 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6185?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17803261#comment-17803261 ] Julian Hyde edited comment on CALCITE-6185 at 1/4/24 6:58 PM: -- The jira

[jira] [Commented] (CALCITE-6185) Support more date format

2024-01-04 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6185?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17803261#comment-17803261 ] Julian Hyde commented on CALCITE-6185: -- The jira subject must describe the feature, i.e. what the

[jira] [Updated] (CALCITE-6185) Support more date format

2024-01-04 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6185?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6185: Labels: pull-request-available (was: ) > Support more date format >

[jira] [Created] (CALCITE-6185) Support more date format

2024-01-04 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6185: --- Summary: Support more date format Key: CALCITE-6185 URL: https://issues.apache.org/jira/browse/CALCITE-6185 Project: Calcite Issue Type: Improvement

[jira] [Comment Edited] (CALCITE-6184) Add checkNullTest on SqlOperatorTest

2024-01-04 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17802846#comment-17802846 ] Caican Cai edited comment on CALCITE-6184 at 1/4/24 10:46 AM: -- I will

[jira] [Comment Edited] (CALCITE-6184) Add checkNullTest on SqlOperatorTest

2024-01-04 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17802846#comment-17802846 ] Caican Cai edited comment on CALCITE-6184 at 1/4/24 10:35 AM: -- I will

[jira] [Updated] (CALCITE-6184) Add checkNullTest on SqlOperatorTest

2024-01-04 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6184?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6184: Labels: pull-request-available (was: ) > Add checkNullTest on SqlOperatorTest >

[jira] [Comment Edited] (CALCITE-6184) Add checkNullTest on SqlOperatorTest

2024-01-04 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17802846#comment-17802846 ] Caican Cai edited comment on CALCITE-6184 at 1/4/24 10:13 AM: -- I will

[jira] [Commented] (CALCITE-6184) Add checkNullTest on SqlOperatorTest

2024-01-04 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17802846#comment-17802846 ] Caican Cai commented on CALCITE-6184: - I will summarize and sort out those checknulls that should

[jira] [Created] (CALCITE-6184) Add checkNullTest on SqlOperatorTest

2024-01-04 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6184: --- Summary: Add checkNullTest on SqlOperatorTest Key: CALCITE-6184 URL: https://issues.apache.org/jira/browse/CALCITE-6184 Project: Calcite Issue Type: Test