[jira] [Commented] (CALCITE-5284) JDBC rules create inefficient plan

[ https://issues.apache.org/jira/browse/CALCITE-5284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17637058#comment-17637058 ] Ulrich Kramer commented on CALCITE-5284: Could this also be related to missing table

[jira] [Resolved] (CALCITE-5336) Support inferring constants from predicates with IS NOT DISTINCT FROM operator

[ https://issues.apache.org/jira/browse/CALCITE-5336?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5336. -- Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-5336) Support inferring constants from predicates with IS NOT DISTINCT FROM operator

[ https://issues.apache.org/jira/browse/CALCITE-5336?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17636997#comment-17636997 ] Jasmin Trada commented on CALCITE-5336: --- Thank you! > Support inferring constants from

[jira] [Commented] (CALCITE-5336) Support inferring constants from predicates with IS NOT DISTINCT FROM operator

[ https://issues.apache.org/jira/browse/CALCITE-5336?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17636973#comment-17636973 ] Julian Hyde commented on CALCITE-5336: -- Looks good; I reviewed, made a few changes in

[jira] [Comment Edited] (CALCITE-5336) Support inferring constants from predicates with IS NOT DISTINCT FROM operator

[ https://issues.apache.org/jira/browse/CALCITE-5336?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17629117#comment-17629117 ] Julian Hyde edited comment on CALCITE-5336 at 11/22/22 2:24 AM: The

[jira] [Commented] (CALCITE-5393) parser not support mysql operator VALUE

[ https://issues.apache.org/jira/browse/CALCITE-5393?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17636962#comment-17636962 ] sweetboy commented on CALCITE-5393: --- I've changed the summary. VALUE really is a MySQL extension,

[jira] [Updated] (CALCITE-5393) parser not support mysql operator VALUE

[ https://issues.apache.org/jira/browse/CALCITE-5393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] sweetboy updated CALCITE-5393: -- Summary: parser not support mysql operator VALUE (was: SqlKind not support mysql operator value) >

[jira] [Commented] (CALCITE-5391) JoinOnUniqueToSemiJoinRule should preserve field names, if possible

[ https://issues.apache.org/jira/browse/CALCITE-5391?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17636938#comment-17636938 ] Scott Reynolds commented on CALCITE-5391: - I am worried my application – which depends on field

[jira] [Updated] (CALCITE-5391) JoinOnUniqueToSemiJoinRule should preserve field names, if possible

[ https://issues.apache.org/jira/browse/CALCITE-5391?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Scott Reynolds updated CALCITE-5391: Summary: JoinOnUniqueToSemiJoinRule should preserve field names, if possible (was:

[jira] [Assigned] (CALCITE-2989) The method ymdToJulian in DateTimeUtils returns wrong value

[ https://issues.apache.org/jira/browse/CALCITE-2989?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-2989: Assignee: Gregory Hart > The method ymdToJulian in DateTimeUtils returns wrong value >

[jira] [Updated] (CALCITE-2989) The method ymdToJulian in DateTimeUtils returns wrong value

[ https://issues.apache.org/jira/browse/CALCITE-2989?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-2989: - Fix Version/s: 1.33.0 > The method ymdToJulian in DateTimeUtils returns wrong value >

[jira] [Commented] (CALCITE-2989) The method ymdToJulian in DateTimeUtils returns wrong value

[ https://issues.apache.org/jira/browse/CALCITE-2989?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17636925#comment-17636925 ] Julian Hyde commented on CALCITE-2989: -- Also, could you change the summary of this issue to

[jira] [Commented] (CALCITE-2989) The method ymdToJulian in DateTimeUtils returns wrong value

[ https://issues.apache.org/jira/browse/CALCITE-2989?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17636922#comment-17636922 ] Julian Hyde commented on CALCITE-2989: -- Thanks, [~freastro], that explanation helps a lot. Could

[jira] [Commented] (CALCITE-5386) Add support for LIKE (ANY | SOME | ALL)

[ https://issues.apache.org/jira/browse/CALCITE-5386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17636908#comment-17636908 ] Julian Hyde commented on CALCITE-5386: -- It would be a welcome feature. Your implementation plan

[jira] [Commented] (CALCITE-5376) Support Spark’s FIRST and LAST functions

[ https://issues.apache.org/jira/browse/CALCITE-5376?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17636905#comment-17636905 ] Julian Hyde commented on CALCITE-5376: -- That sounds about right. I don't think any parser changes

[jira] [Commented] (CALCITE-5391) JoinOnUniqueToSemiJoinRule should preserve field names

[ https://issues.apache.org/jira/browse/CALCITE-5391?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17636892#comment-17636892 ] Julian Hyde commented on CALCITE-5391: -- With any rule, there's a possibility that the resulting

[jira] [Updated] (CALCITE-5391) JoinOnUniqueToSemiJoinRule should preserve field names

[ https://issues.apache.org/jira/browse/CALCITE-5391?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Scott Reynolds updated CALCITE-5391: Summary: JoinOnUniqueToSemiJoinRule should preserve field names (was:

[jira] [Comment Edited] (CALCITE-5388) No result when using ROW_NUMBER in two common table expressions

[ https://issues.apache.org/jira/browse/CALCITE-5388?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17636849#comment-17636849 ] Dmitry Sysolyatin edited comment on CALCITE-5388 at 11/21/22 7:37 PM:

[jira] [Commented] (CALCITE-5391) JoinOnUniqueToSemiJoinRule removes a Projections aliases

[ https://issues.apache.org/jira/browse/CALCITE-5391?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17636853#comment-17636853 ] Scott Reynolds commented on CALCITE-5391: - bq. I think "JoinOnUniqueToSemiJoinRule should

[jira] [Comment Edited] (CALCITE-5388) No result when using ROW_NUMBER in two common table expressions

[ https://issues.apache.org/jira/browse/CALCITE-5388?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17636849#comment-17636849 ] Dmitry Sysolyatin edited comment on CALCITE-5388 at 11/21/22 7:26 PM:

[jira] [Commented] (CALCITE-5388) No result when using ROW_NUMBER in two common table expressions

[ https://issues.apache.org/jira/browse/CALCITE-5388?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17636849#comment-17636849 ] Dmitry Sysolyatin commented on CALCITE-5388: [~julianhyde] I don't know how to make the

[jira] [Updated] (CALCITE-5391) JoinOnUniqueToSemiJoinRule removes a Projections aliases

[ https://issues.apache.org/jira/browse/CALCITE-5391?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5391: - Fix Version/s: 1.33.0 > JoinOnUniqueToSemiJoinRule removes a Projections aliases >

[jira] [Commented] (CALCITE-5391) JoinOnUniqueToSemiJoinRule removes a Projections aliases

[ https://issues.apache.org/jira/browse/CALCITE-5391?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17636839#comment-17636839 ] Julian Hyde commented on CALCITE-5391: -- I think "JoinOnUniqueToSemiJoinRule should preserve field

[jira] [Commented] (CALCITE-5360) Implement BigQuery TIMESTAMP_ADD and TIMESTAMP_DIFF

[ https://issues.apache.org/jira/browse/CALCITE-5360?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17636837#comment-17636837 ] Julian Hyde commented on CALCITE-5360: -- Oops, I had it backwards. {{DATEADD}} (defined in

[jira] [Commented] (CALCITE-5388) No result when using ROW_NUMBER in two common table expressions

[ https://issues.apache.org/jira/browse/CALCITE-5388?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17636827#comment-17636827 ] Julian Hyde commented on CALCITE-5388: -- [~dmsysolyatin], Can you convert your 'simple fix' into a

[jira] [Comment Edited] (CALCITE-5388) No result when using ROW_NUMBER in two common table expressions

[ https://issues.apache.org/jira/browse/CALCITE-5388?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17636660#comment-17636660 ] Julian Hyde edited comment on CALCITE-5388 at 11/21/22 6:31 PM: I did

[jira] [Commented] (CALCITE-5388) No result when using ROW_NUMBER in two common table expressions

[ https://issues.apache.org/jira/browse/CALCITE-5388?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17636814#comment-17636814 ] Magnus Mogren commented on CALCITE-5388: [~dmsysolyatin] [~libenchao] I checked out the PR and

[jira] [Updated] (CALCITE-5385) Add BigQuery as supported library for implemented functions

[ https://issues.apache.org/jira/browse/CALCITE-5385?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5385: Labels: pull-request-available (was: ) > Add BigQuery as supported library for

[jira] [Comment Edited] (CALCITE-5336) Support inferring constants from predicates with IS NOT DISTINCT FROM operator

[ https://issues.apache.org/jira/browse/CALCITE-5336?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17629182#comment-17629182 ] Jasmin Trada edited comment on CALCITE-5336 at 11/21/22 5:08 PM: -

[jira] [Commented] (CALCITE-5393) SqlKind not support mysql operator value

[ https://issues.apache.org/jira/browse/CALCITE-5393?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17636752#comment-17636752 ] Julian Hyde commented on CALCITE-5393: -- VALUES is standard SQL. VALUE seems to be a MySQL

[jira] [Updated] (CALCITE-5388) No result when using ROW_NUMBER in two common table expressions

[ https://issues.apache.org/jira/browse/CALCITE-5388?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5388: --- Fix Version/s: 1.33.0 > No result when using ROW_NUMBER in two common table

[jira] [Updated] (CALCITE-5388) No result when using ROW_NUMBER in two common table expressions

[ https://issues.apache.org/jira/browse/CALCITE-5388?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5388: --- Component/s: core > No result when using ROW_NUMBER in two common table

[jira] [Commented] (CALCITE-5388) No result when using ROW_NUMBER in two common table expressions

[ https://issues.apache.org/jira/browse/CALCITE-5388?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17636660#comment-17636660 ] Dmitry Sysolyatin commented on CALCITE-5388: I did simple fix -

[jira] [Updated] (CALCITE-5395) RelToSql converter fails when SELECT * is under a semi-join node

[ https://issues.apache.org/jira/browse/CALCITE-5395?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Leonid Chistov updated CALCITE-5395: Description: The following test case would fail if added to RelToSqlConverterTest.java:

[jira] [Updated] (CALCITE-5394) RelToSql converter fails when semi-join is under a join node

[ https://issues.apache.org/jira/browse/CALCITE-5394?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Leonid Chistov updated CALCITE-5394: Description: The following test case would fail if added to RelToSqlConverterTest.java:

[jira] [Created] (CALCITE-5395) RelToSql converter fails when SELECT * is under a semi-join node

Leonid Chistov created CALCITE-5395: --- Summary: RelToSql converter fails when SELECT * is under a semi-join node Key: CALCITE-5395 URL: https://issues.apache.org/jira/browse/CALCITE-5395 Project:

[jira] [Assigned] (CALCITE-5388) No result when using ROW_NUMBER in two common table expressions

[ https://issues.apache.org/jira/browse/CALCITE-5388?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin reassigned CALCITE-5388: -- Assignee: Dmitry Sysolyatin > No result when using ROW_NUMBER in two common

[jira] [Updated] (CALCITE-5394) RelToSql converter fails when semi-join is under a join node

[ https://issues.apache.org/jira/browse/CALCITE-5394?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Leonid Chistov updated CALCITE-5394: Priority: Minor (was: Major) > RelToSql converter fails when semi-join is under a join

[jira] [Created] (CALCITE-5394) RelToSql converter fails when semi-join is under a join node

Leonid Chistov created CALCITE-5394: --- Summary: RelToSql converter fails when semi-join is under a join node Key: CALCITE-5394 URL: https://issues.apache.org/jira/browse/CALCITE-5394 Project:

[jira] [Commented] (CALCITE-5388) No result when using ROW_NUMBER in two common table expressions

[ https://issues.apache.org/jira/browse/CALCITE-5388?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17636604#comment-17636604 ] Dmitry Sysolyatin commented on CALCITE-5388: [~libenchao] Good catch! I think it would be

[jira] [Created] (CALCITE-5393) SqlKind not support mysql operator value

sweetboy created CALCITE-5393: - Summary: SqlKind not support mysql operator value Key: CALCITE-5393 URL: https://issues.apache.org/jira/browse/CALCITE-5393 Project: Calcite Issue Type: Bug

[jira] [Updated] (CALCITE-5392) Support Snapshot in RelMdExpressionLineage

[ https://issues.apache.org/jira/browse/CALCITE-5392?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5392: Labels: pull-request-available (was: ) > Support Snapshot in RelMdExpressionLineage >