[jira] [Commented] (CALCITE-3463) Parse SQL Query - Non-query expression encountered in illegal context

[ https://issues.apache.org/jira/browse/CALCITE-3463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16964620#comment-16964620 ] Yunpeng Niu commented on CALCITE-3463: -- The idea is: there are many different modes and different

[jira] [Closed] (CALCITE-2855) Make RelMetadataQuery in RelOptCluster pluggable

[ https://issues.apache.org/jira/browse/CALCITE-2855?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen closed CALCITE-2855. --- Resolution: Duplicate Close because it is a duplicated by CALCITE-3446. > Make RelMetadataQuery

[jira] [Commented] (CALCITE-3463) Parse SQL Query - Non-query expression encountered in illegal context

[ https://issues.apache.org/jira/browse/CALCITE-3463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16964566#comment-16964566 ] Wang Yanlin commented on CALCITE-3463: -- [~yunpengn] I think you can update your sql like this

[jira] [Commented] (CALCITE-3467) Fix PartialMapping mistake

[ https://issues.apache.org/jira/browse/CALCITE-3467?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16964557#comment-16964557 ] Wang Yanlin commented on CALCITE-3467: -- I don't get what the mistake is. Any more details? > Fix

[jira] [Updated] (CALCITE-3463) Parse SQL Query - Non-query expression encountered in illegal context

[ https://issues.apache.org/jira/browse/CALCITE-3463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3463: Issue Type: Improvement (was: Bug) > Parse SQL Query - Non-query expression encountered in

[jira] [Commented] (CALCITE-3463) Parse SQL Query - Non-query expression encountered in illegal context

[ https://issues.apache.org/jira/browse/CALCITE-3463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16964496#comment-16964496 ] Danny Chen commented on CALCITE-3463: - If you agree that this is not standard SQL syntax, then this

[jira] [Updated] (CALCITE-3467) Fix PartialMapping mistake

[ https://issues.apache.org/jira/browse/CALCITE-3467?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3467: Summary: Fix PartialMapping mistake (was: fix PartialMapping mistake and Cosmetic Change) >

[jira] [Commented] (CALCITE-3457) RexSimplify incorrectly simplifies IS NOT NULL operator with ITEM call

[ https://issues.apache.org/jira/browse/CALCITE-3457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16964494#comment-16964494 ] Danny Chen commented on CALCITE-3457: - Okey, it seems that CALCITE-2695 has breaks the Strong

[jira] [Commented] (CALCITE-3468) Oracle cast to varchar does not use precision when it should

[ https://issues.apache.org/jira/browse/CALCITE-3468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16964487#comment-16964487 ] Danny Chen commented on CALCITE-3468: - In OracleSqlDialect, we may need to fix the VARCHAR type

[jira] [Created] (CALCITE-3468) Oracle cast to varchar does not use precision when it should

Lindsey Meyer created CALCITE-3468: -- Summary: Oracle cast to varchar does not use precision when it should Key: CALCITE-3468 URL: https://issues.apache.org/jira/browse/CALCITE-3468 Project: Calcite

[jira] [Commented] (CALCITE-3457) RexSimplify incorrectly simplifies IS NOT NULL operator with ITEM call

[ https://issues.apache.org/jira/browse/CALCITE-3457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16964226#comment-16964226 ] Vova Vysotskyi commented on CALCITE-3457: - I tried to add this assertion, but it will cause

[jira] [Updated] (CALCITE-3467) fix PartialMapping mistake and Cosmetic Change

[ https://issues.apache.org/jira/browse/CALCITE-3467?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-3467: Description: fix PartialMapping mistake and Cosmetic Change

[jira] [Updated] (CALCITE-3467) fix PartialMapping mistake and Cosmetic Change

[ https://issues.apache.org/jira/browse/CALCITE-3467?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3467: Labels: pull-request-available (was: ) > fix PartialMapping mistake and Cosmetic Change

[jira] [Created] (CALCITE-3467) fix PartialMapping mistake and Cosmetic Change

xzh_dz created CALCITE-3467: --- Summary: fix PartialMapping mistake and Cosmetic Change Key: CALCITE-3467 URL: https://issues.apache.org/jira/browse/CALCITE-3467 Project: Calcite Issue Type: Wish

[jira] [Commented] (CALCITE-3463) Parse SQL Query - Non-query expression encountered in illegal context

[ https://issues.apache.org/jira/browse/CALCITE-3463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16964078#comment-16964078 ] Yunpeng Niu commented on CALCITE-3463: -- Hi [~danny0405], Yes, I think it is a good idea for us to

[jira] [Comment Edited] (CALCITE-3463) Parse SQL Query - Non-query expression encountered in illegal context

[ https://issues.apache.org/jira/browse/CALCITE-3463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16963985#comment-16963985 ] Wang Yanlin edited comment on CALCITE-3463 at 10/31/19 1:43 PM: I tried

[jira] [Comment Edited] (CALCITE-3463) Parse SQL Query - Non-query expression encountered in illegal context

[ https://issues.apache.org/jira/browse/CALCITE-3463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16963985#comment-16963985 ] Wang Yanlin edited comment on CALCITE-3463 at 10/31/19 1:41 PM: I tried

[jira] [Commented] (CALCITE-3463) Parse SQL Query - Non-query expression encountered in illegal context

[ https://issues.apache.org/jira/browse/CALCITE-3463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16963985#comment-16963985 ] Wang Yanlin commented on CALCITE-3463: -- I tried on mysql, it really works, at least no parsing

[jira] [Updated] (CALCITE-3463) Parse SQL Query - Non-query expression encountered in illegal context

[ https://issues.apache.org/jira/browse/CALCITE-3463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3463: - Attachment: image-2019-10-31-21-11-41-225.png > Parse SQL Query - Non-query expression

[jira] [Commented] (CALCITE-3466) JDBC adapter dropped group by statement in subquery

[ https://issues.apache.org/jira/browse/CALCITE-3466?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16963973#comment-16963973 ] Wang Yanlin commented on CALCITE-3466: -- {code:java} select a, avg(c1) from ( select

[jira] [Updated] (CALCITE-3466) JDBC adapter dropped group by statement in subquery

[ https://issues.apache.org/jira/browse/CALCITE-3466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3466: -- Description: While convert RelNode to SqlNode, the "group by" statement in subquery was

[jira] [Updated] (CALCITE-3466) JDBC adapter dropped group by statement in subquery

[ https://issues.apache.org/jira/browse/CALCITE-3466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3466: -- Description: While convert RelNode to SqlNode, the "group by" statement in subquery was

[jira] [Commented] (CALCITE-3463) Parse SQL Query - Non-query expression encountered in illegal context

[ https://issues.apache.org/jira/browse/CALCITE-3463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16963928#comment-16963928 ] Danny Chen commented on CALCITE-3463: - This is the syntax i found in standard SQL 2011 7.7 :

[jira] [Updated] (CALCITE-3466) JDBC adapter dropped group by statement in subquery

[ https://issues.apache.org/jira/browse/CALCITE-3466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3466: -- Description: While convert RelNode to SqlNode, the "group by" statement in subquery was

[jira] [Updated] (CALCITE-3466) JDBC adapter dropped group by statement in subquery

[ https://issues.apache.org/jira/browse/CALCITE-3466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3466: -- Description: While convert RelNode to SqlNode, the "group by" statement in subquery was

[jira] [Updated] (CALCITE-3466) JDBC adapter dropped group by statement in subquery

[ https://issues.apache.org/jira/browse/CALCITE-3466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3466: -- Description: While convert RelNode to SqlNode, the "group by" statement in subquery was

[jira] [Created] (CALCITE-3466) JDBC adapter dropped group by statement in subquery

Wang Weidong created CALCITE-3466: - Summary: JDBC adapter dropped group by statement in subquery Key: CALCITE-3466 URL: https://issues.apache.org/jira/browse/CALCITE-3466 Project: Calcite

[jira] [Commented] (CALCITE-3464) RexSimplify simplifies plan having filter with NULL to empty values

[ https://issues.apache.org/jira/browse/CALCITE-3464?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16963892#comment-16963892 ] Wang Yanlin commented on CALCITE-3464: -- Hi， [~zabetak] and [~kgyrtkirk], very thanks for your fast

[jira] [Closed] (CALCITE-3464) RexSimplify simplifies plan having filter with NULL to empty values

[ https://issues.apache.org/jira/browse/CALCITE-3464?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin closed CALCITE-3464. Assignee: Wang Yanlin Resolution: Not A Problem > RexSimplify simplifies plan having

[jira] [Updated] (CALCITE-3464) RexSimplify simplifies plan having filter with NULL to empty values

[ https://issues.apache.org/jira/browse/CALCITE-3464?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3464: - Attachment: pics.jpg > RexSimplify simplifies plan having filter with NULL to empty values >

[jira] [Assigned] (CALCITE-2274) Filter predicates aren't inferred while using dynamic star in subquery

[ https://issues.apache.org/jira/browse/CALCITE-2274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vova Vysotskyi reassigned CALCITE-2274: --- Assignee: (was: Vitalii Diravka) > Filter predicates aren't inferred while

[jira] [Assigned] (CALCITE-2296) Extra logic to derive additional filters in the FilterJoinRule

[ https://issues.apache.org/jira/browse/CALCITE-2296?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vova Vysotskyi reassigned CALCITE-2296: --- Assignee: (was: Vitalii Diravka) > Extra logic to derive additional filters

[jira] [Assigned] (CALCITE-2241) Join equality condition should be considered while pushing down filter conditions with expressions disjunction for both tables

[ https://issues.apache.org/jira/browse/CALCITE-2241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vova Vysotskyi reassigned CALCITE-2241: --- Assignee: (was: Vitalii Diravka) > Join equality condition should be

[jira] [Comment Edited] (CALCITE-3463) Parse SQL Query - Non-query expression encountered in illegal context

[ https://issues.apache.org/jira/browse/CALCITE-3463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16963848#comment-16963848 ] Yunpeng Niu edited comment on CALCITE-3463 at 10/31/19 10:29 AM: - Hi

[jira] [Commented] (CALCITE-3463) Parse SQL Query - Non-query expression encountered in illegal context

[ https://issues.apache.org/jira/browse/CALCITE-3463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16963848#comment-16963848 ] Yunpeng Niu commented on CALCITE-3463: -- Hi [~danny0405], Thanks for following up. I believe you

[jira] [Commented] (CALCITE-3465) Cover Cassandra 3.x data types

[ https://issues.apache.org/jira/browse/CALCITE-3465?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16963842#comment-16963842 ] Alessandro Solimando commented on CALCITE-3465: --- There are few entries for which I am not

[jira] [Created] (CALCITE-3465) Cover Cassandra 3.x data types

Alessandro Solimando created CALCITE-3465: - Summary: Cover Cassandra 3.x data types Key: CALCITE-3465 URL: https://issues.apache.org/jira/browse/CALCITE-3465 Project: Calcite Issue

[jira] [Updated] (CALCITE-3463) Parse SQL Query - Non-query expression encountered in illegal context

[ https://issues.apache.org/jira/browse/CALCITE-3463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yunpeng Niu updated CALCITE-3463: - Description: I tried to ask calcite-core to parse the following SQL query:   {code:java}

[jira] [Commented] (CALCITE-3464) RexSimplify simplifies plan having filter with NULL to empty values

[ https://issues.apache.org/jira/browse/CALCITE-3464?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16963839#comment-16963839 ] Zoltan Haindrich commented on CALCITE-3464: --- [~zabetak] you are fast :D [~yanlin-Lynn] if you

[jira] [Updated] (CALCITE-3463) Parse SQL Query - Non-query expression encountered in illegal context

[ https://issues.apache.org/jira/browse/CALCITE-3463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yunpeng Niu updated CALCITE-3463: - Description: I tried to ask calcite-core to parse the following SQL query:   {code:java}

[jira] [Commented] (CALCITE-3464) RexSimplify simplifies plan having filter with NULL to empty values

[ https://issues.apache.org/jira/browse/CALCITE-3464?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16963834#comment-16963834 ] Stamatis Zampetakis commented on CALCITE-3464: -- Hi [~yanlin-Lynn], name = NULL is unknown

[jira] [Created] (CALCITE-3464) RexSimplify simplifies plan having filter with NULL to empty values

Wang Yanlin created CALCITE-3464: Summary: RexSimplify simplifies plan having filter with NULL to empty values Key: CALCITE-3464 URL: https://issues.apache.org/jira/browse/CALCITE-3464 Project:

[jira] [Commented] (CALCITE-3462) Add method in RelBuilder for conveniently projecting out expressions

[ https://issues.apache.org/jira/browse/CALCITE-3462?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16963814#comment-16963814 ] Stamatis Zampetakis commented on CALCITE-3462: -- Thanks for the feedback [~julianhyde].

[jira] [Commented] (CALCITE-3461) SqlToRelConverter substituteSubQuery problem

[ https://issues.apache.org/jira/browse/CALCITE-3461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16963799#comment-16963799 ] Stamatis Zampetakis commented on CALCITE-3461: -- If this ticket is a duplicate we should

[jira] [Commented] (CALCITE-3463) Parse SQL Query - Non-query expression encountered in illegal context

[ https://issues.apache.org/jira/browse/CALCITE-3463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16963786#comment-16963786 ] Danny Chen commented on CALCITE-3463: - Calcite's grammar always keep in line with the standard SQL,

[jira] [Commented] (CALCITE-2970) Performance issue when enabling abstract converter for EnumerableConvention

[ https://issues.apache.org/jira/browse/CALCITE-2970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16963783#comment-16963783 ] Stamatis Zampetakis commented on CALCITE-2970: -- Thanks for the analysis [~xndai],

[jira] [Created] (CALCITE-3463) Parse SQL Query - Non-query expression encountered in illegal context

Yunpeng Niu created CALCITE-3463: Summary: Parse SQL Query - Non-query expression encountered in illegal context Key: CALCITE-3463 URL: https://issues.apache.org/jira/browse/CALCITE-3463 Project:

[jira] [Commented] (CALCITE-3461) SqlToRelConverter substituteSubQuery problem

[ https://issues.apache.org/jira/browse/CALCITE-3461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16963713#comment-16963713 ] Danny Chen commented on CALCITE-3461: - https://github.com/apache/calcite/pull/1553 is still open,

[jira] [Commented] (CALCITE-3299) Replace star identifier as select list of if no operands given while in the method "createCall"

[ https://issues.apache.org/jira/browse/CALCITE-3299?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16963700#comment-16963700 ] Wang Weidong commented on CALCITE-3299: --- Anyone response this issue? > Replace star identifier

[jira] [Commented] (CALCITE-3461) SqlToRelConverter substituteSubQuery problem

[ https://issues.apache.org/jira/browse/CALCITE-3461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16963692#comment-16963692 ] TisNotT commented on CALCITE-3461: -- I commit again,but the pr is not open. I donnot know why.I think

[jira] [Updated] (CALCITE-3461) SqlToRelConverter substituteSubQuery problem

[ https://issues.apache.org/jira/browse/CALCITE-3461?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TisNotT updated CALCITE-3461: - Summary: SqlToRelConverter substituteSubQuery problem (was: SqlToRelConverter substituteSubQuery