[jira] [Commented] (CALCITE-5591) Implement BigQuery functions SAFE_ADD, SAFE_SUBTRACT, SAFE_MULTIPLY, SAFE_DIVIDE and SAFE_NEGATE

2023-05-30 Thread Dan Zou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5591?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727759#comment-17727759 ] Dan Zou commented on CALCITE-5591: -- [~tanclary] The point is we do not enough informat

[jira] [Comment Edited] (CALCITE-5732) EnumerableJoin should not return rows matching condition 'null = null'

2023-05-30 Thread Viggo Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727757#comment-17727757 ] Viggo Chen edited comment on CALCITE-5732 at 5/31/23 2:19 AM: ---

[jira] [Commented] (CALCITE-5732) EnumerableJoin should not return rows matching condition 'null = null'

2023-05-30 Thread Viggo Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727757#comment-17727757 ] Viggo Chen commented on CALCITE-5732: - [~julianhyde] The bug only appears when ther

[jira] [Commented] (CALCITE-5735) Implement SAFE_MULTIPLY function (enabled for BigQuery)

2023-05-30 Thread Dan Zou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727756#comment-17727756 ] Dan Zou commented on CALCITE-5735: -- Sure, I would like to review it. > Implement SAFE

[jira] [Assigned] (CALCITE-5736) Add ARRAY_REVERSE for Spark dialect

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5736?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau reassigned CALCITE-5736: - Assignee: jackylau > Add ARRAY_REVERSE for Spark dialect > ---

[jira] [Commented] (CALCITE-5736) Add ARRAY_REVERSE for Spark dialect

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5736?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727754#comment-17727754 ] jackylau commented on CALCITE-5736: --- spark doesn't support the array_reverse. it sup

[jira] [Closed] (CALCITE-5736) Add ARRAY_REVERSE for Spark dialect

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5736?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau closed CALCITE-5736. - Resolution: Won't Fix > Add ARRAY_REVERSE for Spark dialect > --- > >

[jira] [Commented] (CALCITE-5506) RelToSqlConverter should retain the aggregation logic when Project without RexInputRef on the Aggregate

2023-05-30 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727752#comment-17727752 ] Jiajun Xie commented on CALCITE-5506: - [~julianhyde] , Thank you. > RelToSqlConver

[jira] [Commented] (CALCITE-5506) RelToSqlConverter should retain the aggregation logic when Project without RexInputRef on the Aggregate

2023-05-30 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727748#comment-17727748 ] Julian Hyde commented on CALCITE-5506: -- [~jiajunbernoulli], I merged the improveme

[jira] [Resolved] (CALCITE-5564) Add parsing and validation for PERCENTILE_CONT/PERCENTILE_DISC functions (enabled in BigQuery)

