[jira] [Comment Edited] (CALCITE-5816) Query with LEFT SEMI JOIN should not refer to RHS columns

[ https://issues.apache.org/jira/browse/CALCITE-5816?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17739778#comment-17739778 ] hongyu guo edited comment on CALCITE-5816 at 7/4/23 3:45 AM: - Thank you for

[jira] [Commented] (CALCITE-5816) Query with LEFT SEMI JOIN should not refer to RHS columns

[ https://issues.apache.org/jira/browse/CALCITE-5816?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17739778#comment-17739778 ] hongyu guo commented on CALCITE-5816: - Thank you for helping me correct it ! I have updated the

[jira] [Updated] (CALCITE-5816) Query with LEFT SEMI JOIN should not refer to RHS columns

[ https://issues.apache.org/jira/browse/CALCITE-5816?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-5816: Summary: Query with LEFT SEMI JOIN should not refer to RHS columns (was: query with LEFT SEMI

[jira] [Updated] (CALCITE-5816) query with LEFT SEMI JOIN should not refer to RHS columns

[ https://issues.apache.org/jira/browse/CALCITE-5816?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-5816: Summary: query with LEFT SEMI JOIN should not refer to RHS columns (was: Wrong result for query

[jira] [Updated] (CALCITE-5807) Add SUBSTRING_INDEX function (enabled in Spark library)

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

[jira] [Comment Edited] (CALCITE-5798) Improve simplification of '(x < y) IS NOT TRUE' and '(x < y) IS TRUE' when x and y are not nullable

[ https://issues.apache.org/jira/browse/CALCITE-5798?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17739765#comment-17739765 ] Runkang He edited comment on CALCITE-5798 at 7/4/23 1:32 AM: - [~nobigo] I

[jira] [Commented] (CALCITE-5798) Improve simplification of '(x < y) IS NOT TRUE' and '(x < y) IS TRUE' when x and y are not nullable

[ https://issues.apache.org/jira/browse/CALCITE-5798?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17739765#comment-17739765 ] Runkang He commented on CALCITE-5798: - [~nobigo] I agree with you. One thing to add is that the PR

[jira] [Comment Edited] (CALCITE-5816) Wrong result for query with LEFT SEMI JOIN

[ https://issues.apache.org/jira/browse/CALCITE-5816?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17739675#comment-17739675 ] Julian Hyde edited comment on CALCITE-5816 at 7/3/23 4:05 PM: -- You neglect

[jira] [Commented] (CALCITE-5816) Wrong result for query with LEFT SEMI JOIN

[ https://issues.apache.org/jira/browse/CALCITE-5816?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17739675#comment-17739675 ] Julian Hyde commented on CALCITE-5816: -- You neglect to mention that LEFT SEMI JOIN syntax is only

[jira] [Commented] (CALCITE-5814) Simplify 'a = MAP[1,2] AND a = MAP[2,3]' to 'FALSE'

[ https://issues.apache.org/jira/browse/CALCITE-5814?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17739626#comment-17739626 ] Runkang He commented on CALCITE-5814: - [~jhyde] the advice is great, I will find a way that

[jira] [Updated] (CALCITE-5816) Wrong result for query with LEFT SEMI JOIN

[ https://issues.apache.org/jira/browse/CALCITE-5816?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5816: Labels: pull-request-available (was: ) > Wrong result for query with LEFT SEMI JOIN >

[jira] [Updated] (CALCITE-5816) Wrong result for query with LEFT SEMI JOIN

[ https://issues.apache.org/jira/browse/CALCITE-5816?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-5816: Description: A LEFT SEMI JOIN can only return columns from the left-hand table. But calcite also

[jira] [Updated] (CALCITE-5816) Wrong result for query with LEFT SEMI JOIN

[ https://issues.apache.org/jira/browse/CALCITE-5816?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-5816: Description: A LEFT SEMI JOIN can only return columns from the left-hand table. But calcite also

[jira] [Created] (CALCITE-5816) Wrong result for query with LEFT SEMI JOIN

hongyu guo created CALCITE-5816: --- Summary: Wrong result for query with LEFT SEMI JOIN Key: CALCITE-5816 URL: https://issues.apache.org/jira/browse/CALCITE-5816 Project: Calcite Issue Type:

[jira] [Comment Edited] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL literal

[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17739504#comment-17739504 ] Evgeny Stanilovsky edited comment on CALCITE-5708 at 7/3/23 9:04 AM:

[jira] [Commented] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL literal

[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17739504#comment-17739504 ] Evgeny Stanilovsky commented on CALCITE-5708: - [~gian] thanks for review ! i change all

[jira] [Updated] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL literal

[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-5708: Fix Version/s: 1.35.0 > Change SUBSTRING result if either of parameters is NULL

[jira] [Commented] (CALCITE-5798) Improve simplification of '(x < y) IS NOT TRUE' and '(x < y) IS TRUE' when x and y are not nullable

[ https://issues.apache.org/jira/browse/CALCITE-5798?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17739492#comment-17739492 ] xiong duan commented on CALCITE-5798: - [~Runking] Hi, I prefer  |'(1 < x) IS NOT TRUE' when x is

[jira] [Commented] (CALCITE-5711) Implement the SINGLE_VALUE aggregation in PostgreSQL Dialect

[ https://issues.apache.org/jira/browse/CALCITE-5711?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17739487#comment-17739487 ] xiong duan commented on CALCITE-5711: - Fixed in

[jira] [Resolved] (CALCITE-5711) Implement the SINGLE_VALUE aggregation in PostgreSQL Dialect

[ https://issues.apache.org/jira/browse/CALCITE-5711?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan resolved CALCITE-5711. - Resolution: Fixed > Implement the SINGLE_VALUE aggregation in PostgreSQL Dialect >

[jira] [Assigned] (CALCITE-5807) Add SUBSTRING_INDEX function (enabled in Spark library)

[ https://issues.apache.org/jira/browse/CALCITE-5807?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hujianhong reassigned CALCITE-5807: --- Assignee: hujianhong > Add SUBSTRING_INDEX function (enabled in Spark library) >

[jira] [Updated] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL literal

[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-5708: Fix Version/s: (was: 1.35.0) > Change SUBSTRING result if either of