[jira] [Comment Edited] (CALCITE-6504) JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect tree when using correlated sub-query in on clause of equi-join

2024-07-26 Thread Ian Bertolacci (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17869048#comment-17869048 ] Ian Bertolacci edited comment on CALCITE-6504 at 7/26/24 11:39 PM: --

[jira] [Commented] (CALCITE-6504) JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect tree when using correlated sub-query in on clause of equi-join

2024-07-26 Thread Ian Bertolacci (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17869048#comment-17869048 ] Ian Bertolacci commented on CALCITE-6504: - Some light math and playing around w

[jira] [Commented] (CALCITE-3522) SqlValidator.validateLiteral rejects literals with a DECIMAL type that require more than 64 bits

2024-07-26 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3522?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17869047#comment-17869047 ] Mihai Budiu commented on CALCITE-3522: -- I have changed the title of the issue, I h

[jira] [Updated] (CALCITE-3522) SqlValidator.validateLiteral rejects literals with a DECIMAL type that require more than 64 bits

2024-07-26 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3522?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu updated CALCITE-3522: - Summary: SqlValidator.validateLiteral rejects literals with a DECIMAL type that require more th

[jira] [Commented] (CALCITE-3522) Sql validator limits decimal literals to 64 bits

2024-07-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3522?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17869046#comment-17869046 ] Julian Hyde commented on CALCITE-3522: -- [~mbudiu], After 5 years the subject is st

[jira] [Commented] (CALCITE-6020) SqlToRelConverter should not replace windowed SUM with equivalent expression using SUM0

2024-07-26 Thread Norman Jordan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17869042#comment-17869042 ] Norman Jordan commented on CALCITE-6020: I am working on adding more tests, but

[jira] [Comment Edited] (CALCITE-6504) JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect tree when using correlated sub-query in on clause of equi-join

2024-07-26 Thread James Starr (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17869032#comment-17869032 ] James Starr edited comment on CALCITE-6504 at 7/26/24 10:37 PM: -

[jira] [Commented] (CALCITE-6504) JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect tree when using correlated sub-query in on clause of equi-join

2024-07-26 Thread Ian Bertolacci (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17869038#comment-17869038 ] Ian Bertolacci commented on CALCITE-6504: - We're currently investigating if pus

[jira] [Commented] (CALCITE-3522) Sql validator limits decimal literals to 64 bits

2024-07-26 Thread Seema B Gupta (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3522?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17869037#comment-17869037 ] Seema B Gupta commented on CALCITE-3522: I agree with you on the above. I can w

[jira] [Comment Edited] (CALCITE-6504) JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect tree when using correlated sub-query in on clause of equi-join

2024-07-26 Thread Ian Bertolacci (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17869038#comment-17869038 ] Ian Bertolacci edited comment on CALCITE-6504 at 7/26/24 10:18 PM: --

[jira] [Commented] (CALCITE-3522) Sql validator limits decimal literals to 64 bits

2024-07-26 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3522?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17869035#comment-17869035 ] Mihai Budiu commented on CALCITE-3522: -- I propose to do this in two steps: - if th

[jira] [Commented] (CALCITE-3522) Sql validator limits decimal literals to 64 bits

2024-07-26 Thread Seema B Gupta (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3522?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17869034#comment-17869034 ] Seema B Gupta commented on CALCITE-3522: Yes we do have an override on the RelD

[jira] [Commented] (CALCITE-6504) JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect tree when using correlated sub-query in on clause of equi-join

2024-07-26 Thread James Starr (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17869032#comment-17869032 ] James Starr commented on CALCITE-6504: -- One way of handling this is for an inner j

[jira] [Updated] (CALCITE-6504) JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect tree when using correlated sub-query in on clause of equi-join

2024-07-26 Thread James Starr (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6504?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Starr updated CALCITE-6504: - Description: JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect trees when

[jira] [Resolved] (CALCITE-6472) Add degree based trigonometric functions to PostgreSQL function library

2024-07-26 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6472?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6472. -- Fix Version/s: 1.38.0 Resolution: Fixed Fixed in https://github.com/apache/calcite/co

[jira] [Commented] (CALCITE-3522) Sql validator limits decimal literals to 64 bits

2024-07-26 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3522?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17869000#comment-17869000 ] Mihai Budiu commented on CALCITE-3522: -- This code has nothing to do with predicate

[jira] [Commented] (CALCITE-3522) Sql validator limits decimal literals to 64 bits

2024-07-26 Thread Seema B Gupta (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3522?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17868999#comment-17868999 ] Seema B Gupta commented on CALCITE-3522: Yes I can help with testing the fix wi

[jira] [Commented] (CALCITE-3522) Sql validator limits decimal literals to 64 bits

2024-07-26 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3522?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17868997#comment-17868997 ] Mihai Budiu commented on CALCITE-3522: -- I was waiting for an approving review for

[jira] [Commented] (CALCITE-3522) Sql validator limits decimal literals to 64 bits

2024-07-26 Thread Seema B Gupta (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3522?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17868996#comment-17868996 ] Seema B Gupta commented on CALCITE-3522: Hi, We are using calcite and the limit

[jira] [Updated] (CALCITE-6504) JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect tree when using correlated sub-query in on clause of equi-join

2024-07-26 Thread Ian Bertolacci (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6504?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Bertolacci updated CALCITE-6504: Description: JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect trees

[jira] [Created] (CALCITE-6504) JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect tree when using correlated sub-query in on clause of equi-join

2024-07-26 Thread Ian Bertolacci (Jira)
Ian Bertolacci created CALCITE-6504: --- Summary: JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect tree when using correlated sub-query in on clause of equi-join Key: CALCITE-6504 URL: https:

[jira] [Updated] (CALCITE-6504) JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect tree when using correlated sub-query in on clause of equi-join

2024-07-26 Thread Ian Bertolacci (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6504?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Bertolacci updated CALCITE-6504: Description: JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect trees

[jira] [Created] (CALCITE-6503) Simple `NOT IN` is not pushed via JdbcAdapter

2024-07-26 Thread Corvin Kuebler (Jira)
Corvin Kuebler created CALCITE-6503: --- Summary: Simple `NOT IN` is not pushed via JdbcAdapter Key: CALCITE-6503 URL: https://issues.apache.org/jira/browse/CALCITE-6503 Project: Calcite Issue