2023-05-30 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5564?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5564. -- Resolution: Fixed Fixed in [58120b2d|https://github.com/apache/calcite/commit/58120b2d84a47d

[jira] [Commented] (CALCITE-5730) Initial null values can be dropped by EnumerableLimitSort with offset

2023-05-30 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727738#comment-17727738 ] Julian Hyde commented on CALCITE-5730: -- A test case (a chunk of java code added to

[jira] [Updated] (CALCITE-5732) EnumerableJoin should not return rows matching condition 'null = null'

2023-05-30 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5732: - Summary: EnumerableJoin should not return rows matching condition 'null = null' (was: Enemerab

[jira] [Commented] (CALCITE-5732) EnemerableJoin should not return rows match condition null = null

2023-05-30 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727736#comment-17727736 ] Julian Hyde commented on CALCITE-5732: -- This is a bug. null = null should evaluate

[jira] [Commented] (CALCITE-5564) Add parsing and validation for PERCENTILE_CONT/PERCENTILE_DISC functions (enabled in BigQuery)

2023-05-30 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5564?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727734#comment-17727734 ] Julian Hyde commented on CALCITE-5564: -- Looks good. I made some minor fix-ups in m

[jira] [Updated] (CALCITE-5736) Add ARRAY_REVERSE for Spark dialect

2023-05-30 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5736?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5736: Labels: pull-request-available (was: ) > Add ARRAY_REVERSE for Spark dialect > -

[jira] [Updated] (CALCITE-5564) Add parsing and validation for PERCENTILE_CONT/PERCENTILE_DISC functions (enabled in BigQuery)

2023-05-30 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5564?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5564: - Fix Version/s: 1.35.0 > Add parsing and validation for PERCENTILE_CONT/PERCENTILE_DISC function

[jira] [Created] (CALCITE-5736) Add ARRAY_REVERSE for Spark dialect

2023-05-30 Thread jackylau (Jira)
jackylau created CALCITE-5736: - Summary: Add ARRAY_REVERSE for Spark dialect Key: CALCITE-5736 URL: https://issues.apache.org/jira/browse/CALCITE-5736 Project: Calcite Issue Type: Improvement

[jira] [Commented] (CALCITE-5735) Implement SAFE_MULTIPLY function (enabled for BigQuery)

2023-05-30 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727729#comment-17727729 ] Tanner Clary commented on CALCITE-5735: --- [~FrankZou] I have opened a pull request

[jira] [Updated] (CALCITE-5735) Implement SAFE_MULTIPLY function (enabled for BigQuery)

2023-05-30 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5735?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5735: Labels: pull-request-available (was: ) > Implement SAFE_MULTIPLY function (enabled for B

[jira] [Updated] (CALCITE-5735) Implement BigQuery SAFE_MULTIPLY function (enabled for BigQuery)

2023-05-30 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5735?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary updated CALCITE-5735: -- Summary: Implement BigQuery SAFE_MULTIPLY function (enabled for BigQuery) (was: Implement Bi

[jira] [Updated] (CALCITE-5735) Implement SAFE_MULTIPLY function (enabled for BigQuery)

2023-05-30 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5735?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary updated CALCITE-5735: -- Summary: Implement SAFE_MULTIPLY function (enabled for BigQuery) (was: Implement BigQuery SA

[jira] [Created] (CALCITE-5735) Implement BigQuery SAFE_MULTIPLY function

2023-05-30 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5735: - Summary: Implement BigQuery SAFE_MULTIPLY function Key: CALCITE-5735 URL: https://issues.apache.org/jira/browse/CALCITE-5735 Project: Calcite Issue Type: S

[jira] [Comment Edited] (CALCITE-5591) Implement BigQuery functions SAFE_ADD, SAFE_SUBTRACT, SAFE_MULTIPLY, SAFE_DIVIDE and SAFE_NEGATE

2023-05-30 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5591?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727579#comment-17727579 ] Tanner Clary edited comment on CALCITE-5591 at 5/30/23 3:22 PM: -

[jira] [Comment Edited] (CALCITE-5591) Implement BigQuery functions SAFE_ADD, SAFE_SUBTRACT, SAFE_MULTIPLY, SAFE_DIVIDE and SAFE_NEGATE

2023-05-30 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5591?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727579#comment-17727579 ] Tanner Clary edited comment on CALCITE-5591 at 5/30/23 3:21 PM: -

[jira] [Comment Edited] (CALCITE-5591) Implement BigQuery functions SAFE_ADD, SAFE_SUBTRACT, SAFE_MULTIPLY, SAFE_DIVIDE and SAFE_NEGATE

2023-05-30 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5591?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727579#comment-17727579 ] Tanner Clary edited comment on CALCITE-5591 at 5/30/23 3:21 PM: -

[jira] [Comment Edited] (CALCITE-5591) Implement BigQuery functions SAFE_ADD, SAFE_SUBTRACT, SAFE_MULTIPLY, SAFE_DIVIDE and SAFE_NEGATE

2023-05-30 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5591?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727579#comment-17727579 ] Tanner Clary edited comment on CALCITE-5591 at 5/30/23 3:20 PM: -

[jira] [Commented] (CALCITE-5591) Implement BigQuery functions SAFE_ADD, SAFE_SUBTRACT, SAFE_MULTIPLY, SAFE_DIVIDE and SAFE_NEGATE

2023-05-30 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5591?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727579#comment-17727579 ] Tanner Clary commented on CALCITE-5591: --- [~FrankZou] That makes sense. For over

[jira] [Commented] (CALCITE-5591) Implement BigQuery functions SAFE_ADD, SAFE_SUBTRACT, SAFE_MULTIPLY, SAFE_DIVIDE and SAFE_NEGATE

2023-05-30 Thread Dan Zou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5591?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727573#comment-17727573 ] Dan Zou commented on CALCITE-5591: -- [~tanclary] I have the germ of an idea: {code:jav

[jira] [Commented] (CALCITE-5591) Implement BigQuery functions SAFE_ADD, SAFE_SUBTRACT, SAFE_MULTIPLY, SAFE_DIVIDE and SAFE_NEGATE

2023-05-30 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5591?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727567#comment-17727567 ] Tanner Clary commented on CALCITE-5591: --- [~FrankZou] Sounds great, for SAFE_ADD h

[jira] [Commented] (CALCITE-5591) Implement BigQuery functions SAFE_ADD, SAFE_SUBTRACT, SAFE_MULTIPLY, SAFE_DIVIDE and SAFE_NEGATE

2023-05-30 Thread Dan Zou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5591?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727564#comment-17727564 ] Dan Zou commented on CALCITE-5591: -- [~tanclary], happy to see that you are interested

[jira] [Commented] (CALCITE-5591) Implement BigQuery functions SAFE_ADD, SAFE_SUBTRACT, SAFE_MULTIPLY, SAFE_DIVIDE and SAFE_NEGATE

2023-05-30 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5591?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727553#comment-17727553 ] Tanner Clary commented on CALCITE-5591: --- Hey, [~FrankZou] I'd be interesting help

[jira] [Commented] (CALCITE-5564) Add parsing and validation for PERCENTILE_CONT/PERCENTILE_DISC functions (enabled in BigQuery)

2023-05-30 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5564?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727546#comment-17727546 ] Tanner Clary commented on CALCITE-5564: --- [~julianhyde] I responded to your most r

[jira] [Updated] (CALCITE-5734) Add ARRAY_COMPACT for Spark dialect

2023-05-30 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5734?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5734: Labels: pull-request-available (was: ) > Add ARRAY_COMPACT for Spark dialect > -

[jira] [Updated] (CALCITE-5734) Add ARRAY_COMPACT for Spark dialect

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5734?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5734: -- Description: array_compact(array) - Removes null values from the array. *Examples:*   {{> SELECT a

[jira] [Created] (CALCITE-5734) Add ARRAY_COMPACT for Spark dialect

2023-05-30 Thread jackylau (Jira)
jackylau created CALCITE-5734: - Summary: Add ARRAY_COMPACT for Spark dialect Key: CALCITE-5734 URL: https://issues.apache.org/jira/browse/CALCITE-5734 Project: Calcite Issue Type: Improvement

[jira] [Resolved] (CALCITE-5703) Reduce amount of generated runtime code

2023-05-30 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5703?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Feng Zhu resolved CALCITE-5703. --- Resolution: Fixed > Reduce amount of generated runtime code > -

[jira] [Commented] (CALCITE-5703) Reduce amount of generated runtime code

2023-05-30 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5703?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727489#comment-17727489 ] Feng Zhu commented on CALCITE-5703: --- Fixed in [https://github.com/apache/calcite/com

[jira] [Comment Edited] (CALCITE-5568) Decorrelate will fail. If the RelNode tree has LogicalValues

2023-05-30 Thread libopeng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727482#comment-17727482 ] libopeng edited comment on CALCITE-5568 at 5/30/23 11:11 AM:

[jira] [Commented] (CALCITE-5568) Decorrelate will fail. If the RelNode tree has LogicalValues

2023-05-30 Thread libopeng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727482#comment-17727482 ] libopeng commented on CALCITE-5568: --- {code:java} with parts (PNum, OrderOnHand) as (s

[jira] [Comment Edited] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727480#comment-17727480 ] jackylau edited comment on CALCITE-5731 at 5/30/23 10:53 AM:

[jira] [Commented] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727480#comment-17727480 ] jackylau commented on CALCITE-5731: --- but it breaks the sql standard, i guess it may b

[jira] [Updated] (CALCITE-5703) Reduce amount of generated runtime code

2023-05-30 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5703?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-5703: Fix Version/s: 1.35.0 > Reduce amount of generated runtime code > ---

[jira] [Updated] (CALCITE-5732) EnemerableJoin should not return rows match condition null = null

2023-05-30 Thread Viggo Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Viggo Chen updated CALCITE-5732: Description: In `EnumerableJoinTest#testMergeJoinWithCompositeKeyAndNullValues`, the query is li

[jira] [Updated] (CALCITE-5733) simplify should also simplify for array type

2023-05-30 Thread Xin Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5733?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xin Chen updated CALCITE-5733: -- External issue URL: (was: https://issues.apache.org/jira/browse/CALCITE-4364) > simplify should al

[jira] [Updated] (CALCITE-5733) simplify should also simplify for array type

2023-05-30 Thread Xin Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5733?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xin Chen updated CALCITE-5733: -- External issue URL: https://issues.apache.org/jira/browse/CALCITE-4364 > simplify should also simplif

[jira] [Comment Edited] (CALCITE-5733) simplify should also simplify for array type

2023-05-30 Thread Xin Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5733?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727467#comment-17727467 ] Xin Chen edited comment on CALCITE-5733 at 5/30/23 10:29 AM:

[jira] [Updated] (CALCITE-5733) simplify should also simplify for array type

2023-05-30 Thread Xin Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5733?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xin Chen updated CALCITE-5733: -- Attachment: screenshot-3.png > simplify should also simplify for array type > ---

[jira] [Commented] (CALCITE-5733) simplify should also simplify for array type

2023-05-30 Thread Xin Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5733?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727469#comment-17727469 ] Xin Chen commented on CALCITE-5733: --- I am currently not sure how to return a compari

[jira] [Commented] (CALCITE-5733) simplify should also simplify for array type

2023-05-30 Thread Xin Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5733?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727467#comment-17727467 ] Xin Chen commented on CALCITE-5733: --- I found this issue while debugging the Flink SQL

[jira] [Updated] (CALCITE-5733) simplify should also simplify for array type

2023-05-30 Thread Xin Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5733?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xin Chen updated CALCITE-5733: -- Attachment: screenshot-2.png > simplify should also simplify for array type > ---

[jira] [Updated] (CALCITE-5733) simplify should also simplify for array type

2023-05-30 Thread Xin Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5733?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xin Chen updated CALCITE-5733: -- Attachment: screenshot-1.png > simplify should also simplify for array type > ---

[jira] [Updated] (CALCITE-5733) simplify should also simplify for array type

2023-05-30 Thread Xin Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5733?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xin Chen updated CALCITE-5733: -- Description: Simplification seem to not take into account that the specified field is of array type.

[jira] [Created] (CALCITE-5733) simplify should also simplify for array type

2023-05-30 Thread Xin Chen (Jira)
Xin Chen created CALCITE-5733: - Summary: simplify should also simplify for array type Key: CALCITE-5733 URL: https://issues.apache.org/jira/browse/CALCITE-5733 Project: Calcite Issue Type: Bug

[jira] [Updated] (CALCITE-5732) EnemerableJoin should not return rows match condition null = null

2023-05-30 Thread Viggo Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Viggo Chen updated CALCITE-5732: Description: In `EnumerableJoinTest#testMergeJoinWithCompositeKeyAndNullValues`, the query is li

[jira] [Updated] (CALCITE-5732) EnemerableJoin should not return rows match condition null = null

2023-05-30 Thread Viggo Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Viggo Chen updated CALCITE-5732: Labels: (was: pull-request-available) > EnemerableJoin should not return rows match condition n

[jira] [Created] (CALCITE-5732) EnemerableJoin should not return rows match condition null = null

2023-05-30 Thread Viggo Chen (Jira)
Viggo Chen created CALCITE-5732: --- Summary: EnemerableJoin should not return rows match condition null = null Key: CALCITE-5732 URL: https://issues.apache.org/jira/browse/CALCITE-5732 Project: Calcite

[jira] [Commented] (CALCITE-4364) Simplify "a IN (1, 2) AND a = 1" to "a = 1"

2023-05-30 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4364?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727450#comment-17727450 ] Stamatis Zampetakis commented on CALCITE-4364: -- [~xinchen147] What you are

[jira] [Commented] (CALCITE-5568) Decorrelate will fail. If the RelNode tree has LogicalValues

2023-05-30 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727449#comment-17727449 ] Stamatis Zampetakis commented on CALCITE-5568: -- [~leepb] We have to find w

[jira] [Commented] (CALCITE-5720) improve FilterJoinRule to push filter into both join sides

2023-05-30 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727441#comment-17727441 ] Alessandro Solimando commented on CALCITE-5720: --- {quote}`SELECT * FROM My

[jira] [Comment Edited] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727412#comment-17727412 ] Ruben Q L edited comment on CALCITE-5731 at 5/30/23 8:54 AM:

[jira] [Updated] (CALCITE-5730) Initial null values can be dropped by EnumerableLimitSort with offset

2023-05-30 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5730: --- Summary: Initial null values can be dropped by EnumerableLimitSort with offset (was: First nulls c

[jira] [Commented] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727412#comment-17727412 ] Ruben Q L commented on CALCITE-5731: [~jackylau] thanks bringing up this topic. I'

[jira] [Assigned] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau reassigned CALCITE-5731: - Assignee: jackylau > cast to row type should throw exception when contains null/not null const

[jira] [Comment Edited] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727396#comment-17727396 ] jackylau edited comment on CALCITE-5731 at 5/30/23 8:28 AM:

[jira] [Commented] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727396#comment-17727396 ] jackylau commented on CALCITE-5731: --- hi [~libenchao] [~rubenql]  do you have time to

[jira] [Updated] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5731: Labels: pull-request-available (was: ) > cast to row type should throw exception when co

[jira] [Comment Edited] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727387#comment-17727387 ] jackylau edited comment on CALCITE-5731 at 5/30/23 8:14 AM:

[jira] [Commented] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727387#comment-17727387 ] jackylau commented on CALCITE-5731: --- 1)the issue https://issues.apache.org/jira/brows

[jira] [Updated] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5731: -- Description: the cast standard grammar it here from iso 2016 {code:java} // code placeholder ::= CAS

[jira] [Updated] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5731: -- Description: the cast standard grammar it here from iso 2016 {code} // code placeholder ::= CAST A

[jira] [Created] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread jackylau (Jira)
jackylau created CALCITE-5731: - Summary: cast to row type should throw exception when contains null/not null constraint Key: CALCITE-5731 URL: https://issues.apache.org/jira/browse/CALCITE-5731 Project: C

[jira] [Commented] (CALCITE-4364) Simplify "a IN (1, 2) AND a = 1" to "a = 1"

2023-05-30 Thread Xin Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4364?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727374#comment-17727374 ] Xin Chen commented on CALCITE-4364: --- Thank you for above descriptions! But I currentl

[jira] [Commented] (CALCITE-5730) First nulls can be dropped by EnumerableLimitSort with offset

2023-05-30 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727370#comment-17727370 ] Ruben Q L commented on CALCITE-5730: [~gf2121], what [~julianhyde] means is that, n

[jira] [Updated] (CALCITE-5730) First nulls can be dropped by EnumerableLimitSort with offset

2023-05-30 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5730: --- Summary: First nulls can be dropped by EnumerableLimitSort with offset (was: First nulls can be dr