[jira] [Created] (CALCITE-5667) Unexpected result with aggregate inside subquery

Evgeny Stanilovsky created CALCITE-5667: --- Summary: Unexpected result with aggregate inside subquery Key: CALCITE-5667 URL: https://issues.apache.org/jira/browse/CALCITE-5667 Project: Calcite

[jira] [Commented] (CALCITE-5656) RelToSqlConverter has an error using ordinal for ORDER BY

[ https://issues.apache.org/jira/browse/CALCITE-5656?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714805#comment-17714805 ] Benchao Li commented on CALCITE-5656: - [~luoping.zhang] Thanks for your contributio

[jira] [Commented] (CALCITE-5624) Add ARRAY function (enabled in Spark library)

[ https://issues.apache.org/jira/browse/CALCITE-5624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714804#comment-17714804 ] Guillaume Massé commented on CALCITE-5624: -- Thanks a lot! I hope it's one of m

[jira] [Commented] (CALCITE-5655) Wrong plan for multiple IN/SOME sub-queries with OR predicate

[ https://issues.apache.org/jira/browse/CALCITE-5655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714799#comment-17714799 ] Benchao Li commented on CALCITE-5655: - [~julianhyde] I've changed it to the origina

[jira] [Comment Edited] (CALCITE-5655) Wrong plan for multiple IN/SOME sub-queries with OR predicate

[ https://issues.apache.org/jira/browse/CALCITE-5655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714483#comment-17714483 ] Benchao Li edited comment on CALCITE-5655 at 4/21/23 2:08 AM: ---

[jira] [Updated] (CALCITE-5655) Wrong plan for multiple IN/SOME sub-queries with OR predicate

[ https://issues.apache.org/jira/browse/CALCITE-5655?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li updated CALCITE-5655: Summary: Wrong plan for multiple IN/SOME sub-queries with OR predicate (was: Intermediate table

[jira] [Commented] (CALCITE-5642) Add SHA256, SHA512 functions

[ https://issues.apache.org/jira/browse/CALCITE-5642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714796#comment-17714796 ] Willem Jiang commented on CALCITE-5642: --- Great, I doubled check the FAQ, which g

[jira] [Commented] (CALCITE-5624) Add ARRAY function (enabled in Spark library)

[ https://issues.apache.org/jira/browse/CALCITE-5624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714784#comment-17714784 ] Julian Hyde commented on CALCITE-5624: -- [~MasseGuillaume], nice work. I have revis

[jira] [Comment Edited] (CALCITE-5624) Add ARRAY function (enabled in Spark library)

[ https://issues.apache.org/jira/browse/CALCITE-5624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714784#comment-17714784 ] Julian Hyde edited comment on CALCITE-5624 at 4/21/23 1:08 AM: --

[jira] [Commented] (CALCITE-5156) Support implicit number type cast for IN Sub-query

[ https://issues.apache.org/jira/browse/CALCITE-5156?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714777#comment-17714777 ] Julian Hyde commented on CALCITE-5156: -- [~nobigo], I reviewed, and had similar con

[jira] [Commented] (CALCITE-5655) Intermediate table alias should be different to avoid wrong field reference lookup in subquery remove phase

[ https://issues.apache.org/jira/browse/CALCITE-5655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714776#comment-17714776 ] Julian Hyde commented on CALCITE-5655: -- [~Runking], Thanks for this fix; nice work

[jira] [Commented] (CALCITE-5662) CAST(BOOLEAN as INTEGER) throws a NumberFormatException

[ https://issues.apache.org/jira/browse/CALCITE-5662?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714773#comment-17714773 ] Oliver Lee commented on CALCITE-5662: - Hey Julian, I've updated my PR and now the

[jira] [Commented] (CALCITE-5449) Allow EXTRACT() to accept ISOWEEK and WEEK(WEEKDAY)

[ https://issues.apache.org/jira/browse/CALCITE-5449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714757#comment-17714757 ] TJ Banghart commented on CALCITE-5449: -- We were looking into this a bit further an

[jira] [Commented] (CALCITE-5663) [TestKit] RelOptFixture does not enforce the collation

[ https://issues.apache.org/jira/browse/CALCITE-5663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714715#comment-17714715 ] Marieke Gueye commented on CALCITE-5663: My initial thought was to add a new me

[jira] [Created] (CALCITE-5666) Add ISOWEEK and WEEK(WEEKDAY) to TimeUnit in Avatica

Tanner Clary created CALCITE-5666: - Summary: Add ISOWEEK and WEEK(WEEKDAY) to TimeUnit in Avatica Key: CALCITE-5666 URL: https://issues.apache.org/jira/browse/CALCITE-5666 Project: Calcite Is

[jira] [Commented] (CALCITE-2616) Can't create Unicode literal by RelBuilder

[ https://issues.apache.org/jira/browse/CALCITE-2616?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714686#comment-17714686 ] Tanner Clary commented on CALCITE-2616: --- I know this case is a few years old but

[jira] [Commented] (CALCITE-5001) Error for sql query with non-ascii characters with Oracle db

[ https://issues.apache.org/jira/browse/CALCITE-5001?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714677#comment-17714677 ] Tanner Clary commented on CALCITE-5001: --- I was wondering whether you ever found a

[jira] [Assigned] (CALCITE-5563) Reduce loops to optimize RelSubset#getParents and RelSubset#getParentSubsets

[ https://issues.apache.org/jira/browse/CALCITE-5563?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-5563: -- Assignee: asdfgh19 (was: Ruben Q L) > Reduce loops to optimize RelSubset#getParents and Rel

[jira] [Updated] (CALCITE-5563) Reduce loops to optimize RelSubset#getParents and RelSubset#getParentSubsets

[ https://issues.apache.org/jira/browse/CALCITE-5563?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5563: --- Summary: Reduce loops to optimize RelSubset#getParents and RelSubset#getParentSubsets (was: Reduce

[jira] [Assigned] (CALCITE-5563) Reduce loops to optimize RelSubset#getParents and RelSubset#getParentSubsets

[ https://issues.apache.org/jira/browse/CALCITE-5563?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-5563: -- Assignee: Ruben Q L (was: asdfgh19) > Reduce loops to optimize RelSubset#getParents and Rel

[jira] [Commented] (CALCITE-5646) JoinDeriveIsNotNullFilterRule incorrectly handles COALESCE in join condition

[ https://issues.apache.org/jira/browse/CALCITE-5646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714506#comment-17714506 ] Stamatis Zampetakis commented on CALCITE-5646: -- I think there is a bit of

[jira] [Comment Edited] (CALCITE-5309) Accept cursors as inputs of table functions

[ https://issues.apache.org/jira/browse/CALCITE-5309?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714497#comment-17714497 ] Bertil Chapuis edited comment on CALCITE-5309 at 4/20/23 9:16 AM: ---

[jira] [Updated] (CALCITE-5665) Reducing ineffective matches for MaterializedViewRules and double calculation for RelOptMaterialization's Metadata using cache

[ https://issues.apache.org/jira/browse/CALCITE-5665?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5665: Labels: pull-request-available (was: ) > Reducing ineffective matches for MaterializedVi

[jira] [Commented] (CALCITE-5309) Accept cursors as inputs of table functions

[ https://issues.apache.org/jira/browse/CALCITE-5309?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714497#comment-17714497 ] Bertil Chapuis commented on CALCITE-5309: - Thanks a lot for your answer, it hel

[jira] [Created] (CALCITE-5665) Reducing ineffective matches for MaterializedViewRules and double calculation for RelOptMaterialization's Metadata using cache

asdfgh19 created CALCITE-5665: - Summary: Reducing ineffective matches for MaterializedViewRules and double calculation for RelOptMaterialization's Metadata using cache Key: CALCITE-5665 URL: https://issues.apache.org/

[jira] [Created] (CALCITE-5664) Support CONVERT function with "USING" keyword

ZheHu created CALCITE-5664: -- Summary: Support CONVERT function with "USING" keyword Key: CALCITE-5664 URL: https://issues.apache.org/jira/browse/CALCITE-5664 Project: Calcite Issue Type: Improvement

[jira] [Resolved] (CALCITE-5655) Intermediate table alias should be different to avoid wrong field reference lookup in subquery remove phase

[ https://issues.apache.org/jira/browse/CALCITE-5655?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li resolved CALCITE-5655. - Fix Version/s: 1.35.0 Resolution: Fixed Fixed via [https://github.com/apache/calcite/co