[jira] [Assigned] (CALCITE-4742) AssertionError in SubQueryRemoveRule.rewriteSome while rewriting ANY subquery

2021-08-17 Thread duan xiong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong reassigned CALCITE-4742: --- Assignee: duan xiong > AssertionError in SubQueryRemoveRule.rewriteSome while rewriting AN

[jira] [Commented] (CALCITE-4542) Suboptimal plan is chosen when TopDownRuleDriver is enabled

2021-08-17 Thread Roman Kondakov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4542?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17400776#comment-17400776 ] Roman Kondakov commented on CALCITE-4542: - [~korlov] I agree that it is strange

[jira] [Comment Edited] (CALCITE-4743) Convert rel to sql fail, when meeting aggregate of no-group and no-aggcall.

2021-08-17 Thread Xurenhe (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17400772#comment-17400772 ] Xurenhe edited comment on CALCITE-4743 at 8/18/21, 4:31 AM:

[jira] [Commented] (CALCITE-4743) Convert rel to sql fail, when meeting aggregate of no-group and no-aggcall.

2021-08-17 Thread Xurenhe (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17400772#comment-17400772 ] Xurenhe commented on CALCITE-4743: -- [~julianhyde] Thanks for your reply. Please let me

[jira] [Commented] (CALCITE-4740) JDBC adapter generates incorrect HAVING clause in BigQuery dialect

2021-08-17 Thread yanjing.wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17400748#comment-17400748 ] yanjing.wang commented on CALCITE-4740: --- Thanks [~julianhyde], I added the dialec

[jira] [Commented] (CALCITE-4486) UNIQUE predicate

2021-08-17 Thread duan xiong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4486?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17400705#comment-17400705 ] duan xiong commented on CALCITE-4486: - The PR has been submitted, Please review: [C

[jira] [Commented] (CALCITE-4745) RelDataTypeSystemImpl.deriveAvgAggType typing error

2021-08-17 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17400654#comment-17400654 ] Julian Hyde commented on CALCITE-4745: -- This is intended behavior. If you don’t li

[jira] [Updated] (CALCITE-4745) RelDataTypeSystemImpl.deriveAvgAggType typing error

2021-08-17 Thread keaton drebes (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4745?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] keaton drebes updated CALCITE-4745: --- Description: Currently, RelDataTypeSystemImpl.deriveAvgAggType returns the type of the inpu

[jira] [Updated] (CALCITE-4745) RelDataTypeSystemImpl.deriveAvgAggType typing error

2021-08-17 Thread keaton drebes (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4745?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] keaton drebes updated CALCITE-4745: --- Description: Currently, RelDataTypeSystemImpl.deriveAvgAggType returns the type of the inpu

[jira] [Updated] (CALCITE-4745) RelDataTypeSystemImpl.deriveAvgAggType typing error

2021-08-17 Thread keaton drebes (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4745?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] keaton drebes updated CALCITE-4745: --- Priority: Minor (was: Trivial) > RelDataTypeSystemImpl.deriveAvgAggType typing error > ---

[jira] [Updated] (CALCITE-4745) RelDataTypeSystemImpl.deriveAvgAggType typing error

2021-08-17 Thread keaton drebes (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4745?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] keaton drebes updated CALCITE-4745: --- Description: Currently, RelDataTypeSystemImpl.deriveAvgAggType returns the type of the inpu

[jira] [Updated] (CALCITE-4745) RelDataTypeSystemImpl.deriveAvgAggType typing error

2021-08-17 Thread keaton drebes (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4745?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] keaton drebes updated CALCITE-4745: --- Description: Currently, RelDataTypeSystemImpl.deriveAvgAggType returns the type of the inpu

[jira] [Created] (CALCITE-4745) RelDataTypeSystemImpl.deriveAvgAggType typing error

2021-08-17 Thread keaton drebes (Jira)
keaton drebes created CALCITE-4745: -- Summary: RelDataTypeSystemImpl.deriveAvgAggType typing error Key: CALCITE-4745 URL: https://issues.apache.org/jira/browse/CALCITE-4745 Project: Calcite I

[jira] [Comment Edited] (CALCITE-4744) Add config for StandardConvertlet table to change if windowed aggregation functions are decomposed

2021-08-17 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4744?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17400488#comment-17400488 ] Julian Hyde edited comment on CALCITE-4744 at 8/17/21, 4:57 PM: -

[jira] [Commented] (CALCITE-4744) Add config for StandardConvertlet table to change if windowed aggregation functions are decomposed

2021-08-17 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4744?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17400488#comment-17400488 ] Julian Hyde commented on CALCITE-4744: -- Revise this one. This the same "problem".

[jira] [Commented] (CALCITE-4740) JDBC adapter generates incorrect HAVING clause in BigQuery dialect

2021-08-17 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17400483#comment-17400483 ] Julian Hyde commented on CALCITE-4740: -- Or, when generating a HAVING clause, in a

[jira] [Commented] (CALCITE-4740) JDBC adapter generates incorrect HAVING clause in BigQuery dialect

2021-08-17 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17400480#comment-17400480 ] Julian Hyde commented on CALCITE-4740: -- It seems to be overkill (and error prone)

[jira] [Commented] (CALCITE-4744) Add config for StandardConvertlet table to change if windowed aggregation functions are decomposed

2021-08-17 Thread keaton drebes (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4744?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17400479#comment-17400479 ] keaton drebes commented on CALCITE-4744: Fixed the title, sorry. That approach

[jira] [Updated] (CALCITE-4744) Add config for StandardConvertlet table to change if windowed aggregation functions are decomposed

2021-08-17 Thread keaton drebes (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] keaton drebes updated CALCITE-4744: --- Summary: Add config for StandardConvertlet table to change if windowed aggregation function

[jira] [Updated] (CALCITE-4744) Add config for StandardConvertlet table to change decomposing aggregation functions

2021-08-17 Thread keaton drebes (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] keaton drebes updated CALCITE-4744: --- Summary: Add config for StandardConvertlet table to change decomposing aggregation function

[jira] [Updated] (CALCITE-4744) Add config for

2021-08-17 Thread keaton drebes (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] keaton drebes updated CALCITE-4744: --- Summary: Add config for (was: Add ) > Add config for > --- > >

[jira] [Commented] (CALCITE-4744) Add

2021-08-17 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4744?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17400472#comment-17400472 ] Julian Hyde commented on CALCITE-4744: -- Can you fix the Jira subject? Not your fa

[jira] [Updated] (CALCITE-4744) Add

2021-08-17 Thread keaton drebes (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] keaton drebes updated CALCITE-4744: --- Description: I have a project that is working with windowed functions and we want to avoid

[jira] [Updated] (CALCITE-4744) Add

2021-08-17 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-4744: Labels: pull-request-available (was: ) > Add > > > Key: CALCITE-47

[jira] [Created] (CALCITE-4744) Add

2021-08-17 Thread keaton drebes (Jira)
keaton drebes created CALCITE-4744: -- Summary: Add Key: CALCITE-4744 URL: https://issues.apache.org/jira/browse/CALCITE-4744 Project: Calcite Issue Type: New Feature Components: co

[jira] [Commented] (CALCITE-4743) Convert rel to sql fail, when meeting aggregate of no-group and no-aggcall.

2021-08-17 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17400399#comment-17400399 ] Julian Hyde commented on CALCITE-4743: -- No.  Please ask on the dev list for a revi

[jira] [Commented] (CALCITE-4740) JDBC adapter generates incorrect HAVING clause in BigQuery dialect

2021-08-17 Thread yanjing.wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17400383#comment-17400383 ] yanjing.wang commented on CALCITE-4740: --- Yes, I submit a [pr-2494|https://github.

[jira] [Commented] (CALCITE-4743) Convert rel to sql fail, when meeting aggregate of no-group and no-aggcall.

2021-08-17 Thread Xurenhe (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17400371#comment-17400371 ] Xurenhe commented on CALCITE-4743: -- Hi [~julianhyde] Could you review this issue. Than

[jira] [Updated] (CALCITE-4739) json_object pushdown JDBC Postgresql

2021-08-17 Thread Martin Jonsson (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4739?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Martin Jonsson updated CALCITE-4739: Description: I'm going through the JSON functions with JDBC Postgresql. Most functions wo

[jira] [Created] (CALCITE-4743) Convert rel to sql fail, when meeting aggregate of no-group and no-aggcall.

2021-08-17 Thread Xurenhe (Jira)
Xurenhe created CALCITE-4743: Summary: Convert rel to sql fail, when meeting aggregate of no-group and no-aggcall. Key: CALCITE-4743 URL: https://issues.apache.org/jira/browse/CALCITE-4743 Project: Calcit

[jira] [Updated] (CALCITE-4741) AbstractRelNode#getId can overflow into a negative value causing CompileException in certain Enumerable implement methods

2021-08-17 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-4741: Labels: pull-request-available (was: ) > AbstractRelNode#getId can overflow into a negat

[jira] [Assigned] (CALCITE-4741) AbstractRelNode#getId can overflow into a negative value causing CompileException in certain Enumerable implement methods

2021-08-17 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-4741: -- Assignee: Ruben Q L > AbstractRelNode#getId can overflow into a negative value causing > Co

[jira] [Commented] (CALCITE-4729) Column in CTE should be ambiguous

2021-08-17 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17400351#comment-17400351 ] Julian Hyde commented on CALCITE-4729: -- It looks like a bug to me. Not all systems

[jira] [Commented] (CALCITE-4740) JDBC adapter generates incorrect HAVING clause in BigQuery dialect

2021-08-17 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17400350#comment-17400350 ] Julian Hyde commented on CALCITE-4740: -- [~yanjing.wang], Would you like to submit

[jira] [Updated] (CALCITE-4742) AssertionError in SubQueryRemoveRule.rewriteSome while rewriting ANY subquery

2021-08-17 Thread Ivan Daschinsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ivan Daschinsky updated CALCITE-4742: - Description: When executing {code} select * from "scott".emp where empno <> any (select

[jira] [Updated] (CALCITE-4742) AssertionError in SubQueryRemoveRule.rewriteSome while rewriting ANY subquery

2021-08-17 Thread Ivan Daschinsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ivan Daschinsky updated CALCITE-4742: - Description: When executing {code} select * from "scott".emp where empno <> any (select

[jira] [Updated] (CALCITE-4742) AssertionError in SubQueryRemoveRule.rewriteSome while rewriting ANY subquery

2021-08-17 Thread Ivan Daschinsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ivan Daschinsky updated CALCITE-4742: - Description: When executing {code} select * from "scott".emp where empno <> any (select

[jira] [Updated] (CALCITE-4742) AssertionError in SubQueryRemoveRule.rewriteSome while rewriting ANY subquery

2021-08-17 Thread Ivan Daschinsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ivan Daschinsky updated CALCITE-4742: - Description: When executing {code} select * from "scott".emp where empno <> any (select

[jira] [Updated] (CALCITE-4742) AssertionError in SubQueryRemoveRule.rewriteSome while rewriting ANY subquery

2021-08-17 Thread Ivan Daschinsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ivan Daschinsky updated CALCITE-4742: - Description: When executing {code} select * from "scott".emp where empno <> any (select

[jira] [Created] (CALCITE-4742) AssertionError in SubQueryRemoveRule.rewriteSome while rewriting ANY subquery

2021-08-17 Thread Ivan Daschinsky (Jira)
Ivan Daschinsky created CALCITE-4742: Summary: AssertionError in SubQueryRemoveRule.rewriteSome while rewriting ANY subquery Key: CALCITE-4742 URL: https://issues.apache.org/jira/browse/CALCITE-4742

[jira] [Commented] (CALCITE-4740) JDBC adapter generates incorrect HAVING clause in BigQuery dialect

2021-08-17 Thread yanjing.wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17400335#comment-17400335 ] yanjing.wang commented on CALCITE-4740: --- Thanks [~julianhyde], I think the proble

[jira] [Commented] (CALCITE-4729) Column in CTE should be ambiguous

2021-08-17 Thread duan xiong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17400323#comment-17400323 ] duan xiong commented on CALCITE-4729: - [~julianhyde]  Hi. When I try to resolve thi

[jira] [Updated] (CALCITE-4741) AbstractRelNode#getId can overflow into a negative value causing CompileException in certain Enumerable implement methods

2021-08-17 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4741: --- Description: {{AbstractRelNode#getId}} can overflow into a negative value. This id is used by the

[jira] [Updated] (CALCITE-4741) AbstractRelNode#getId can overflow into a negative value causing CompileException in certain Enumerable implement methods

2021-08-17 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4741: --- Description: {{AbstractRelNode#getId}} can overflow into a negative value. This id is used by cert

[jira] [Created] (CALCITE-4741) AbstractRelNode#getId can overflow into a negative value causing CompileException in certain Enumerable implement methods

2021-08-17 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-4741: -- Summary: AbstractRelNode#getId can overflow into a negative value causing CompileException in certain Enumerable implement methods Key: CALCITE-4741 URL: https://issues.apache.org/jir

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

2021-08-17 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17400240#comment-17400240 ] Julian Hyde edited comment on CALCITE-4726 at 8/17/21, 8:24 AM: -

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

2021-08-17 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17400240#comment-17400240 ] Julian Hyde commented on CALCITE-4726: -- {quote}The unique semantics of {{COUNT(*)}

[jira] [Updated] (CALCITE-4740) JDBC adapter generates incorrect HAVING clause in BigQuery dialect

2021-08-17 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4740?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4740: - Summary: JDBC adapter generates incorrect HAVING clause in BigQuery dialect (was: Converting r

[jira] [Commented] (CALCITE-4740) Converting rel to sql with big query dialect results incorrect having clause

2021-08-17 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17400224#comment-17400224 ] Julian Hyde commented on CALCITE-4740: -- Note that CALCITE-3936 was in a similar ar

[jira] [Created] (CALCITE-4740) Converting rel to sql with big query dialect results incorrect having clause

2021-08-17 Thread yanjing.wang (Jira)
yanjing.wang created CALCITE-4740: - Summary: Converting rel to sql with big query dialect results incorrect having clause Key: CALCITE-4740 URL: https://issues.apache.org/jira/browse/CALCITE-4740 Proj