[jira] [Commented] (CALCITE-6536) Dates before BC cannot be used as arguments to date functions

2024-08-20 Thread Petr Masopust (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6536?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17875065#comment-17875065 ] Petr Masopust commented on CALCITE-6536: Btw there is no year "" - it is ei

[jira] [Commented] (CALCITE-6536) Dates before BC cannot be used as arguments to date functions

2024-08-20 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6536?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17875087#comment-17875087 ] Stamatis Zampetakis commented on CALCITE-6536: --   Below some extracts fro

[jira] [Updated] (CALCITE-4838) Add RoundingMode in RelDataTypeSystem to specify the rounding behavior

2024-08-20 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4838?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan updated CALCITE-4838: Summary: Add RoundingMode in RelDataTypeSystem to specify the rounding behavior (was: add roundi

[jira] [Assigned] (CALCITE-4806) Lossy CAST is incorrectly simplified

2024-08-20 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4806?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan reassigned CALCITE-4806: --- Assignee: xiong duan > Lossy CAST is incorrectly simplified >

[jira] [Commented] (CALCITE-4806) Lossy CAST is incorrectly simplified

2024-08-20 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17875227#comment-17875227 ] Mihai Budiu commented on CALCITE-4806: -- Related to https://issues.apache.org/jira/

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

2024-08-20 Thread Ian Bertolacci (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17875234#comment-17875234 ] Ian Bertolacci commented on CALCITE-5213: - Here is some replication code in sca

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

2024-08-20 Thread Ian Bertolacci (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17875234#comment-17875234 ] Ian Bertolacci edited comment on CALCITE-5213 at 8/20/24 4:17 PM: ---

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

2024-08-20 Thread Ian Bertolacci (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17875234#comment-17875234 ] Ian Bertolacci edited comment on CALCITE-5213 at 8/20/24 4:19 PM: ---

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

2024-08-20 Thread Ian Bertolacci (Jira)
[ 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.37.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.

2024-08-20 Thread Ian Bertolacci (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17875243#comment-17875243 ] Ian Bertolacci commented on CALCITE-5213: - I was hoping from something like thi

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

2024-08-20 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17875248#comment-17875248 ] Mihai Budiu commented on CALCITE-5213: -- Not exactly this topic, but there are algo

[jira] [Created] (CALCITE-6539) Improve error messages due to misspellings

2024-08-20 Thread Adam Markowitz (Jira)
Adam Markowitz created CALCITE-6539: --- Summary: Improve error messages due to misspellings Key: CALCITE-6539 URL: https://issues.apache.org/jira/browse/CALCITE-6539 Project: Calcite Issue Ty

[jira] [Created] (CALCITE-6540) RelOptUtil.pushDownJoinConditions does not correctly adjust ASOF joins match conditions

2024-08-20 Thread Mihai Budiu (Jira)
Mihai Budiu created CALCITE-6540: Summary: RelOptUtil.pushDownJoinConditions does not correctly adjust ASOF joins match conditions Key: CALCITE-6540 URL: https://issues.apache.org/jira/browse/CALCITE-6540

[jira] [Created] (CALCITE-6541) Type inference for MOD operator is incorrect

2024-08-20 Thread Mihai Budiu (Jira)
Mihai Budiu created CALCITE-6541: Summary: Type inference for MOD operator is incorrect Key: CALCITE-6541 URL: https://issues.apache.org/jira/browse/CALCITE-6541 Project: Calcite Issue Type:

[jira] [Updated] (CALCITE-6539) Improve error messages due to misspellings using (say) Levenshtein distance

2024-08-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6539: - Summary: Improve error messages due to misspellings using (say) Levenshtein distance (was: Imp

[jira] [Commented] (CALCITE-6539) Improve error messages due to misspellings using (say) Levenshtein distance

2024-08-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17875276#comment-17875276 ] Julian Hyde commented on CALCITE-6539: -- Apache Commons has several implementations

[jira] [Resolved] (CALCITE-4565) UpperBound and lowerBound are silently re-written incorrectly during sql to rel conversion

2024-08-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4565?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-4565. -- Fix Version/s: 1.38.0 Resolution: Duplicate Resolving as a duplicate of CALCITE-5883.

[jira] [Updated] (CALCITE-6539) Improve error messages due to misspellings using (say) Levenshtein distance

2024-08-20 Thread Adam Markowitz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Markowitz updated CALCITE-6539: Description: Consider further improvements to the Calcite "Did you mean?  ..." section in

[jira] [Commented] (CALCITE-6541) Type inference for MOD operator is incorrect

2024-08-20 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6541?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17875280#comment-17875280 ] Mihai Budiu commented on CALCITE-6541: -- This one is debatable, Calcite uses the ty

[jira] [Updated] (CALCITE-6540) RelOptUtil.pushDownJoinConditions does not correctly adjust ASOF joins match conditions

2024-08-20 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6540: Labels: pull-request-available (was: ) > RelOptUtil.pushDownJoinConditions does not corr

[jira] [Commented] (CALCITE-5883) Calcite ignores window frames when there is no ORDER BY clause

2024-08-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17875289#comment-17875289 ] Julian Hyde commented on CALCITE-5883: -- I have changed my mind about this. Conside

[jira] [Updated] (CALCITE-5883) Calcite ignores window frames when there is no ORDER BY clause

2024-08-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5883: - Fix Version/s: 1.38.0 > Calcite ignores window frames when there is no ORDER BY clause > --

[jira] [Comment Edited] (CALCITE-5883) Calcite ignores window frames when there is no ORDER BY clause

2024-08-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17875289#comment-17875289 ] Julian Hyde edited comment on CALCITE-5883 at 8/20/24 9:05 PM: --

[jira] [Assigned] (CALCITE-5883) Calcite ignores window frames when there is no ORDER BY clause

2024-08-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-5883: Assignee: Julian Hyde > Calcite ignores window frames when there is no ORDER BY clause >

[jira] [Comment Edited] (CALCITE-5883) Calcite ignores window frames when there is no ORDER BY clause

2024-08-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17875289#comment-17875289 ] Julian Hyde edited comment on CALCITE-5883 at 8/20/24 9:06 PM: --

[jira] [Updated] (CALCITE-5883) Calcite ignores ROWS window frames when there is no ORDER BY clause

2024-08-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5883: - Summary: Calcite ignores ROWS window frames when there is no ORDER BY clause (was: Calcite ign

[jira] [Updated] (CALCITE-5883) Calcite ignores ROWS window frames when there is no ORDER BY clause

2024-08-20 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5883: Labels: pull-request-available (was: ) > Calcite ignores ROWS window frames when there i

[jira] [Commented] (CALCITE-6541) Type inference for MOD operator is incorrect

2024-08-20 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6541?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17875351#comment-17875351 ] xiong duan commented on CALCITE-6541: - +1 > Type inference for MOD operator is inc