[jira] [Commented] (CALCITE-5634) Enable GREATEST, LEAST functions in PostgreSQL library

2024-07-01 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17861082#comment-17861082 ] xiong duan commented on CALCITE-5634: - The PostgreSQL can support: {code:java} SELE

[jira] [Resolved] (CALCITE-6325) Add LOG function (enabled in Mysql and Spark library)

2024-07-01 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan resolved CALCITE-6325. - Resolution: Fixed > Add LOG function (enabled in Mysql and Spark library) > ---

[jira] [Commented] (CALCITE-6325) Add LOG function (enabled in Mysql and Spark library)

2024-07-01 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6325?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17861085#comment-17861085 ] xiong duan commented on CALCITE-6325: - Fixed in [99799bdacb|https://github.com/apa

[jira] [Commented] (CALCITE-6450) Postgres CONCAT_WS function throws exception when parameter type is (, )

2024-07-01 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6450?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17861086#comment-17861086 ] xiong duan commented on CALCITE-6450: - [~jhonye] Hi, Yes. In Calcite this func only

[jira] [Commented] (CALCITE-6440) SortRemoveConstantKeysRule should remove NULL literal sort keys (e.g. ORDER BY NULL)

2024-07-01 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17861183#comment-17861183 ] Caican Cai commented on CALCITE-6440: - [~julianhyde] Thank you Julian for your answ

[jira] [Commented] (CALCITE-6312) Support PostgreSQL LOG

2024-07-01 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6312?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17861189#comment-17861189 ] Caican Cai commented on CALCITE-6312: - [~njordan] [~tanclary] Hi, I want to know wh

[jira] [Closed] (CALCITE-6440) SortRemoveConstantKeysRule should remove NULL literal sort keys (e.g. ORDER BY NULL)

2024-07-01 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai closed CALCITE-6440. --- Resolution: Duplicate > SortRemoveConstantKeysRule should remove NULL literal sort keys (e.g. ORDER

[jira] [Updated] (CALCITE-6451) Improve Nullability Derivation for Intersect and Minus

2024-07-01 Thread Victor Barua (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6451?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victor Barua updated CALCITE-6451: -- Description: SetOp overrides `deriveRowType()` and computes the output row type to be the le

[jira] [Created] (CALCITE-6451) Improve Nullability Derivation for Intersect and Minus

2024-07-01 Thread Victor Barua (Jira)
Victor Barua created CALCITE-6451: - Summary: Improve Nullability Derivation for Intersect and Minus Key: CALCITE-6451 URL: https://issues.apache.org/jira/browse/CALCITE-6451 Project: Calcite

[jira] [Commented] (CALCITE-6312) Support PostgreSQL LOG

2024-07-01 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6312?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17861206#comment-17861206 ] Tanner Clary commented on CALCITE-6312: --- {{Floating point error in function: LN(0

[jira] [Updated] (CALCITE-6312) Add LOG function (enabled in PostgreSQL library

2024-07-01 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6312?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6312: Summary: Add LOG function (enabled in PostgreSQL library (was: Support PostgreSQL LOG) > Add LO

[jira] [Updated] (CALCITE-6312) Add LOG function (enabled in PostgreSQL library)

2024-07-01 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6312?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6312: Summary: Add LOG function (enabled in PostgreSQL library) (was: Add LOG function (enabled in Pos

[jira] [Created] (CALCITE-6452) Scalar sub-query that uses IS NOT DISTINCT FROM returns incorrect result

2024-07-01 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-6452: Summary: Scalar sub-query that uses IS NOT DISTINCT FROM returns incorrect result Key: CALCITE-6452 URL: https://issues.apache.org/jira/browse/CALCITE-6452 Project: C

[jira] [Commented] (CALCITE-6452) Scalar sub-query that uses IS NOT DISTINCT FROM returns incorrect result

2024-07-01 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17861288#comment-17861288 ] Julian Hyde commented on CALCITE-6452: -- The [julianhyde/6452-scalar-subquery-is-n

[jira] [Assigned] (CALCITE-6452) Scalar sub-query that uses IS NOT DISTINCT FROM returns incorrect result

2024-07-01 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6452?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart reassigned CALCITE-6452: Assignee: TJ Banghart > Scalar sub-query that uses IS NOT DISTINCT FROM returns incorrec

[jira] [Commented] (CALCITE-6436) JDBC adapter generates SQL with missing round brackets when WHERE clause contains parameter

2024-07-01 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6436?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17861289#comment-17861289 ] xiong duan commented on CALCITE-6436: - [~kramerul]Hi, If you don't mind, I will tak

[jira] [Commented] (CALCITE-6436) JDBC adapter generates SQL with missing round brackets when WHERE clause contains parameter

2024-07-01 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6436?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17861326#comment-17861326 ] Ulrich Kramer commented on CALCITE-6436: [~nobigo], this would be great. Thank