[jira] [Comment Edited] (CALCITE-5880) When the association condition of the association subquery is 'is not distinct from', the join condition becomes '=' after decorrelation.

2023-08-06 Thread libopeng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5880?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17751479#comment-17751479 ] libopeng edited comment on CALCITE-5880 at 8/7/23 6:42 AM: --- [

[jira] [Commented] (CALCITE-5880) When the association condition of the association subquery is 'is not distinct from', the join condition becomes '=' after decorrelation.

2023-08-06 Thread libopeng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5880?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17751479#comment-17751479 ] libopeng commented on CALCITE-5880: --- [~asolimando] Take a look at this [commit|[http

[jira] [Commented] (CALCITE-5898) Add UUID function (enabled in Presto library)

2023-08-06 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17751472#comment-17751472 ] hongyu guo commented on CALCITE-5898: - Do we need to add a UUID type as the return

[jira] [Updated] (CALCITE-5892) SnowflakeSqlDialect doesn't provide custom unparseSqlIntervalLiteral support

2023-08-06 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5892: Labels: pull-request-available (was: ) > SnowflakeSqlDialect doesn't provide custom unpa

[jira] [Commented] (CALCITE-5901) Compiler should not accept DECIMAL types with precision < scale

2023-08-06 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5901?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17751412#comment-17751412 ] Mihai Budiu commented on CALCITE-5901: -- I found this documentation for Oracle DECI

[jira] [Closed] (CALCITE-5901) Compiler should not accept DECIMAL types with precision < scale

2023-08-06 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5901?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu closed CALCITE-5901. Resolution: Not A Problem > Compiler should not accept DECIMAL types with precision < scale > ---

[jira] [Commented] (CALCITE-5901) Compiler should not accept DECIMAL types with precision < scale

2023-08-06 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5901?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17751411#comment-17751411 ] Julian Hyde commented on CALCITE-5901: -- This bug is a misreading of the standard.

[jira] [Created] (CALCITE-5902) Add DATE_TRUNC function consistent with Apache Spark

2023-08-06 Thread Jira
Guillaume Massé created CALCITE-5902: Summary: Add DATE_TRUNC function consistent with Apache Spark Key: CALCITE-5902 URL: https://issues.apache.org/jira/browse/CALCITE-5902 Project: Calcite

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

2023-08-06 Thread Jira
[ https://issues.apache.org/jira/browse/CALCITE-5290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17751408#comment-17751408 ] Guillaume Massé commented on CALCITE-5290: -- Apache Spark has a similar syntax:

[jira] [Created] (CALCITE-5901) Compiler should not accept DECIMAL types with precision < scale

2023-08-06 Thread Mihai Budiu (Jira)
Mihai Budiu created CALCITE-5901: Summary: Compiler should not accept DECIMAL types with precision < scale Key: CALCITE-5901 URL: https://issues.apache.org/jira/browse/CALCITE-5901 Project: Calcite

[jira] [Commented] (CALCITE-5681) Support authorization via GRANT and REVOKE DDL commands

2023-08-06 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5681?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17751393#comment-17751393 ] hongyu guo commented on CALCITE-5681: - Thank you for your encouragement and guidanc

[jira] [Commented] (CALCITE-5885) SqlNode#toSqlString() does not honor dialect's supportsCharSet() flag on nested types

2023-08-06 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5885?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17751368#comment-17751368 ] Jiajun Xie commented on CALCITE-5885: - Hi, [~chrisrice]  I fixed it, welcome to re