[jira] [Commented] (CALCITE-6242) The "exists" library function throws a "param not found" error when a column is used in lambda evaluation logic.

[ https://issues.apache.org/jira/browse/CALCITE-6242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17872186#comment-17872186 ] hongyu guo commented on CALCITE-6242: - [~eveywu] Welcome to contribute! You can ass

[jira] [Commented] (CALCITE-6242) The "exists" library function throws a "param not found" error when a column is used in lambda evaluation logic.

[ https://issues.apache.org/jira/browse/CALCITE-6242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17872181#comment-17872181 ] EveyWu commented on CALCITE-6242: -- [~hongyuguo] Hi~ if you don't mind, I would like t

[jira] [Comment Edited] (CALCITE-6521) CROSS JOIN UNNEST The results do not match expectations.

[ https://issues.apache.org/jira/browse/CALCITE-6521?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17872166#comment-17872166 ] EveyWu edited comment on CALCITE-6521 at 8/9/24 1:30 AM: -- [~j

[jira] [Commented] (CALCITE-6521) CROSS JOIN UNNEST The results do not match expectations.

[ https://issues.apache.org/jira/browse/CALCITE-6521?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17872166#comment-17872166 ] EveyWu commented on CALCITE-6521: -- [~julianhyde] Thanks for reply, I found that the a

[jira] [Updated] (CALCITE-6521) CROSS JOIN UNNEST The results do not match expectations.

[ https://issues.apache.org/jira/browse/CALCITE-6521?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6521: Description: {code:java} SELECT n, a FROM ( VALUES (ARRAY[2, 5], ARRAY['dog', 'cat', 'bird']),

[jira] [Updated] (CALCITE-6521) CROSS JOIN UNNEST The results do not match expectations.

[ https://issues.apache.org/jira/browse/CALCITE-6521?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6521: Description: {code:java} SELECT n, a FROM ( VALUES (ARRAY[2, 5], ARRAY['dog', 'cat', 'bird']),

[jira] [Updated] (CALCITE-6517) “calcite-mongodb” can not close MongoClient, and thread will be leaked

[ https://issues.apache.org/jira/browse/CALCITE-6517?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6517: - Component/s: mongodb-adapter > “calcite-mongodb” can not close MongoClient, and thread will be

[jira] [Updated] (CALCITE-6508) Parse error when using scalar sub-query as operant to Array constructor function

[ https://issues.apache.org/jira/browse/CALCITE-6508?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6508: Labels: pull-request-available (was: ) > Parse error when using scalar sub-query as oper

[jira] [Commented] (CALCITE-6508) Parse error when using scalar sub-query as operant to Array constructor function

[ https://issues.apache.org/jira/browse/CALCITE-6508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17872160#comment-17872160 ] Ian Bertolacci commented on CALCITE-6508: - PR up. > Parse error when using sca

[jira] [Commented] (CALCITE-6521) CROSS JOIN UNNEST The results do not match expectations.

[ https://issues.apache.org/jira/browse/CALCITE-6521?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17872158#comment-17872158 ] Julian Hyde commented on CALCITE-6521: -- Can you replace the image with text? Also,

[jira] [Commented] (CALCITE-6508) Parse error when using scalar sub-query as operant to Array constructor function

[ https://issues.apache.org/jira/browse/CALCITE-6508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17872146#comment-17872146 ] Ian Bertolacci commented on CALCITE-6508: - Yes. > Parse error when using scala

[jira] [Assigned] (CALCITE-6508) Parse error when using scalar sub-query as operant to Array constructor function

[ https://issues.apache.org/jira/browse/CALCITE-6508?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Bertolacci reassigned CALCITE-6508: --- Assignee: Ian Bertolacci > Parse error when using scalar sub-query as operant to A

[jira] [Commented] (CALCITE-6508) Parse error when using scalar sub-query as operant to Array constructor function

[ https://issues.apache.org/jira/browse/CALCITE-6508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17872145#comment-17872145 ] Mihai Budiu commented on CALCITE-6508: -- Do you plan to contribute this improvement

[jira] [Commented] (CALCITE-6508) Parse error when using scalar sub-query as operant to Array constructor function

[ https://issues.apache.org/jira/browse/CALCITE-6508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17872144#comment-17872144 ] Ian Bertolacci commented on CALCITE-6508: - We extended the parser to use {{`Exp

[jira] [Comment Edited] (CALCITE-6508) Parse error when using scalar sub-query as operant to Array constructor function

[ https://issues.apache.org/jira/browse/CALCITE-6508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17872144#comment-17872144 ] Ian Bertolacci edited comment on CALCITE-6508 at 8/8/24 10:02 PM: ---

[jira] [Updated] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Bertolacci updated CALCITE-5213: Affects Version/s: 1.36.0 > PROJECT_TO_SUBQUERY producing Incorrect tree from nested corr

[jira] [Commented] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17872090#comment-17872090 ] Ian Bertolacci commented on CALCITE-5213: - [~libenchao] this does not appear to

[jira] [Updated] (CALCITE-6522) MAP_KEYS and MAP_VALUES function should throw if a key value is null

[ https://issues.apache.org/jira/browse/CALCITE-6522?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6522: Description: scala> val df = spark.sql("select map_keys(map(null,0))"); df: org.apache.spark.sql.

[jira] [Updated] (CALCITE-6522) MAP_KEYS and MAP_VALUES function should throw if a key value is null

[ https://issues.apache.org/jira/browse/CALCITE-6522?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6522: Description: scala> val df = spark.sql("select map_keys(map(null,0))"); df: org.apache.spark.sql.

[jira] [Created] (CALCITE-6522) MAP_KEYS and MAP_VALUES function should throw if a key value is null

Caican Cai created CALCITE-6522: --- Summary: MAP_KEYS and MAP_VALUES function should throw if a key value is null Key: CALCITE-6522 URL: https://issues.apache.org/jira/browse/CALCITE-6522 Project: Calci

[jira] [Assigned] (CALCITE-6522) MAP_KEYS and MAP_VALUES function should throw if a key value is null

[ https://issues.apache.org/jira/browse/CALCITE-6522?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai reassigned CALCITE-6522: --- Assignee: Caican Cai > MAP_KEYS and MAP_VALUES function should throw if a key value is n

[jira] [Updated] (CALCITE-6522) MAP_KEYS and MAP_VALUES function should throw if a key value is null

[ https://issues.apache.org/jira/browse/CALCITE-6522?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6522: Labels: pull-request-available (was: ) > MAP_KEYS and MAP_VALUES function should throw

[jira] [Resolved] (CALCITE-6519) Non-aggregate query that uses measure in ORDER BY

[ https://issues.apache.org/jira/browse/CALCITE-6519?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-6519. -- Fix Version/s: 1.38.0 Resolution: Fixed Fixed in [27fd5830|https://github.com/apache/

[jira] [Resolved] (CALCITE-6513) FilterProjectTransposeRule may cause OOM when Project expressions are complex

[ https://issues.apache.org/jira/browse/CALCITE-6513?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-6513. -- Resolution: Fixed Fixed in [f20b7c2a|https://github.com/apache/calcite/commit/f20b7c2a4a4b34

[jira] [Updated] (CALCITE-6463) alias generation issue about correlated subquery handling

[ https://issues.apache.org/jira/browse/CALCITE-6463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6463: Issue Type: Improvement (was: Bug) > alias generation issue about correlated subquery handling > ---

[jira] [Updated] (CALCITE-6463) alias generation issue about correlated subquery handling

[ https://issues.apache.org/jira/browse/CALCITE-6463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6463: Priority: Minor (was: Blocker) > alias generation issue about correlated subquery handling > ---

[jira] [Updated] (CALCITE-6463) alias generation issue about correlated subquery handling

[ https://issues.apache.org/jira/browse/CALCITE-6463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6463: Priority: Blocker (was: Minor) > alias generation issue about correlated subquery handling > ---

[jira] [Created] (CALCITE-6521) CROSS JOIN UNNEST The results do not match expectations.

EveyWu created CALCITE-6521: Summary: CROSS JOIN UNNEST The results do not match expectations. Key: CALCITE-6521 URL: https://issues.apache.org/jira/browse/CALCITE-6521 Project: Calcite Issue Ty

[jira] [Updated] (CALCITE-6521) CROSS JOIN UNNEST The results do not match expectations.

[ https://issues.apache.org/jira/browse/CALCITE-6521?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6521: Description: {code:java} SELECT n, a FROM ( VALUES (ARRAY[2, 5], ARRAY['dog', 'cat', 'bird']),

[jira] [Updated] (CALCITE-6463) alias generation issue about correlated subquery handling

[ https://issues.apache.org/jira/browse/CALCITE-6463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6463: Issue Type: Bug (was: Improvement) > alias generation issue about correlated subquery handling > ---

[jira] [Updated] (CALCITE-6471) Improve performance of SqlToRelConverter by preventing unconditional conversion of sqlNodes to string for null-check messages

[ https://issues.apache.org/jira/browse/CALCITE-6471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-6471: -- Fix Version/s: 1.38.0 > Improve performance of SqlToRelConverter by preventin

[jira] [Resolved] (CALCITE-6471) Improve performance of SqlToRelConverter by preventing unconditional conversion of sqlNodes to string for null-check messages

[ https://issues.apache.org/jira/browse/CALCITE-6471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando resolved CALCITE-6471. --- Resolution: Fixed Fixed via [{{2d6e9a7}}|https://github.com/apache/calcite