[jira] [Commented] (CALCITE-5582) Not in or not exist subquery can't work with Oracle db

[ https://issues.apache.org/jira/browse/CALCITE-5582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17702197#comment-17702197 ] Benchao Li commented on CALCITE-5582: - I would take this as a problem that "Oracle dialect does not

[jira] [Updated] (CALCITE-5583) JDBC adapter generates 'SELECT *', which is invalid SQL if there are duplicate column names

[ https://issues.apache.org/jira/browse/CALCITE-5583?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5583: -- Description: JDBC adapter generates 'SELECT *', which is invalid SQL if there are duplicate column

[jira] [Updated] (CALCITE-5583) JDBC adapter generates 'SELECT *', which is invalid SQL if there are duplicate column names

[ https://issues.apache.org/jira/browse/CALCITE-5583?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5583: -- Summary: JDBC adapter generates 'SELECT *', which is invalid SQL if there are duplicate column names

[jira] [Commented] (CALCITE-5582) Not in or not exist subquery can't work with Oracle db

[ https://issues.apache.org/jira/browse/CALCITE-5582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17702196#comment-17702196 ] rebey commented on CALCITE-5582: Yeah, We're well aware of the cause. Therefore I hope Calcite core can

[jira] [Comment Edited] (CALCITE-5582) Not in or not exist subquery can't work with Oracle db

[ https://issues.apache.org/jira/browse/CALCITE-5582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17701249#comment-17701249 ] rebey edited comment on CALCITE-5582 at 3/19/23 4:19 AM: - Thanks for you reply

[jira] [Reopened] (CALCITE-5528) RelOptRulesTest testPushAggregateThroughJoin7 optimized query not equivalent to the original one

[ https://issues.apache.org/jira/browse/CALCITE-5528?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pinhan Zhao reopened CALCITE-5528: -- > RelOptRulesTest testPushAggregateThroughJoin7 optimized query not equivalent > to the

[jira] [Closed] (CALCITE-5528) RelOptRulesTest testPushAggregateThroughJoin7 optimized query not equivalent to the original one

[ https://issues.apache.org/jira/browse/CALCITE-5528?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pinhan Zhao closed CALCITE-5528. Resolution: Not A Bug > RelOptRulesTest testPushAggregateThroughJoin7 optimized query not

[jira] [Comment Edited] (CALCITE-5583) Rel2Sql will get an error when select * and join is present

[ https://issues.apache.org/jira/browse/CALCITE-5583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17702168#comment-17702168 ] Julian Hyde edited comment on CALCITE-5583 at 3/18/23 7:41 PM: --- Should

[jira] [Commented] (CALCITE-5583) Rel2Sql will get an error when select * and join is present

[ https://issues.apache.org/jira/browse/CALCITE-5583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17702168#comment-17702168 ] Julian Hyde commented on CALCITE-5583: -- Should the summary be the following? {{noformat}} JDBC

[jira] [Commented] (CALCITE-5381) Add configuration via property to turn on/off check if correlated in RelBuilder

[ https://issues.apache.org/jira/browse/CALCITE-5381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17702166#comment-17702166 ] Sergey Nuyanzin commented on CALCITE-5381: -- Merged at

[jira] [Resolved] (CALCITE-5381) Add configuration via property to turn on/off check if correlated in RelBuilder

[ https://issues.apache.org/jira/browse/CALCITE-5381?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin resolved CALCITE-5381. -- Fix Version/s: 1.35.0 Assignee: Sergey Nuyanzin Resolution: Fixed >

[jira] [Commented] (CALCITE-5592) SqlValidatorImpl#validateWhereOrOn does not derive the the correct operand type for '='

[ https://issues.apache.org/jira/browse/CALCITE-5592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17702153#comment-17702153 ] Julian Hyde commented on CALCITE-5592: -- The summary describes a fix rather than a problem. So,

[jira] [Comment Edited] (CALCITE-4771) change the value of the CAST function to be nullable

[ https://issues.apache.org/jira/browse/CALCITE-4771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17702148#comment-17702148 ] Julian Hyde edited comment on CALCITE-4771 at 3/18/23 5:24 PM: --- Reviewing

[jira] [Commented] (CALCITE-4771) change the value of the CAST function to be nullable

[ https://issues.apache.org/jira/browse/CALCITE-4771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17702148#comment-17702148 ] Julian Hyde commented on CALCITE-4771: -- Reviewing PR at 46a5ace25e: * Move the conformance check

[jira] [Resolved] (CALCITE-5554) Add DAYOFWEEK and DAYOFYEAR as valid synonyms of DOW, DOY

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

[jira] [Updated] (CALCITE-5593) Elasticsearch Aliases query is not supported

[ https://issues.apache.org/jira/browse/CALCITE-5593?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5593: Labels: pull-request-available (was: ) > Elasticsearch Aliases query is not supported >

[jira] [Updated] (CALCITE-5593) Elasticsearch Aliases query is not supported

[ https://issues.apache.org/jira/browse/CALCITE-5593?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lei Zhang updated CALCITE-5593: --- Description: I have a index is 'ndcp_metrics_collector_status_202303' and the alias is

[jira] [Created] (CALCITE-5593) Elasticsearch Aliases query is not supported

Lei Zhang created CALCITE-5593: -- Summary: Elasticsearch Aliases query is not supported Key: CALCITE-5593 URL: https://issues.apache.org/jira/browse/CALCITE-5593 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-5592) SqlValidatorImpl#validateWhereOrOn does not derive the the correct operand type for '='

Jianhui Dong created CALCITE-5592: - Summary: SqlValidatorImpl#validateWhereOrOn does not derive the the correct operand type for '=' Key: CALCITE-5592 URL: https://issues.apache.org/jira/browse/CALCITE-5592

[jira] [Commented] (CALCITE-5583) Rel2Sql will get an error when select * and join is present

[ https://issues.apache.org/jira/browse/CALCITE-5583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17702086#comment-17702086 ] libopeng commented on CALCITE-5583: --- "star" may be a property of the project that is passed from

[jira] [Resolved] (CALCITE-5574) Break MockCatalogReaderSimple#init into smaller methods

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

[jira] [Commented] (CALCITE-5582) Not in or not exist subquery can't work with Oracle db

[ https://issues.apache.org/jira/browse/CALCITE-5582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17702081#comment-17702081 ] Benchao Li commented on CALCITE-5582: - [~rebey] {{BOOLEAN}} is in the ISO Standard, most of