[jira] [Commented] (CALCITE-5715) Prune old nodes after projection merging in ProjectMergeRule

[ https://issues.apache.org/jira/browse/CALCITE-5715?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17724488#comment-17724488 ] Benchao Li commented on CALCITE-5715: - [~julianhyde] Thanks for your comment, I've

[jira] [Updated] (CALCITE-5715) Prune old nodes after projection merging in ProjectMergeRule

[ https://issues.apache.org/jira/browse/CALCITE-5715?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li updated CALCITE-5715: Description: We already have many similar usages (prune old nodes when the new one is obviously

[jira] [Commented] (CALCITE-5695) Add MAP_KEYS and MAP_VALUES for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17724484#comment-17724484 ] jackylau commented on CALCITE-5695: --- [~jiajunbernoulli] thanks your detail review, th

[jira] [Commented] (CALCITE-5695) Add MAP_KEYS and MAP_VALUES for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17724477#comment-17724477 ] Jiajun Xie commented on CALCITE-5695: - If there are no other suggestions, I will me

[jira] [Updated] (CALCITE-5715) Prune old nodes after projection merging in ProjectMergeRule

[ https://issues.apache.org/jira/browse/CALCITE-5715?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li updated CALCITE-5715: Description: We already have many similar usages (prune old nodes) to reduce the search scope, I

[jira] [Updated] (CALCITE-5715) Prune old nodes after projection merging in ProjectMergeRule

[ https://issues.apache.org/jira/browse/CALCITE-5715?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li updated CALCITE-5715: Summary: Prune old nodes after projection merging in ProjectMergeRule (was: Prune old nodes afte

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

[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5708: Labels: patch-available pull-request-available (was: patch-available) > Change SUBSTRING

[jira] [Created] (CALCITE-5716) Two level nested correlated subquery translates to incorrect ON condition

John Wright created CALCITE-5716: Summary: Two level nested correlated subquery translates to incorrect ON condition Key: CALCITE-5716 URL: https://issues.apache.org/jira/browse/CALCITE-5716 Project:

[jira] [Commented] (CALCITE-5713) SqlBasicCall's Deep Copy Logic Raises Rule Optimization Exception

[ https://issues.apache.org/jira/browse/CALCITE-5713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17724452#comment-17724452 ] Guoliang Sun commented on CALCITE-5713: --- Yes, you didn't misunderstand, the main

[jira] [Commented] (CALCITE-5713) SqlBasicCall's Deep Copy Logic Raises Rule Optimization Exception

[ https://issues.apache.org/jira/browse/CALCITE-5713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17724428#comment-17724428 ] Julian Hyde commented on CALCITE-5713: -- Your 'fix' seems to be to revert to the ol

[jira] [Commented] (CALCITE-5715) Prune old nodes after projection merging in ProjectionMergeRule

[ https://issues.apache.org/jira/browse/CALCITE-5715?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17724427#comment-17724427 ] Julian Hyde commented on CALCITE-5715: -- What do you mean by 'prune old nodes'? (So

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

[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17724423#comment-17724423 ] Julian Hyde edited comment on CALCITE-5708 at 5/19/23 9:54 PM: --

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

[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17724423#comment-17724423 ] Julian Hyde commented on CALCITE-5708: -- I wouldn't call it coercion exactly. SQL h

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

[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17724354#comment-17724354 ] Evgeny Stanilovsky commented on CALCITE-5708: - It`s work due to type coerci

[jira] [Commented] (CALCITE-5715) Prune old nodes after projection merging in ProjectionMergeRule

[ https://issues.apache.org/jira/browse/CALCITE-5715?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17724251#comment-17724251 ] Benchao Li commented on CALCITE-5715: - All existing tests pass after this change:

[jira] [Created] (CALCITE-5715) Prune old nodes after projection merging in ProjectionMergeRule

Benchao Li created CALCITE-5715: --- Summary: Prune old nodes after projection merging in ProjectionMergeRule Key: CALCITE-5715 URL: https://issues.apache.org/jira/browse/CALCITE-5715 Project: Calcite

[jira] [Commented] (CALCITE-5714) Add MAP_ENTRIES for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5714?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17724205#comment-17724205 ] jackylau commented on CALCITE-5714: --- comments: 1. according to this talk, https://is

[jira] [Updated] (CALCITE-5714) Add MAP_ENTRIES for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5714?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5714: -- Description: MAP_ENTRIES - Returns an unordered array of all entries in the given map. For more deta

[jira] [Created] (CALCITE-5714) Add MAP_ENTRIES for Spark dialect

jackylau created CALCITE-5714: - Summary: Add MAP_ENTRIES for Spark dialect Key: CALCITE-5714 URL: https://issues.apache.org/jira/browse/CALCITE-5714 Project: Calcite Issue Type: Improvement

[jira] [Updated] (CALCITE-5714) Add MAP_ENTRIES for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5714?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5714: -- Description: {{ARRAY_DISTINCT}} - Returns the input ARRAY with unique elements. If the array itself

[jira] [Commented] (CALCITE-5713) SqlBasicCall's Deep Copy Logic Raises Rule Optimization Exception

[ https://issues.apache.org/jira/browse/CALCITE-5713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17724169#comment-17724169 ] Guoliang Sun commented on CALCITE-5713: --- Please review this for me [~julianhyde],

[jira] [Commented] (CALCITE-5713) SqlBasicCall's Deep Copy Logic Raises Rule Optimization Exception

[ https://issues.apache.org/jira/browse/CALCITE-5713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17724163#comment-17724163 ] Guoliang Sun commented on CALCITE-5713: --- Take the above SQL as an example * befor

[jira] [Updated] (CALCITE-5712) FilterableTable with Kotlin coroutine(kotest) and logback fails: RelSubset ... has wrong best cost

[ https://issues.apache.org/jira/browse/CALCITE-5712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Min-Seok Kim updated CALCITE-5712: -- Summary: FilterableTable with Kotlin coroutine(kotest) and logback fails: RelSubset ... has

[jira] [Updated] (CALCITE-5712) FilterableTable with Kotlin coroutine(kotest) and logback fails.

[ https://issues.apache.org/jira/browse/CALCITE-5712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Min-Seok Kim updated CALCITE-5712: -- Description: The MyFilterableTable class is not functioning properly when used in conjunctio

[jira] [Commented] (CALCITE-5713) SqlBasicCall's Deep Copy Logic Raises Rule Optimization Exception

[ https://issues.apache.org/jira/browse/CALCITE-5713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17724160#comment-17724160 ] Guoliang Sun commented on CALCITE-5713: --- I have raised a PR in https://github.com

[jira] [Updated] (CALCITE-5712) FilterableTable with Kotlin coroutine(kotest) and logback fails.

[ https://issues.apache.org/jira/browse/CALCITE-5712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Min-Seok Kim updated CALCITE-5712: -- Attachment: (was: image-2023-05-19-16-08-24-243.png) > FilterableTable with Kotlin corout

[jira] [Updated] (CALCITE-5712) FilterableTable with Kotlin coroutine(kotest) and logback fails.

[ https://issues.apache.org/jira/browse/CALCITE-5712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Min-Seok Kim updated CALCITE-5712: -- Attachment: (was: image-2023-05-19-16-08-16-411.png) > FilterableTable with Kotlin corout

[jira] [Updated] (CALCITE-5712) FilterableTable with Kotlin coroutine(kotest) and logback fails.

[ https://issues.apache.org/jira/browse/CALCITE-5712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Min-Seok Kim updated CALCITE-5712: -- Attachment: image-2023-05-19-16-09-28-894.png > FilterableTable with Kotlin coroutine(kotest)

[jira] [Updated] (CALCITE-5712) FilterableTable with Kotlin coroutine(kotest) and logback fails.

[ https://issues.apache.org/jira/browse/CALCITE-5712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Min-Seok Kim updated CALCITE-5712: -- Description: The MyFilterableTable class is not functioning properly when used in conjunctio

[jira] [Updated] (CALCITE-5712) FilterableTable with Kotlin coroutine(kotest) and logback fails.

[ https://issues.apache.org/jira/browse/CALCITE-5712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Min-Seok Kim updated CALCITE-5712: -- Attachment: (was: image-2023-05-19-16-08-36-456.png) > FilterableTable with Kotlin corout

[jira] [Updated] (CALCITE-5712) FilterableTable with Kotlin coroutine(kotest) and logback fails.

[ https://issues.apache.org/jira/browse/CALCITE-5712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Min-Seok Kim updated CALCITE-5712: -- Attachment: image-2023-05-19-16-08-24-243.png > FilterableTable with Kotlin coroutine(kotest)

[jira] [Updated] (CALCITE-5712) FilterableTable with Kotlin coroutine(kotest) and logback fails.

[ https://issues.apache.org/jira/browse/CALCITE-5712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Min-Seok Kim updated CALCITE-5712: -- Attachment: image-2023-05-19-16-08-36-456.png > FilterableTable with Kotlin coroutine(kotest)

[jira] [Updated] (CALCITE-5712) FilterableTable with Kotlin coroutine(kotest) and logback fails.

[ https://issues.apache.org/jira/browse/CALCITE-5712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Min-Seok Kim updated CALCITE-5712: -- Attachment: image-2023-05-19-16-08-16-411.png > FilterableTable with Kotlin coroutine(kotest)

[jira] [Updated] (CALCITE-5712) FilterableTable with Kotlin coroutine(kotest) and logback fails.

[ https://issues.apache.org/jira/browse/CALCITE-5712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Min-Seok Kim updated CALCITE-5712: -- Description: The MyFilterableTable class is not functioning properly when used in conjunctio

[jira] [Updated] (CALCITE-5712) FilterableTable with Kotlin coroutine(kotest) and logback fails.

[ https://issues.apache.org/jira/browse/CALCITE-5712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Min-Seok Kim updated CALCITE-5712: -- Description: The MyFilterableTable class is not functioning properly when used in conjunctio

[jira] [Created] (CALCITE-5713) SqlBasicCall's Deep Copy Logic Raises Rule Optimization Exception

Guoliang Sun created CALCITE-5713: - Summary: SqlBasicCall's Deep Copy Logic Raises Rule Optimization Exception Key: CALCITE-5713 URL: https://issues.apache.org/jira/browse/CALCITE-5713 Project: Calcit

[jira] [Updated] (CALCITE-5712) FilterableTable with Kotlin coroutine and logback fails.

[ https://issues.apache.org/jira/browse/CALCITE-5712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Min-Seok Kim updated CALCITE-5712: -- Description: The MyFilterableTable class is not functioning properly when used in conjunctio

[jira] [Updated] (CALCITE-5712) FilterableTable with Kotlin coroutine(kotest) and logback fails.

[ https://issues.apache.org/jira/browse/CALCITE-5712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Min-Seok Kim updated CALCITE-5712: -- Summary: FilterableTable with Kotlin coroutine(kotest) and logback fails. (was: FilterableTa