[jira] [Commented] (CALCITE-4724) ClickHouseSqlDialect `supportsAliasedValues` should return false.

[ https://issues.apache.org/jira/browse/CALCITE-4724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397858#comment-17397858 ] Julian Hyde commented on CALCITE-4724: -- I was mistaken. {{testValues}} and {{testV

[jira] [Comment Edited] (CALCITE-4724) ClickHouseSqlDialect `supportsAliasedValues` should return false.

[ https://issues.apache.org/jira/browse/CALCITE-4724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397858#comment-17397858 ] Julian Hyde edited comment on CALCITE-4724 at 8/12/21, 6:45 AM: -

[jira] [Updated] (CALCITE-4721) SqlSelect's setOperand method cannot set `hints`, failed with AssertionError

[ https://issues.apache.org/jira/browse/CALCITE-4721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4721: - Labels: pull-request-available (was: pull-requests-available) > SqlSelect's setOperand method

[jira] [Updated] (CALCITE-4724) ClickHouseSqlDialect `supportsAliasedValues` should return false.

[ https://issues.apache.org/jira/browse/CALCITE-4724?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4724: - Labels: pull-request-available (was: pull-request-available pull-requests-available) > ClickH

[jira] [Commented] (CALCITE-4568) Tempura: extending Calcite into an incremental query optimizer

[ https://issues.apache.org/jira/browse/CALCITE-4568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397799#comment-17397799 ] Botong Huang commented on CALCITE-4568: --- Sounds good and please take your time. O

[jira] [Comment Edited] (CALCITE-4725) Between clause operands checker should check all combinations of the three operands

[ https://issues.apache.org/jira/browse/CALCITE-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397791#comment-17397791 ] duan xiong edited comment on CALCITE-4725 at 8/12/21, 3:35 AM: --

[jira] [Commented] (CALCITE-4725) Between clause operands checker should check all combinations of the three operands

[ https://issues.apache.org/jira/browse/CALCITE-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397791#comment-17397791 ] duan xiong commented on CALCITE-4725: - [~paul8263] I have test some case in PG. for

[jira] [Commented] (CALCITE-4725) Between clause operands checker should check all combinations of the three operands

[ https://issues.apache.org/jira/browse/CALCITE-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397770#comment-17397770 ] Yao Zhang commented on CALCITE-4725: Hi [~julianhyde], Sorry that I did not push t

[jira] [Comment Edited] (CALCITE-4725) Between clause operands checker should check all combinations of the three operands

[ https://issues.apache.org/jira/browse/CALCITE-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397769#comment-17397769 ] Yao Zhang edited comment on CALCITE-4725 at 8/12/21, 2:59 AM: ---

[jira] [Commented] (CALCITE-4725) Between clause operands checker should check all combinations of the three operands

[ https://issues.apache.org/jira/browse/CALCITE-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397769#comment-17397769 ] Yao Zhang commented on CALCITE-4725: Hi [~nobigo], Thank you for your advice. But

[jira] [Comment Edited] (CALCITE-4727) Possible incorrect RpcMetadata JSON reference

[ https://issues.apache.org/jira/browse/CALCITE-4727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397741#comment-17397741 ] John Bodley edited comment on CALCITE-4727 at 8/12/21, 2:43 AM: -

[jira] [Commented] (CALCITE-4724) ClickHouseSqlDialect `supportsAliasedValues` should return false.

[ https://issues.apache.org/jira/browse/CALCITE-4724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397754#comment-17397754 ] Enze Liu commented on CALCITE-4724: --- Added ClickHouse testcases in `testValues()` and

[jira] [Commented] (CALCITE-4727) Possible incorrect RpcMetadata JSON reference

[ https://issues.apache.org/jira/browse/CALCITE-4727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397741#comment-17397741 ] John Bodley commented on CALCITE-4727: -- [~elserj] sorry I can't provide an encapsu

[jira] [Commented] (CALCITE-4568) Tempura: extending Calcite into an incremental query optimizer

[ https://issues.apache.org/jira/browse/CALCITE-4568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397736#comment-17397736 ] Julian Hyde commented on CALCITE-4568: -- [~botong], Thank you for rebasing. I know

[jira] [Commented] (CALCITE-4724) ClickHouseSqlDialect `supportsAliasedValues` should return false.

[ https://issues.apache.org/jira/browse/CALCITE-4724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397734#comment-17397734 ] Julian Hyde commented on CALCITE-4724: -- Thanks. In CALCITE-3191 (which is very sim

[jira] [Commented] (CALCITE-4724) ClickHouseSqlDialect `supportsAliasedValues` should return false.

[ https://issues.apache.org/jira/browse/CALCITE-4724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397728#comment-17397728 ] Enze Liu commented on CALCITE-4724: --- Pull request updated with test case.    > Clic

[jira] [Updated] (CALCITE-4724) ClickHouseSqlDialect `supportsAliasedValues` should return false.

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

[jira] [Commented] (CALCITE-4727) Possible incorrect RpcMetadata JSON reference

[ https://issues.apache.org/jira/browse/CALCITE-4727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397723#comment-17397723 ] Josh Elser commented on CALCITE-4727: - {quote}That said [~elserj] per your comment

[jira] [Commented] (CALCITE-4724) ClickHouseSqlDialect `supportsAliasedValues` should return false.

[ https://issues.apache.org/jira/browse/CALCITE-4724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397711#comment-17397711 ] Julian Hyde commented on CALCITE-4724: -- I'd welcome the pull request. It should in

[jira] [Commented] (CALCITE-4725) Between clause operands checker should check all combinations of the three operands

[ https://issues.apache.org/jira/browse/CALCITE-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397709#comment-17397709 ] Julian Hyde commented on CALCITE-4725: -- I see the pull request doesn't have any te

[jira] [Commented] (CALCITE-4726) Add support for filters in AggregateExpandWithinDistinctRule

[ https://issues.apache.org/jira/browse/CALCITE-4726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397698#comment-17397698 ] Julian Hyde commented on CALCITE-4726: -- On reflection, I think that adding {{SqlAg

[jira] [Commented] (CALCITE-4726) Add support for filters in AggregateExpandWithinDistinctRule

[ https://issues.apache.org/jira/browse/CALCITE-4726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397693#comment-17397693 ] Julian Hyde commented on CALCITE-4726: -- Review comments: * I got a couple of chec

[jira] [Comment Edited] (CALCITE-4727) Possible incorrect RpcMetadata JSON reference

[ https://issues.apache.org/jira/browse/CALCITE-4727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397651#comment-17397651 ] John Bodley edited comment on CALCITE-4727 at 8/11/21, 10:37 PM:

[jira] [Comment Edited] (CALCITE-4727) Possible incorrect RpcMetadata JSON reference

[ https://issues.apache.org/jira/browse/CALCITE-4727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397651#comment-17397651 ] John Bodley edited comment on CALCITE-4727 at 8/11/21, 10:36 PM:

[jira] [Comment Edited] (CALCITE-4727) Possible incorrect RpcMetadata JSON reference

[ https://issues.apache.org/jira/browse/CALCITE-4727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397651#comment-17397651 ] John Bodley edited comment on CALCITE-4727 at 8/11/21, 10:36 PM:

[jira] [Comment Edited] (CALCITE-4727) Possible incorrect RpcMetadata JSON reference

[ https://issues.apache.org/jira/browse/CALCITE-4727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397651#comment-17397651 ] John Bodley edited comment on CALCITE-4727 at 8/11/21, 10:35 PM:

[jira] [Commented] (CALCITE-4724) ClickHouseSqlDialect `supportsAliasedValues` should return false.

[ https://issues.apache.org/jira/browse/CALCITE-4724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397669#comment-17397669 ] Enze Liu commented on CALCITE-4724: --- [~zabetak]  [https://clickhouse.tech/docs/en/sq

[jira] [Comment Edited] (CALCITE-4727) Possible incorrect RpcMetadata JSON reference

[ https://issues.apache.org/jira/browse/CALCITE-4727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397651#comment-17397651 ] John Bodley edited comment on CALCITE-4727 at 8/11/21, 9:42 PM: -

[jira] [Updated] (CALCITE-4727) Possible incorrect RpcMetadata JSON reference

[ https://issues.apache.org/jira/browse/CALCITE-4727?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Bodley updated CALCITE-4727: - Attachment: (was: Screen Shot 2021-08-11 at 2.37.38 PM.png) > Possible incorrect RpcMetadat

[jira] [Commented] (CALCITE-4727) Possible incorrect RpcMetadata JSON reference

[ https://issues.apache.org/jira/browse/CALCITE-4727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397651#comment-17397651 ] John Bodley commented on CALCITE-4727: -- For context here's the error I get when tr

[jira] [Updated] (CALCITE-4727) Possible incorrect RpcMetadata JSON reference

[ https://issues.apache.org/jira/browse/CALCITE-4727?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Bodley updated CALCITE-4727: - Attachment: Screen Shot 2021-08-11 at 2.37.38 PM.png > Possible incorrect RpcMetadata JSON refe

[jira] [Comment Edited] (CALCITE-4727) Possible incorrect RpcMetadata JSON reference

[ https://issues.apache.org/jira/browse/CALCITE-4727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397644#comment-17397644 ] John Bodley edited comment on CALCITE-4727 at 8/11/21, 9:23 PM: -

[jira] [Comment Edited] (CALCITE-4727) Possible incorrect RpcMetadata JSON reference

[ https://issues.apache.org/jira/browse/CALCITE-4727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397644#comment-17397644 ] John Bodley edited comment on CALCITE-4727 at 8/11/21, 9:23 PM: -

[jira] [Comment Edited] (CALCITE-4727) Possible incorrect RpcMetadata JSON reference

[ https://issues.apache.org/jira/browse/CALCITE-4727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397644#comment-17397644 ] John Bodley edited comment on CALCITE-4727 at 8/11/21, 9:22 PM: -

[jira] [Commented] (CALCITE-4727) Possible incorrect RpcMetadata JSON reference

[ https://issues.apache.org/jira/browse/CALCITE-4727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397644#comment-17397644 ] John Bodley commented on CALCITE-4727: -- I was testing using {{avatica-1.17.0.jar}}

[jira] [Updated] (CALCITE-4727) Possible incorrect RpcMetadata JSON reference

[ https://issues.apache.org/jira/browse/CALCITE-4727?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Bodley updated CALCITE-4727: - Summary: Possible incorrect RpcMetadata JSON reference (was: Fix RpcMetadata JSON reference )

[jira] [Commented] (CALCITE-4727) Fix RpcMetadata JSON reference

[ https://issues.apache.org/jira/browse/CALCITE-4727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397600#comment-17397600 ] Josh Elser commented on CALCITE-4727: - {quote}the RpMetadata JSON reference is miss

[jira] [Commented] (CALCITE-4727) Fix RpcMetadata JSON reference

[ https://issues.apache.org/jira/browse/CALCITE-4727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397589#comment-17397589 ] Josh Elser commented on CALCITE-4727: - Thanks John! > Fix RpcMetadata JSON referen

[jira] [Updated] (CALCITE-4726) Add support for filters in AggregateExpandWithinDistinctRule

[ https://issues.apache.org/jira/browse/CALCITE-4726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4726: - Description: Currently, {{AggregateExpandWithinDistinctRule}} does not fire if any of the aggr

[jira] [Commented] (CALCITE-4727) Fix RpcMetadata JSON reference

[ https://issues.apache.org/jira/browse/CALCITE-4727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397566#comment-17397566 ] Julian Hyde commented on CALCITE-4727: -- Nit: Can you remove 'Fix' from the JIRA su

[jira] [Commented] (CALCITE-4367) Incorrect documentation for Avatica JSON request/response signatures

[ https://issues.apache.org/jira/browse/CALCITE-4367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397562#comment-17397562 ] John Bodley commented on CALCITE-4367: -- Per [~elserj]'s request created [CALCITE-

[jira] [Created] (CALCITE-4727) Fix RpcMetadata JSON reference

John Bodley created CALCITE-4727: Summary: Fix RpcMetadata JSON reference Key: CALCITE-4727 URL: https://issues.apache.org/jira/browse/CALCITE-4727 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-4726) Add support for filters in AggregateExpandWithinDistinctRule

Will Noble created CALCITE-4726: --- Summary: Add support for filters in AggregateExpandWithinDistinctRule Key: CALCITE-4726 URL: https://issues.apache.org/jira/browse/CALCITE-4726 Project: Calcite

[jira] [Commented] (CALCITE-4723) Check whether JDBC adapter generates "GROUP BY ()" against Oracle, DB2, MSSQL

[ https://issues.apache.org/jira/browse/CALCITE-4723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397508#comment-17397508 ] Julian Hyde commented on CALCITE-4723: -- That’s true, but what are the implications

[jira] [Commented] (CALCITE-4652) AggregateExpandDistinctAggregatesRule must cast top aggregates to original type

[ https://issues.apache.org/jira/browse/CALCITE-4652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397505#comment-17397505 ] Julian Hyde commented on CALCITE-4652: -- I don’t have time to commit this. Can anot

[jira] [Commented] (CALCITE-4367) Incorrect documentation for Avatica JSON request/response signatures

[ https://issues.apache.org/jira/browse/CALCITE-4367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397499#comment-17397499 ] Josh Elser commented on CALCITE-4367: - [~john.bod...@gmail.com] thanks for coming b

[jira] [Commented] (CALCITE-4367) Incorrect documentation for Avatica JSON request/response signatures

[ https://issues.apache.org/jira/browse/CALCITE-4367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397465#comment-17397465 ] John Bodley commented on CALCITE-4367: -- [~elserj] and [~francischuang] a follow up

[jira] [Commented] (CALCITE-4652) AggregateExpandDistinctAggregatesRule must cast top aggregates to original type

[ https://issues.apache.org/jira/browse/CALCITE-4652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397402#comment-17397402 ] Taras Ledkov commented on CALCITE-4652: --- [~julianhyde], thanks for comments. I fi

[jira] [Commented] (CALCITE-4723) Check whether JDBC adapter generates "GROUP BY ()" against Oracle, DB2, MSSQL

[ https://issues.apache.org/jira/browse/CALCITE-4723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397380#comment-17397380 ] duan xiong commented on CALCITE-4723: - MySQL doesn't support GROUP BY (). > Check

[jira] [Closed] (CALCITE-4695) The method of RelToSqlConverter.visit(Join e) throw NullPointerException

[ https://issues.apache.org/jira/browse/CALCITE-4695?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong closed CALCITE-4695. --- Resolution: Not A Bug > The method of RelToSqlConverter.visit(Join e) throw NullPointerException >

[jira] [Commented] (CALCITE-4695) The method of RelToSqlConverter.visit(Join e) throw NullPointerException

[ https://issues.apache.org/jira/browse/CALCITE-4695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397369#comment-17397369 ] duan xiong commented on CALCITE-4695: - Search calcite in Slack and the result inclu

[jira] [Assigned] (CALCITE-4723) Check whether JDBC adapter generates "GROUP BY ()" against Oracle, DB2, MSSQL

[ https://issues.apache.org/jira/browse/CALCITE-4723?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong reassigned CALCITE-4723: --- Assignee: duan xiong > Check whether JDBC adapter generates "GROUP BY ()" against Oracle,

[jira] [Commented] (CALCITE-4725) Between clause operands checker should check all combinations of the three operands

[ https://issues.apache.org/jira/browse/CALCITE-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397282#comment-17397282 ] duan xiong commented on CALCITE-4725: - [~paul8263] Hi. This is indeed an issue. and

[jira] [Assigned] (CALCITE-4702) Error when executing query with GROUP BY constant via JDBC adapter

[ https://issues.apache.org/jira/browse/CALCITE-4702?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis reassigned CALCITE-4702: Assignee: Soumyakanti Das (was: Stamatis Zampetakis) > Error when execu

[jira] [Commented] (CALCITE-4724) ClickHouseSqlDialect `supportsAliasedValues` should return false.

[ https://issues.apache.org/jira/browse/CALCITE-4724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397217#comment-17397217 ] Stamatis Zampetakis commented on CALCITE-4724: -- [~Enze] Is there some link

[jira] [Updated] (CALCITE-4725) Between clause operands checker should check all combinations of the three operands

[ https://issues.apache.org/jira/browse/CALCITE-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-4725: Labels: pull-request-available (was: ) > Between clause operands checker should check al

[jira] [Commented] (CALCITE-4725) Between clause operands checker should check all combinations of the three operands

[ https://issues.apache.org/jira/browse/CALCITE-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397108#comment-17397108 ] Yao Zhang commented on CALCITE-4725: Could any one assign this issue to me? > Betw

[jira] [Created] (CALCITE-4725) Between clause operands checker should check all combinations of the three operands

Yao Zhang created CALCITE-4725: -- Summary: Between clause operands checker should check all combinations of the three operands Key: CALCITE-4725 URL: https://issues.apache.org/jira/browse/CALCITE-4725 Pro