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

2024-07-27 Thread Corvin Kuebler (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6503?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Corvin Kuebler updated CALCITE-6503: Description: Hey all! Adding the following test to JdbcAdapterTests fails: {code:java

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

2024-07-27 Thread Corvin Kuebler (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6503?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Corvin Kuebler updated CALCITE-6503: Summary: Simple `NOT IN` filter is not pushed via JdbcAdapter (was: Simple

[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=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=17869048#comment-17869048 ] Ian Bertolacci commented on CALCITE-6504: - Some light math and playing around with DB-fiddle

[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=17869047#comment-17869047 ] Mihai Budiu commented on CALCITE-3522: -- I have changed the title of the issue, I hope it's not too

[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

[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=17869046#comment-17869046 ] Julian Hyde commented on CALCITE-3522: -- [~mbudiu], After 5 years the subject is still &quo

[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=17869042#comment-17869042 ] Norman Jordan commented on CALCITE-6020: I am working on adding more tests

[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=17869032#comment-17869032 ] James Starr edited comment on CALCITE-6504 at 7/26/24 10:37 PM: One way

[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=17869038#comment-17869038 ] Ian Bertolacci commented on CALCITE-6504: - We're currently investigating if pushing down

[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=17869037#comment-17869037 ] Seema B Gupta commented on CALCITE-3522: I agree with you on the above. I can write a test case

[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=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=17869035#comment-17869035 ] Mihai Budiu commented on CALCITE-3522: -- I propose to do this in two steps: - if this PR helps

[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=17869034#comment-17869034 ] Seema B Gupta commented on CALCITE-3522: Yes we do have an override on the RelDataType

[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=17869032#comment-17869032 ] James Starr commented on CALCITE-6504: -- One way of handling this is for an inner join, just

[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

[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

[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=17869000#comment-17869000 ] Mihai Budiu commented on CALCITE-3522: -- This code has nothing to do with predicates, it just

[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=17868999#comment-17868999 ] Seema B Gupta commented on CALCITE-3522: Yes I can help with testing the fix with my feature

[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=17868997#comment-17868997 ] Mihai Budiu commented on CALCITE-3522: -- I was waiting for an approving review for the PR https

[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=17868996#comment-17868996 ] Seema B Gupta commented on CALCITE-3522: Hi, We are using calcite and the limitation

[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

[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)
://issues.apache.org/jira/browse/CALCITE-6504 Project: Calcite Issue Type: Bug Reporter: Ian Bertolacci JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect trees when using a correlated sub-query as part of an equi-join condition of a join

[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

[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

[jira] [Updated] (CALCITE-6502) Parser loses position information for Expression3

2024-07-26 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6502: Labels: pull-request-available (was: ) > Parser loses position informat

[jira] [Created] (CALCITE-6502) Parser loses position information for Expression3

2024-07-25 Thread Mihai Budiu (Jira)
Mihai Budiu created CALCITE-6502: Summary: Parser loses position information for Expression3 Key: CALCITE-6502 URL: https://issues.apache.org/jira/browse/CALCITE-6502 Project: Calcite Issue

[jira] [Commented] (CALCITE-6372) Support ASOF joins

2024-07-25 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6372?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868761#comment-17868761 ] Mihai Budiu commented on CALCITE-6372: -- The one feature missing from this PR is the ability to do

[jira] [Updated] (CALCITE-6498) Elasticsearch multi-field mappings do not work

2024-07-25 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6498?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6498: Labels: pull-request-available (was: ) > Elasticsearch multi-field mappings do not w

[jira] [Updated] (CALCITE-6471) Improve performance of SqlToRelConverter by preventing unconditional conversion of sqlNodes to string for null-check messages

2024-07-25 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6471: Labels: pull-request-available (was: ) > Improve performance of SqlToRelConver

[jira] [Comment Edited] (CALCITE-6501) Assertion Error in JoinUnifyRule Due to Type Mismatch

2024-07-25 Thread kate (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868668#comment-17868668 ] kate edited comment on CALCITE-6501 at 7/25/24 2:43 PM: Apologies, I would like

[jira] [Commented] (CALCITE-6501) Assertion Error in JoinUnifyRule Due to Type Mismatch

2024-07-25 Thread kate (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868668#comment-17868668 ] kate commented on CALCITE-6501: --- [~asolimando] Yes, I agree that we shouldn't be discussing this together

[jira] [Comment Edited] (CALCITE-6501) Assertion Error in JoinUnifyRule Due to Type Mismatch

2024-07-25 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868621#comment-17868621 ] Alessandro Solimando edited comment on CALCITE-6501 at 7/25/24 9:53 AM

[jira] [Commented] (CALCITE-6501) Assertion Error in JoinUnifyRule Due to Type Mismatch

2024-07-25 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868621#comment-17868621 ] Alessandro Solimando commented on CALCITE-6501: --- I agree, and at the same time

[jira] [Commented] (CALCITE-6501) Assertion Error in JoinUnifyRule Due to Type Mismatch

2024-07-25 Thread kate (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868620#comment-17868620 ] kate commented on CALCITE-6501: --- This is because the left input field of the Right Join will be Nullable

[jira] [Created] (CALCITE-6501) Assertion Error in JoinUnifyRule Due to Type Mismatch

2024-07-25 Thread kate (Jira)
kate created CALCITE-6501: - Summary: Assertion Error in JoinUnifyRule Due to Type Mismatch Key: CALCITE-6501 URL: https://issues.apache.org/jira/browse/CALCITE-6501 Project: Calcite Issue Type: Bug

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

2024-07-25 Thread Zoltan Haindrich (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868608#comment-17868608 ] Zoltan Haindrich commented on CALCITE-6020: --- seems like I've never updated the ticket about

[jira] [Resolved] (CALCITE-6473) HAVING clauses may not contain window functions

2024-07-25 Thread Zoltan Haindrich (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6473?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zoltan Haindrich resolved CALCITE-6473. --- Fix Version/s: 1.38.0 Resolution: Fixed merged into master

[jira] [Updated] (CALCITE-6372) Support ASOF joins

2024-07-24 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6372?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6372: Labels: pull-request-available (was: ) > Support ASOF jo

[jira] [Updated] (CALCITE-6500) Aggregation inside Window clause nodes fails when the query is written with a different syntax

2024-07-24 Thread Sree Charan Manamala (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6500?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sree Charan Manamala updated CALCITE-6500: -- Description: A query like {code:java} SELECT row_number() over (partition

[jira] [Commented] (CALCITE-6500) Aggregation inside Window clause nodes fails when the query is written with a different syntax

2024-07-24 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6500?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868529#comment-17868529 ] Julian Hyde commented on CALCITE-6500: -- Ah, I see you already did it. Thank you. (I'd use

[jira] [Commented] (CALCITE-6500) Aggregation inside Window clause nodes fails when the query is written with a different syntax

2024-07-24 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6500?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868528#comment-17868528 ] Julian Hyde commented on CALCITE-6500: -- [~sree.manamala], Jira has a different [markup format

[jira] [Updated] (CALCITE-6500) Aggregation inside Window clause nodes fails when the query is written with a different syntax

2024-07-24 Thread Sree Charan Manamala (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6500?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sree Charan Manamala updated CALCITE-6500: -- Description: A query like {code:java} SELECT row_number() over (partition

[jira] [Updated] (CALCITE-6500) Aggregation inside Window clause nodes fails when the query is written with a different syntax

2024-07-24 Thread Sree Charan Manamala (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6500?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sree Charan Manamala updated CALCITE-6500: -- Description: A query like   {code:java} SELECT row_number() over (partition

[jira] [Updated] (CALCITE-6500) Aggregation inside Window clause nodes fails when the query is written with a different syntax

2024-07-24 Thread Sree Charan Manamala (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6500?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sree Charan Manamala updated CALCITE-6500: -- Description: A query like ``` SELECT row_number() over (partition by aggr

[jira] [Created] (CALCITE-6500) Aggregation inside Window clause nodes fails when the query is written with a different syntax

2024-07-24 Thread Sree Charan Manamala (Jira)
Sree Charan Manamala created CALCITE-6500: - Summary: Aggregation inside Window clause nodes fails when the query is written with a different syntax Key: CALCITE-6500 URL: https://issues.apache.org/jira

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

2024-07-24 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868504#comment-17868504 ] Julian Hyde commented on CALCITE-6020: -- The decision whether to convert {{SUM}} to {{SUM0}} should

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

2024-07-24 Thread Norman Jordan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868493#comment-17868493 ] Norman Jordan commented on CALCITE-6020: [~jhyde] Update PR here. [https://github.com/apache

[jira] [Created] (CALCITE-6499) Deep Clone SqlNodes

2024-07-24 Thread Ian Bertolacci (Jira)
Ian Bertolacci created CALCITE-6499: --- Summary: Deep Clone SqlNodes Key: CALCITE-6499 URL: https://issues.apache.org/jira/browse/CALCITE-6499 Project: Calcite Issue Type: Improvement

[jira] [Commented] (CALCITE-6372) Support ASOF joins

2024-07-24 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6372?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868436#comment-17868436 ] Mihai Budiu commented on CALCITE-6372: -- I have a working implementation which I plan to submit

[jira] [Updated] (CALCITE-6498) Elasticsearch multi-field mappings do not work

2024-07-24 Thread Tim Grein (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6498?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tim Grein updated CALCITE-6498: --- Description: _EmbeddedElasticsearchPolicy#_ _applyMapping_ tries to apply a multi-field mapping

[jira] [Updated] (CALCITE-6498) Elasticsearch multi-field mappings do not work

2024-07-24 Thread Tim Grein (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6498?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tim Grein updated CALCITE-6498: --- Description: _EmbeddedElasticsearchPolicy#_ _applyMapping_ tries to apply a multi-field mapping

[jira] [Updated] (CALCITE-6498) Elasticsearch multi-field mappings do not work

2024-07-24 Thread Tim Grein (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6498?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tim Grein updated CALCITE-6498: --- Description: _EmbeddedElasticsearchPolicy#_ _applyMapping_ tries to apply a multi-field mapping

[jira] [Updated] (CALCITE-6498) Elasticsearch multi-field mappings do not work

2024-07-24 Thread Tim Grein (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6498?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tim Grein updated CALCITE-6498: --- Summary: Elasticsearch multi-field mappings do not work (was: Elasticsearch nested mappings do

[jira] [Resolved] (CALCITE-6497) Use helper setup method throughout whole ElasticsearchAdapterTest

2024-07-24 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6497?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando resolved CALCITE-6497. --- Resolution: Fixed Fixed via [{{15a5360}}|https://github.com/apache

[jira] [Updated] (CALCITE-6498) Elasticsearch nested mappings do not work

2024-07-24 Thread Tim Grein (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6498?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tim Grein updated CALCITE-6498: --- Description: _EmbeddedElasticsearchPolicy#_ _applyMapping_ tries to apply a nested mapping

[jira] [Created] (CALCITE-6498) Elasticsearch nested mappings do not work

2024-07-24 Thread Tim Grein (Jira)
Tim Grein created CALCITE-6498: -- Summary: Elasticsearch nested mappings do not work Key: CALCITE-6498 URL: https://issues.apache.org/jira/browse/CALCITE-6498 Project: Calcite Issue Type: Bug

[jira] [Updated] (CALCITE-6497) Use helper setup method throughout whole ElasticsearchAdapterTest

2024-07-24 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6497?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-6497: -- Component/s: elasticsearch-adapter > Use helper setup method through

[jira] [Updated] (CALCITE-6497) Use helper setup method throughout whole ElasticsearchAdapterTest

2024-07-24 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6497?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6497: Labels: pull-request-available (was: ) > Use helper setup method throughout wh

[jira] [Created] (CALCITE-6497) Use helper setup method throughout whole ElasticsearchAdapterTest

2024-07-24 Thread Tim Grein (Jira)
Tim Grein created CALCITE-6497: -- Summary: Use helper setup method throughout whole ElasticsearchAdapterTest Key: CALCITE-6497 URL: https://issues.apache.org/jira/browse/CALCITE-6497 Project: Calcite

[jira] [Resolved] (CALCITE-6482) Oracle dialect convert boolean literal when version < 23

2024-07-23 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6482?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan resolved CALCITE-6482. - Fix Version/s: 1.38.0 Resolution: Fixed > Oracle dialect convert boolean literal w

[jira] [Commented] (CALCITE-6482) Oracle dialect convert boolean literal when version < 23

2024-07-23 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868207#comment-17868207 ] xiong duan commented on CALCITE-6482: - Fixed in [1947312|https://github.com/apache/calcite/commit

[jira] [Commented] (CALCITE-6482) Oracle dialect convert boolean literal when version < 23

2024-07-23 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868206#comment-17868206 ] xiong duan commented on CALCITE-6482: - [~suibianwanwan33]  I guess we need to add your account

[jira] [Created] (CALCITE-6496) Enable tests from outer.iq

2024-07-23 Thread Mihai Budiu (Jira)
Mihai Budiu created CALCITE-6496: Summary: Enable tests from outer.iq Key: CALCITE-6496 URL: https://issues.apache.org/jira/browse/CALCITE-6496 Project: Calcite Issue Type: Improvement

[jira] [Comment Edited] (CALCITE-6492) Support aggregate functions which could process DISTINCT natively

2024-07-23 Thread Zoltan Haindrich (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6492?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868048#comment-17868048 ] Zoltan Haindrich edited comment on CALCITE-6492 at 7/23/24 3:22 PM

[jira] [Commented] (CALCITE-6489) Add more data types to the Arrow test set

2024-07-23 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868080#comment-17868080 ] Caican Cai commented on CALCITE-6489: - I agree to close this PR first. I will adapt the new arrow

[jira] [Closed] (CALCITE-6489) Add more data types to the Arrow test set

2024-07-23 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6489?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai closed CALCITE-6489. --- Resolution: Not A Bug > Add more data types to the Arrow test

[jira] [Commented] (CALCITE-6292) Support more Arrow types

2024-07-23 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868074#comment-17868074 ] Caican Cai commented on CALCITE-6292: - [~asolimando]I agree with your approach. I will try to adapt

[jira] [Commented] (CALCITE-6489) Add more data types to the Arrow test set

2024-07-23 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868072#comment-17868072 ] Caican Cai commented on CALCITE-6489: - [~asolimando] Hello, thank you for your reply. I just wanted

[jira] [Commented] (CALCITE-6482) Oracle dialect convert boolean literal when version < 23

2024-07-23 Thread kate (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868065#comment-17868065 ] kate commented on CALCITE-6482: --- [~asolimando] Is it because I'm missing some kind of identification

[jira] [Commented] (CALCITE-6482) Oracle dialect convert boolean literal when version < 23

2024-07-23 Thread kate (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868060#comment-17868060 ] kate commented on CALCITE-6482: --- [~nobigo] Yes, I should. > Oracle dialect convert boolean literal w

[jira] [Updated] (CALCITE-6482) Oracle dialect convert boolean literal when version < 23

2024-07-23 Thread kate (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6482?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] kate updated CALCITE-6482: -- Description: Lower versions of oracle do not support boolean type literal, in OracleDialect, we can

[jira] [Commented] (CALCITE-6489) Add more data types to the Arrow test set

2024-07-23 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868058#comment-17868058 ] Alessandro Solimando commented on CALCITE-6489: --- Supporting TINYINT and SMALLINT

[jira] [Resolved] (CALCITE-6495) Allow ProjectSetOpTransposeRule to work with any subclass of Project

2024-07-23 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-6495. Resolution: Fixed Done in   [{{a1b5fdf}}|https://github.com/apache/calcite/commit

[jira] [Commented] (CALCITE-6482) Oracle dialect convert boolean literal when version < 23

2024-07-23 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868050#comment-17868050 ] Alessandro Solimando commented on CALCITE-6482: --- I also tried to assign

[jira] [Commented] (CALCITE-6492) Support aggregate functions which could process DISTINCT natively

2024-07-23 Thread Zoltan Haindrich (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6492?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868048#comment-17868048 ] Zoltan Haindrich commented on CALCITE-6492: --- I might have missed the distinction between

[jira] [Commented] (CALCITE-6482) Oracle dialect convert boolean literal when version < 23

2024-07-23 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868045#comment-17868045 ] xiong duan commented on CALCITE-6482: - [~suibianwanwan33] Hi, The PR is about to be merged, and you

[jira] [Updated] (CALCITE-6482) Oracle dialect convert boolean literal when version < 23

2024-07-23 Thread kate (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6482?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] kate updated CALCITE-6482: -- Summary: Oracle dialect convert boolean literal when version < 23 (was: OracleDialect support bool lite

[jira] [Updated] (CALCITE-6495) Allow ProjectSetOpTransposeRule to work with any subclass of Project

2024-07-23 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6495: Labels: pull-request-available (was: ) > Allow ProjectSetOpTransposeRule to w

[jira] [Assigned] (CALCITE-6495) Allow ProjectSetOpTransposeRule to work with any subclass of Project

2024-07-23 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-6495: -- Assignee: Ruben Q L > Allow ProjectSetOpTransposeRule to work with any subclass of Proj

[jira] [Created] (CALCITE-6495) Allow ProjectSetOpTransposeRule to work with any subclass of Project

2024-07-23 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-6495: -- Summary: Allow ProjectSetOpTransposeRule to work with any subclass of Project Key: CALCITE-6495 URL: https://issues.apache.org/jira/browse/CALCITE-6495 Project: Calcite

[jira] [Updated] (CALCITE-6494) MongoAdapter throws an exception if any function unsupported by MongoProject is used

2024-07-23 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-6494: --- Description: MongoAdapter throws an exception if any function unsupported

[jira] [Updated] (CALCITE-6494) MongoAdapter throws an exception if any function unsupported by MongoProject is used

2024-07-23 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-6494: --- Description: MongoAdapter throws an exception if any function unsupported

[jira] [Updated] (CALCITE-6494) MongoAdapter throws an exception if any function unsupported by MongoProject is used

2024-07-23 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-6494: --- Description: MongoAdapter throws an exception if any function unsupported

[jira] [Created] (CALCITE-6494) MongoAdapter throws an exception if any function unsupported by MongoProject is used

2024-07-23 Thread Dmitry Sysolyatin (Jira)
Dmitry Sysolyatin created CALCITE-6494: -- Summary: MongoAdapter throws an exception if any function unsupported by MongoProject is used Key: CALCITE-6494 URL: https://issues.apache.org/jira/browse/CALCITE

[jira] [Commented] (CALCITE-6292) Support more Arrow types

2024-07-23 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867996#comment-17867996 ] Alessandro Solimando commented on CALCITE-6292: --- My rule of thumb is, when it's not about

[jira] [Updated] (CALCITE-6292) Support more Arrow types

2024-07-23 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-6292: -- Affects Version/s: 1.37.0 > Support more Arrow ty

[jira] [Updated] (CALCITE-6292) Support more Arrow types

2024-07-23 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-6292: -- Summary: Support more Arrow types (was: Support more Arrow type) > Supp

[jira] [Resolved] (CALCITE-6485) AssertionError When an IN list containing NULL has an implicit coercion type converter

2024-07-23 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6485?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan resolved CALCITE-6485. - Fix Version/s: 1.38.0 Resolution: Fixed > AssertionError When an IN list contain

[jira] [Commented] (CALCITE-6485) AssertionError When an IN list containing NULL has an implicit coercion type converter

2024-07-23 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6485?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867990#comment-17867990 ] xiong duan commented on CALCITE-6485: - Fixed in [6164a037|https://github.com/apache/calcite/commit

[jira] [Comment Edited] (CALCITE-6493) Improve Calcite development documentation

2024-07-22 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867922#comment-17867922 ] Caican Cai edited comment on CALCITE-6493 at 7/23/24 2:21 AM

[jira] [Commented] (CALCITE-6493) Improve Calcite development documentation

2024-07-22 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867922#comment-17867922 ] Caican Cai commented on CALCITE-6493: - It seems difficult to add all of them to LintTest, because I

[jira] [Commented] (CALCITE-6492) Support aggregate functions which could process DISTINCT natively

2024-07-22 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6492?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867918#comment-17867918 ] Julian Hyde commented on CALCITE-6492: -- There are two aspects of an aggregate function

[jira] [Comment Edited] (CALCITE-6492) Support aggregate functions which could process DISTINCT natively

2024-07-22 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6492?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867918#comment-17867918 ] Julian Hyde edited comment on CALCITE-6492 at 7/23/24 1:44 AM

[jira] [Commented] (CALCITE-6489) Add more data types to the Arrow test set

2024-07-22 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867915#comment-17867915 ] xiong duan commented on CALCITE-6489: - [~caicancai] I review the PR. Maybe we can change

[jira] [Resolved] (CALCITE-2032) Error when implicitly converting character literal to date literal

2024-07-22 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2032?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-2032. -- Fix Version/s: 1.38.0 Resolution: Fixed This has probably been fixed for a long while

[jira] [Commented] (CALCITE-5869) LEAST_RESTRICTIVE does not use inner type of MEASURE for comparisons

2024-07-22 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5869?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867912#comment-17867912 ] Julian Hyde commented on CALCITE-5869: -- I revised the fix in [bb94122|https://github.com/apache

[jira] [Resolved] (CALCITE-5802) In RelBuilder add method aggregateRex, to allow aggregating complex expressions such as "1 + SUM(x + 2)"

2024-07-22 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5802?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5802. -- Fix Version/s: 1.38.0 Resolution: Fixed Fixed in [467e509|https://github.com/apache

[jira] [Commented] (CALCITE-6013) RelBuilder should simplify plan by pruning unused measures

2024-07-22 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867911#comment-17867911 ] Julian Hyde commented on CALCITE-6013: -- I revised the fix in [5b996bd|https://github.com/apache

[jira] [Resolved] (CALCITE-4496) Measure columns ("SELECT ... AS MEASURE")

2024-07-22 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4496?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-4496. -- Fix Version/s: 1.38.0 Resolution: Fixed Fixed in [66919e4|https://github.com/apache

  1   2   3   4   5   6   7   8   9   10   >