[jira] [Commented] (CALCITE-5407) MongoDB: Invalid ARRAY conversion

2023-01-12 Thread Tim Nieradzik (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5407?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17675990#comment-17675990 ] Tim Nieradzik commented on CALCITE-5407: Apologies for the delay! I have update

[jira] [Commented] (CALCITE-5405) MongoDB: Invalid TIMESTAMP conversion

2023-01-12 Thread Tim Nieradzik (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17675991#comment-17675991 ] Tim Nieradzik commented on CALCITE-5405: Thanks for the review! I have updated

[jira] [Updated] (CALCITE-5468) SqlToRelConverter throws if ORDER BY contains IN

2023-01-12 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5468?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5468: --- Summary: SqlToRelConverter throws if ORDER BY contains IN (was: SqlToRelConverter

[jira] [Commented] (CALCITE-2959) Support collation on struct fields

2023-01-12 Thread Thomas Rebele (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17676025#comment-17676025 ] Thomas Rebele commented on CALCITE-2959: Maybe the {{EnhancedScan}} could outpu

[jira] [Commented] (CALCITE-4021) EnumerableUnion should preserve ordering when all inputs have the same collation

2023-01-12 Thread Thomas Rebele (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17676026#comment-17676026 ] Thomas Rebele commented on CALCITE-4021: I agree with [~julianhyde], and propos

[jira] [Created] (CALCITE-5469) Implement BigQuery DATETIME_ADD/DATETIME_DIFF

2023-01-12 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5469: - Summary: Implement BigQuery DATETIME_ADD/DATETIME_DIFF Key: CALCITE-5469 URL: https://issues.apache.org/jira/browse/CALCITE-5469 Project: Calcite Issue Typ

[jira] [Created] (CALCITE-5470) VolcanoPlanner removes a necessary sort

2023-01-12 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-5470: -- Summary: VolcanoPlanner removes a necessary sort Key: CALCITE-5470 URL: https://issues.apache.org/jira/browse/CALCITE-5470 Project: Calcite Issue Type: B

[jira] [Updated] (CALCITE-5470) VolcanoPlanner removes a necessary sort

2023-01-12 Thread Thomas Rebele (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5470?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas Rebele updated CALCITE-5470: --- Attachment: sqlline.log > VolcanoPlanner removes a necessary sort > ---

[jira] [Updated] (CALCITE-5470) VolcanoPlanner removes a necessary sort

2023-01-12 Thread Thomas Rebele (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5470?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas Rebele updated CALCITE-5470: --- Description: A logical plan that roughly corresponds to SELECT a*a FROM (VALUES(-10),(2),(

[jira] [Updated] (CALCITE-5470) VolcanoPlanner removes a necessary sort

2023-01-12 Thread Thomas Rebele (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5470?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas Rebele updated CALCITE-5470: --- Attachment: test.patch > VolcanoPlanner removes a necessary sort >

[jira] [Updated] (CALCITE-5470) VolcanoPlanner removes a necessary sort

2023-01-12 Thread Thomas Rebele (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5470?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas Rebele updated CALCITE-5470: --- Description: A test case with the VolcanoPlanner produces an unexpected result ([^test.pat

[jira] [Updated] (CALCITE-5470) VolcanoPlanner removes a necessary sort

2023-01-12 Thread Thomas Rebele (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5470?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas Rebele updated CALCITE-5470: --- Description: A test case with the VolcanoPlanner produces an unexpected result ([^test.pat

[jira] [Created] (CALCITE-5471) RelSupplier.SqlRelSupplier#apply should use .project(), not .rel

2023-01-12 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-5471: -- Summary: RelSupplier.SqlRelSupplier#apply should use .project(), not .rel Key: CALCITE-5471 URL: https://issues.apache.org/jira/browse/CALCITE-5471 Project: Calci

[jira] [Created] (CALCITE-5472) RexCallBinding#getOperandMonotonicity should return CONSTANT for RexLiterals

2023-01-12 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-5472: -- Summary: RexCallBinding#getOperandMonotonicity should return CONSTANT for RexLiterals Key: CALCITE-5472 URL: https://issues.apache.org/jira/browse/CALCITE-5472 Pr

[jira] [Created] (CALCITE-5473) Keep more collations in RelMdCollation#project for monotonic RexCalls

2023-01-12 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-5473: -- Summary: Keep more collations in RelMdCollation#project for monotonic RexCalls Key: CALCITE-5473 URL: https://issues.apache.org/jira/browse/CALCITE-5473 Project:

[jira] [Updated] (CALCITE-5470) VolcanoPlanner removes a necessary sort

2023-01-12 Thread Thomas Rebele (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5470?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas Rebele updated CALCITE-5470: --- Attachment: SortRemoveRule-after.png SortRemoveRule-before.png > VolcanoPla

[jira] [Comment Edited] (CALCITE-5470) VolcanoPlanner removes a necessary sort

2023-01-12 Thread Thomas Rebele (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5470?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17676276#comment-17676276 ] Thomas Rebele edited comment on CALCITE-5470 at 1/12/23 5:45 PM:

[jira] [Commented] (CALCITE-5470) VolcanoPlanner removes a necessary sort

2023-01-12 Thread Thomas Rebele (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5470?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17676276#comment-17676276 ] Thomas Rebele commented on CALCITE-5470: In the visualization, the LogicalSort

[jira] [Comment Edited] (CALCITE-5470) VolcanoPlanner removes a necessary sort

2023-01-12 Thread Thomas Rebele (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5470?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17676276#comment-17676276 ] Thomas Rebele edited comment on CALCITE-5470 at 1/12/23 5:46 PM:

[jira] [Updated] (CALCITE-5470) VolcanoPlanner removes a necessary sort

2023-01-12 Thread Thomas Rebele (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5470?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas Rebele updated CALCITE-5470: --- Attachment: planner-viz-data-testSortAndMultiply.js.zip > VolcanoPlanner removes a necessar

[jira] [Commented] (CALCITE-5471) RelSupplier.SqlRelSupplier#apply should use .project(), not .rel

2023-01-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17676281#comment-17676281 ] Julian Hyde commented on CALCITE-5471: -- it’s difficult to triage these cases that

[jira] [Commented] (CALCITE-5471) RelSupplier.SqlRelSupplier#apply should use .project(), not .rel

2023-01-12 Thread Thomas Rebele (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17676283#comment-17676283 ] Thomas Rebele commented on CALCITE-5471: RelSupplier is in the package of org.a

[jira] [Commented] (CALCITE-5471) RelSupplier.SqlRelSupplier#apply should use .project(), not .rel

2023-01-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17676294#comment-17676294 ] Julian Hyde commented on CALCITE-5471: -- Makes sense. > RelSupplier.SqlRelSupplier

[jira] [Resolved] (CALCITE-4021) EnumerableUnion should preserve ordering when all inputs have the same collation

2023-01-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4021?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-4021. -- Resolution: Won't Fix > EnumerableUnion should preserve ordering when all inputs have the sam

[jira] [Closed] (CALCITE-4021) EnumerableUnion should preserve ordering when all inputs have the same collation

2023-01-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4021?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde closed CALCITE-4021. > EnumerableUnion should preserve ordering when all inputs have the same > collation > -

[jira] [Updated] (CALCITE-4021) EnumerableUnion should preserve ordering when all inputs have the same collation

2023-01-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4021?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4021: - Fix Version/s: 1.27.0 > EnumerableUnion should preserve ordering when all inputs have the same

[jira] [Resolved] (CALCITE-5405) MongoDB: Invalid TIMESTAMP conversion

2023-01-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5405?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5405. -- Resolution: Fixed Fixed in [ad145397|https://github.com/apache/calcite/commit/ad145397d91eea

[jira] [Updated] (CALCITE-5469) Implement BigQuery DATETIME_ADD/DATETIME_DIFF

2023-01-12 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5469: Labels: pull-request-available (was: ) > Implement BigQuery DATETIME_ADD/DATETIME_DIFF >

[jira] [Updated] (CALCITE-5464) Implement BigQuery DATE_ADD/DATE_DIFF

2023-01-12 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5464?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5464: Labels: pull-request-available (was: ) > Implement BigQuery DATE_ADD/DATE_DIFF > ---

[jira] [Resolved] (CALCITE-5407) MongoDB: Invalid ARRAY conversion

2023-01-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5407?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5407. -- Resolution: Fixed Fixed in [c330aa30|https://github.com/apache/calcite/commit/c330aa30fde760

[jira] [Comment Edited] (CALCITE-5447) Add DATE_TRUNC for BigQuery

2023-01-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5447?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17656269#comment-17656269 ] Julian Hyde edited comment on CALCITE-5447 at 1/13/23 5:14 AM: --

[jira] [Updated] (CALCITE-5304) RelJson should support RexSubQuery

2023-01-12 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5304: Labels: pull-request-available (was: ) > RelJson should support RexSubQuery > --