[jira] [Updated] (CALCITE-3474) SqlSimpleParser toke.s equals NullPointerException

[ https://issues.apache.org/jira/browse/CALCITE-3474?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-3474: - Fix Version/s: (was: next) 1.22.0 > SqlSimpleParser toke

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

[ https://issues.apache.org/jira/browse/CALCITE-3467?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16967266#comment-16967266 ] Wang Yanlin commented on CALCITE-3467: -- oh, I see. > Fix PartialMapping mistake >

[jira] [Commented] (CALCITE-3433) EQUALS operator between date/timestamp types returns false if the type is nullable

[ https://issues.apache.org/jira/browse/CALCITE-3433?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16967263#comment-16967263 ] Feng Zhu commented on CALCITE-3433: --- Hi [~julianhyde], I'm sorry I can't figure out s

[jira] [Comment Edited] (CALCITE-3470) a RelOptRule-based text DSL

[ https://issues.apache.org/jira/browse/CALCITE-3470?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16967260#comment-16967260 ] jamie12221 edited comment on CALCITE-3470 at 11/5/19 6:07 AM: ---

[jira] [Commented] (CALCITE-3470) a RelOptRule-based text DSL

[ https://issues.apache.org/jira/browse/CALCITE-3470?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16967260#comment-16967260 ] jamie12221 commented on CALCITE-3470: - Thank you for your patience. I'm actually w

[jira] [Commented] (CALCITE-3438) Validator should disallow use of the GROUPING function inside a FILTER clause

[ https://issues.apache.org/jira/browse/CALCITE-3438?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16967257#comment-16967257 ] Danny Chen commented on CALCITE-3438: - Reviewing now ~ > Validator should disallow

[jira] [Commented] (CALCITE-3459) AssertionError for using Timestamp/Time/Date in user defined table function

[ https://issues.apache.org/jira/browse/CALCITE-3459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16967252#comment-16967252 ] Wang Yanlin commented on CALCITE-3459: -- I update the PR, set time zone to UTC befo

[jira] [Commented] (CALCITE-3459) AssertionError for using Timestamp/Time/Date in user defined table function

[ https://issues.apache.org/jira/browse/CALCITE-3459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16967241#comment-16967241 ] Wang Yanlin commented on CALCITE-3459: -- how about set default time zone to UTC bef

[jira] [Resolved] (CALCITE-3458) Remove desc in AbstractRelNode

[ https://issues.apache.org/jira/browse/CALCITE-3458?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3458. Fix Version/s: 1.22.0 Resolution: Fixed Fixed in https://github.com/apache/calcit

[jira] [Commented] (CALCITE-3469) Typo in SubstitutionVisitor#rowTypesAreEquivalent

[ https://issues.apache.org/jira/browse/CALCITE-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16967219#comment-16967219 ] daimin commented on CALCITE-3469: - [~zabetak] [~julianhyde] Thanks a lot, I will pay mo

[jira] [Resolved] (CALCITE-3400) Implement left/right/semi/anti/full join in Interpreter

[ https://issues.apache.org/jira/browse/CALCITE-3400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3400. Fix Version/s: 1.22.0 Resolution: Fixed Fixed in https://github.com/apache/calcit

[jira] [Commented] (CALCITE-3473) Getting unique result for table scan should contain key column(s)

[ https://issues.apache.org/jira/browse/CALCITE-3473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16967190#comment-16967190 ] Wang Yanlin commented on CALCITE-3473: -- # Yes, using powerSet will have performanc

[jira] [Commented] (CALCITE-3471) Only return 10 records use jdbc:calcite method

[ https://issues.apache.org/jira/browse/CALCITE-3471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16967176#comment-16967176 ] Andrei Sereda commented on CALCITE-3471: You shouldn't have this limit on mysql

[jira] [Commented] (CALCITE-3471) Only return 10 records use jdbc:calcite method

[ https://issues.apache.org/jira/browse/CALCITE-3471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16967160#comment-16967160 ] james601232 commented on CALCITE-3471: -- Dear [~sereda]  why mysql datasource also

[jira] [Resolved] (CALCITE-3475) BigQuery SQL dialect unparseCall override broken for UNION ALL

[ https://issues.apache.org/jira/browse/CALCITE-3475?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-3475. -- Resolution: Fixed Fixed in [b2daea58|https://github.com/apache/calcite/commit/b2daea58fd3ca8

[jira] [Commented] (CALCITE-3475) BigQuery SQL dialect unparseCall override broken for UNION ALL

[ https://issues.apache.org/jira/browse/CALCITE-3475?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16967094#comment-16967094 ] Steven Talbot commented on CALCITE-3475: Linked a proposed fix in [https://gith

[jira] [Updated] (CALCITE-3475) BigQuery SQL dialect unparseCall override broken for UNION ALL

[ https://issues.apache.org/jira/browse/CALCITE-3475?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3475: - Fix Version/s: 1.22.0 > BigQuery SQL dialect unparseCall override broken for UNION ALL > --

[jira] [Commented] (CALCITE-3475) BigQuery SQL dialect unparseCall override broken for UNION ALL

[ https://issues.apache.org/jira/browse/CALCITE-3475?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16967068#comment-16967068 ] Julian Hyde commented on CALCITE-3475: -- Yes, blow up with an exception. People nev

[jira] [Assigned] (CALCITE-3475) BigQuery SQL dialect unparseCall override broken for UNION ALL

[ https://issues.apache.org/jira/browse/CALCITE-3475?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-3475: Assignee: Julian Hyde > BigQuery SQL dialect unparseCall override broken for UNION ALL >

[jira] [Commented] (CALCITE-3475) BigQuery SQL dialect unparseCall override broken for UNION ALL

[ https://issues.apache.org/jira/browse/CALCITE-3475?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16967041#comment-16967041 ] Rui Wang commented on CALCITE-3475: --- Should it blew up by printing a warning or throw

[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&focusedCommentId=16967022#comment-16967022 ] Julian Hyde commented on CALCITE-3463: -- Standard SQL allows parentheses around JOI

[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&focusedCommentId=16967016#comment-16967016 ] Julian Hyde commented on CALCITE-3466: -- I agree that this is a bug. Dropping the A

[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&focusedCommentId=16967010#comment-16967010 ] Julian Hyde commented on CALCITE-3468: -- The problem is that Calcite's type system

[jira] [Commented] (CALCITE-3458) Remove desc in AbstractRelNode

[ https://issues.apache.org/jira/browse/CALCITE-3458?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16967008#comment-16967008 ] Haisheng Yuan commented on CALCITE-3458: Thanks for pointing our, [~julianhyde]

[jira] [Comment Edited] (CALCITE-3458) Remove desc in AbstractRelNode

[ https://issues.apache.org/jira/browse/CALCITE-3458?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16967008#comment-16967008 ] Haisheng Yuan edited comment on CALCITE-3458 at 11/4/19 9:12 PM:

[jira] [Commented] (CALCITE-3433) EQUALS operator between date/timestamp types returns false if the type is nullable

[ https://issues.apache.org/jira/browse/CALCITE-3433?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16967000#comment-16967000 ] Julian Hyde commented on CALCITE-3433: -- This is an improvement but it doesn't seem

[jira] [Commented] (CALCITE-3459) AssertionError for using Timestamp/Time/Date in user defined table function

[ https://issues.apache.org/jira/browse/CALCITE-3459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16966993#comment-16966993 ] Julian Hyde commented on CALCITE-3459: -- Has someone thought about the timezone imp

[jira] [Resolved] (CALCITE-3471) Only return 10 records use jdbc:calcite method

[ https://issues.apache.org/jira/browse/CALCITE-3471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-3471. -- Fix Version/s: 1.18.0 Resolution: Duplicate > Only return 10 records use jdbc:calcite

[jira] [Commented] (CALCITE-3470) a RelOptRule-based text DSL

[ https://issues.apache.org/jira/browse/CALCITE-3470?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16966986#comment-16966986 ] Julian Hyde commented on CALCITE-3470: -- I guess this JIRA case is the plan that yo

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

[ https://issues.apache.org/jira/browse/CALCITE-3461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16966976#comment-16966976 ] Julian Hyde commented on CALCITE-3461: -- [~Sharpshow], FYI a PR with a 'close #nnn'

[jira] [Commented] (CALCITE-3458) Remove desc in AbstractRelNode

[ https://issues.apache.org/jira/browse/CALCITE-3458?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16966975#comment-16966975 ] Julian Hyde commented on CALCITE-3458: -- The line above, {{LOGGER.trace("Register {

[jira] [Commented] (CALCITE-3438) Validator should disallow use of the GROUPING function inside a FILTER clause

[ https://issues.apache.org/jira/browse/CALCITE-3438?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16966973#comment-16966973 ] Julian Hyde commented on CALCITE-3438: -- [~danny0405], It is a bug. The validator s

[jira] [Commented] (CALCITE-3469) Typo in SubstitutionVisitor#rowTypesAreEquivalent

[ https://issues.apache.org/jira/browse/CALCITE-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16966970#comment-16966970 ] Julian Hyde commented on CALCITE-3469: -- +1 This is a bug, not a typo. However the

[jira] [Resolved] (CALCITE-3472) SESSION_END returns same value as SESSION_START

[ https://issues.apache.org/jira/browse/CALCITE-3472?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-3472. -- Fix Version/s: 1.22.0 Resolution: Duplicate I agree; it is a duplicate. Closing. > SE

[jira] [Commented] (CALCITE-3475) BigQuery SQL dialect unparseCall override broken for UNION ALL

[ https://issues.apache.org/jira/browse/CALCITE-3475?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16966955#comment-16966955 ] Julian Hyde commented on CALCITE-3475: -- Yeah, that sure is passive-aggressive code

[jira] [Commented] (CALCITE-3472) SESSION_END returns same value as SESSION_START

[ https://issues.apache.org/jira/browse/CALCITE-3472?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16966865#comment-16966865 ] Andrew Pilloud commented on CALCITE-3472: - [~amaliujia] wrote a nice descriptio

[jira] [Created] (CALCITE-3475) BigQuery SQL dialect unparseCall override broken for UNION ALL

Steven Talbot created CALCITE-3475: -- Summary: BigQuery SQL dialect unparseCall override broken for UNION ALL Key: CALCITE-3475 URL: https://issues.apache.org/jira/browse/CALCITE-3475 Project: Calcite

[jira] [Commented] (CALCITE-3473) Getting unique result for table scan should contain key column(s)

[ https://issues.apache.org/jira/browse/CALCITE-3473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16966795#comment-16966795 ] Julian Hyde commented on CALCITE-3473: -- This fix has running time exponential in t

[jira] [Commented] (CALCITE-3471) Only return 10 records use jdbc:calcite method

[ https://issues.apache.org/jira/browse/CALCITE-3471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16966684#comment-16966684 ] Andrei Sereda commented on CALCITE-3471: Also see [CALCITE-2651] > Only return

[jira] [Comment Edited] (CALCITE-3471) Only return 10 records use jdbc:calcite method

[ https://issues.apache.org/jira/browse/CALCITE-3471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16966680#comment-16966680 ] Andrei Sereda edited comment on CALCITE-3471 at 11/4/19 2:03 PM:

[jira] [Updated] (CALCITE-3471) Only return 10 records use jdbc:calcite method

[ https://issues.apache.org/jira/browse/CALCITE-3471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Andrei Sereda updated CALCITE-3471: --- Component/s: (was: jdbc-adapter) elasticsearch-adapter > Only return 1

[jira] [Commented] (CALCITE-3471) Only return 10 records use jdbc:calcite method

[ https://issues.apache.org/jira/browse/CALCITE-3471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16966680#comment-16966680 ] Andrei Sereda commented on CALCITE-3471: Please use 1.20. {quote} size (Optio

[jira] [Updated] (CALCITE-3473) Getting unique result for table scan should contain key column(s)

[ https://issues.apache.org/jira/browse/CALCITE-3473?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3473: - Summary: Getting unique result for table scan should contain key column(s) (was: Result of get

[jira] [Updated] (CALCITE-3471) Only return 10 records use jdbc:calcite method

[ https://issues.apache.org/jira/browse/CALCITE-3471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] james601232 updated CALCITE-3471: - Affects Version/s: 1.17.0 > Only return 10 records use jdbc:calcite method > --

[jira] [Commented] (CALCITE-3471) Only return 10 records use jdbc:calcite method

[ https://issues.apache.org/jira/browse/CALCITE-3471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16966534#comment-16966534 ] james601232 commented on CALCITE-3471: -- can anyone reply me the problem? > Only r

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

[ https://issues.apache.org/jira/browse/CALCITE-3465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-3465: -- Description: Currently cassandra-adapter covers only part of the [data types

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

[ https://issues.apache.org/jira/browse/CALCITE-3465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-3465: -- Description: Currently cassandra-adapter covers only part of the [data types

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

[ https://issues.apache.org/jira/browse/CALCITE-3465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-3465: -- Description: Currently cassandra-adapter covers only part of the [data types

[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&focusedCommentId=16966508#comment-16966508 ] Vova Vysotskyi commented on CALCITE-3457: - [~danny0405], thanks for reviewing a

[jira] [Updated] (CALCITE-3474) SqlSimpleParser toke.s equals NullPointerException

[ https://issues.apache.org/jira/browse/CALCITE-3474?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3474: Labels: pull-request-available (was: ) > SqlSimpleParser toke.s equals NullPointerExcept

[jira] [Updated] (CALCITE-3474) SqlSimpleParser toke.s equals NullPointerException

[ https://issues.apache.org/jira/browse/CALCITE-3474?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] quxiucheng updated CALCITE-3474: Summary: SqlSimpleParser toke.s equals NullPointerException (was: SqlSimpleParser toke.s equals

[jira] [Updated] (CALCITE-3474) SqlSimpleParser toke.s equals NullPointerException'

[ https://issues.apache.org/jira/browse/CALCITE-3474?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] quxiucheng updated CALCITE-3474: Summary: SqlSimpleParser toke.s equals NullPointerException' (was: SqlSimpleParser simplifySql Q

[jira] [Updated] (CALCITE-3473) Result of getting unique result for table scan should contain key column(s)

[ https://issues.apache.org/jira/browse/CALCITE-3473?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3473: Labels: pull-request-available (was: ) > Result of getting unique result for table scan

[jira] [Created] (CALCITE-3474) SqlSimpleParser simplifySql Query token.s NullPointerException

quxiucheng created CALCITE-3474: --- Summary: SqlSimpleParser simplifySql Query token.s NullPointerException Key: CALCITE-3474 URL: https://issues.apache.org/jira/browse/CALCITE-3474 Project: Calcite

[jira] [Assigned] (CALCITE-3473) Result of getting unique result for table scan should contain key column(s)

[ https://issues.apache.org/jira/browse/CALCITE-3473?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin reassigned CALCITE-3473: Assignee: Wang Yanlin > Result of getting unique result for table scan should contain ke

[jira] [Updated] (CALCITE-3473) Result of getting unique result for table scan should contain key column(s)

[ https://issues.apache.org/jira/browse/CALCITE-3473?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3473: - Summary: Result of getting unique result for table scan should contain key column(s) (was: Uni

[jira] [Created] (CALCITE-3473) Unique keys of table scan should contain key column(s)

Wang Yanlin created CALCITE-3473: Summary: Unique keys of table scan should contain key column(s) Key: CALCITE-3473 URL: https://issues.apache.org/jira/browse/CALCITE-3473 Project: Calcite Is