[jira] [Comment Edited] (CALCITE-5704) Add ARRAY_EXCEPT, ARRAY_INTERSECT and ARRAY_UNION for Spark dialect

2023-05-29 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17727311#comment-17727311 ] jackylau edited comment on CALCITE-5704 at 5/30/23 3:39 AM: hi

[jira] [Commented] (CALCITE-5704) Add ARRAY_EXCEPT, ARRAY_INTERSECT and ARRAY_UNION for Spark dialect

2023-05-29 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17727311#comment-17727311 ] jackylau commented on CALCITE-5704: --- hi [~jiajunbernoulli] i response it in the pr. fix it which

[jira] [Commented] (CALCITE-5425) Should not pushdown Filter through Aggregate without group keys

2023-05-29 Thread Dan Zou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5425?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17727308#comment-17727308 ] Dan Zou commented on CALCITE-5425: -- [~julianhyde] Thanks, I have improved the summary and code

[jira] [Updated] (CALCITE-5425) Should not pushdown Filter through Aggregate without group keys

2023-05-29 Thread Dan Zou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5425?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dan Zou updated CALCITE-5425: - Summary: Should not pushdown Filter through Aggregate without group keys (was: Should not pushdown

[jira] [Updated] (CALCITE-5701) Add NAMED_STRUCT function (enabled in Spark library)

2023-05-29 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5701?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5701: Labels: pull-request-available (was: ) > Add NAMED_STRUCT function (enabled in Spark

[jira] [Commented] (CALCITE-5729) Add BYTE_LENGTH function (enabled in BigQuery library)

2023-05-29 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17727206#comment-17727206 ] Julian Hyde commented on CALCITE-5729: -- Probably corresponds to SQL standard {{OCTET_LENGTH}}. >

[jira] [Commented] (CALCITE-5730) First nulls can be dropped by EnumerableSortLimit with offset

2023-05-29 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17727205#comment-17727205 ] Julian Hyde commented on CALCITE-5730: -- [~gf2121], Can you change the description and summary to

[jira] [Updated] (CALCITE-5726) Canonize use of Hamcrest matchers in test code

2023-05-29 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5726: - Description: Canonize use of Hamcrest matchers in test code. 1. If there are multiple

[jira] [Resolved] (CALCITE-5726) Canonize use of Hamcrest matchers in test code

2023-05-29 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5726. -- Fix Version/s: 1.35.0 Resolution: Fixed Fixed in

[jira] [Assigned] (CALCITE-5726) Canonize use of Hamcrest matchers in test code

2023-05-29 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-5726: Assignee: Julian Hyde > Canonize use of Hamcrest matchers in test code >

[jira] [Commented] (CALCITE-5425) Should not pushdown filter through aggregate with an empty groupset

2023-05-29 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5425?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17727173#comment-17727173 ] Julian Hyde commented on CALCITE-5425: -- You should change some words in the summary and comments

[jira] [Commented] (CALCITE-5568) Decorrelate will fail. If the RelNode tree has LogicalValues

2023-05-29 Thread libopeng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17727115#comment-17727115 ] libopeng commented on CALCITE-5568: --- [~libenchao] [~julianhyde] Please help me review this

[jira] [Updated] (CALCITE-5568) Decorrelate will fail. If the RelNode tree has LogicalValues

2023-05-29 Thread libopeng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5568?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5568: -- Description: Decorrelate will fail. If the RelNode tree has LogicalValues case: {code:java} SELECT

[jira] [Updated] (CALCITE-5425) Should not pushdown filter through aggregate with an empty groupset

2023-05-29 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5425?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5425: Labels: pull-request-available (was: ) > Should not pushdown filter through aggregate

[jira] [Updated] (CALCITE-5730) First nulls can be dropped by EnumerableSortLimit with offset

2023-05-29 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5730: --- Summary: First nulls can be dropped by EnumerableSortLimit with offset (was: First nulls are

[jira] [Commented] (CALCITE-5730) First nulls are dropped by calcite EnumerableSortLimit Node

2023-05-29 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17727067#comment-17727067 ] Ruben Q L commented on CALCITE-5730: [~thomas.rebele] could you please help with this one? > First

[jira] [Updated] (CALCITE-5730) First nulls are dropped by calcite EnumerableSortLimit Node

2023-05-29 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5730: --- Fix Version/s: 1.35.0 > First nulls are dropped by calcite EnumerableSortLimit Node >

[jira] [Updated] (CALCITE-5730) First nulls are dropped by calcite EnumerableSortLimit Node

2023-05-29 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5730: Labels: pull-request-available (was: ) > First nulls are dropped by calcite

[jira] [Updated] (CALCITE-5599) Support more trigonometric functions for BigQuery

2023-05-29 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5599: --- Fix Version/s: 1.35.0 > Support more trigonometric functions for BigQuery >

[jira] [Resolved] (CALCITE-5599) Support more trigonometric functions for BigQuery

2023-05-29 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5599. Resolution: Fixed Resolved. Thanks to everyone that contributed in this ticket! > Support more

[jira] [Commented] (CALCITE-5599) Support more trigonometric functions for BigQuery

2023-05-29 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17727042#comment-17727042 ] Ruben Q L commented on CALCITE-5599: Ok [~FrankZou]! I will move this ticket to "resolved". >

[jira] [Updated] (CALCITE-5612) Babel parser should support PostgreSQL's SET TRANSACTION command

2023-05-29 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5612: --- Fix Version/s: 1.35.0 > Babel parser should support PostgreSQL's SET TRANSACTION

[jira] [Created] (CALCITE-5730) First nulls are dropped by calcite EnumerableSortLimit Node

2023-05-29 Thread Feng Guo (Jira)
Feng Guo created CALCITE-5730: - Summary: First nulls are dropped by calcite EnumerableSortLimit Node Key: CALCITE-5730 URL: https://issues.apache.org/jira/browse/CALCITE-5730 Project: Calcite