[jira] [Commented] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in Babel parser

[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726477#comment-17726477 ] Sumeet commented on CALCITE-5688: - Apologies for the late response, I was out sick and

[jira] [Commented] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in Babel parser

[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726476#comment-17726476 ] Sumeet commented on CALCITE-5688: - > Besides the core parser, do you know the server pa

[jira] [Commented] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in Babel parser

[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726475#comment-17726475 ] Sumeet commented on CALCITE-5688: - Thanks [~jiajunbernoulli] for the feedback, I can im

[jira] [Commented] (CALCITE-5425) Should not pushdown filter through aggregate with an empty groupset

[ https://issues.apache.org/jira/browse/CALCITE-5425?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726465#comment-17726465 ] Julian Hyde commented on CALCITE-5425: -- I see. Yes, I agree that you need a way to

[jira] [Commented] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726464#comment-17726464 ] Julian Hyde commented on CALCITE-5722: -- Cancel that. I see that the javadoc for [c

[jira] [Commented] (CALCITE-5425) Should not pushdown filter through aggregate with an empty groupset

[ https://issues.apache.org/jira/browse/CALCITE-5425?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726447#comment-17726447 ] Dan Zou commented on CALCITE-5425: -- [~julianhyde] Maybe I didn't express myself clearl

[jira] [Closed] (CALCITE-5716) Two level nested correlated subquery translates to incorrect ON condition

[ https://issues.apache.org/jira/browse/CALCITE-5716?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Wright closed CALCITE-5716. Resolution: Duplicate This issue is fixed by CALCITE-5683. I've tested that fix on my use-case an

[jira] [Commented] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726401#comment-17726401 ] Julian Hyde commented on CALCITE-5722: -- In the case of {{BigDecimal}} -- which see

[jira] [Commented] (CALCITE-5724) Generated SQL uses literal values in ORDER BY clauses

[ https://issues.apache.org/jira/browse/CALCITE-5724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726389#comment-17726389 ] Julian Hyde commented on CALCITE-5724: -- Or, rather than applying the planner rule,

[jira] [Commented] (CALCITE-5724) Generated SQL uses literal values in ORDER BY clauses

[ https://issues.apache.org/jira/browse/CALCITE-5724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726388#comment-17726388 ] Julian Hyde commented on CALCITE-5724: -- There's a planner rule to remove constant

[jira] [Commented] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726387#comment-17726387 ] Julian Hyde commented on CALCITE-5722: -- Would it be simpler to assert that if two

[jira] [Commented] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726356#comment-17726356 ] Ian Bertolacci commented on CALCITE-5722: - It also has the effect that {{`not (

[jira] [Assigned] (CALCITE-5724) Generated SQL uses literal values in ORDER BY clauses

[ https://issues.apache.org/jira/browse/CALCITE-5724?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Joey Moore reassigned CALCITE-5724: --- Assignee: Joey Moore > Generated SQL uses literal values in ORDER BY clauses > ---

[jira] [Created] (CALCITE-5724) Generated SQL uses literal values in ORDER BY clauses

Joey Moore created CALCITE-5724: --- Summary: Generated SQL uses literal values in ORDER BY clauses Key: CALCITE-5724 URL: https://issues.apache.org/jira/browse/CALCITE-5724 Project: Calcite Issue

[jira] [Comment Edited] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726339#comment-17726339 ] Ian Bertolacci edited comment on CALCITE-5722 at 5/25/23 6:21 PM: ---

[jira] [Comment Edited] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726339#comment-17726339 ] Ian Bertolacci edited comment on CALCITE-5722 at 5/25/23 6:20 PM: ---

[jira] [Commented] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726342#comment-17726342 ] Ian Bertolacci commented on CALCITE-5722: - I mention this because the RexProgra

[jira] [Commented] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726339#comment-17726339 ] Ian Bertolacci commented on CALCITE-5722: - I've also noticed that this affects

[jira] [Commented] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726315#comment-17726315 ] Ian Bertolacci commented on CALCITE-5722: - [~libenchao] Thanks! [~julianhyde]

[jira] [Commented] (CALCITE-5425) Should not pushdown filter through aggregate with an empty groupset

[ https://issues.apache.org/jira/browse/CALCITE-5425?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726309#comment-17726309 ] Julian Hyde commented on CALCITE-5425: -- Recently I have been trying not to put sig

[jira] [Commented] (CALCITE-4334) LITERAL_AGG, an aggregate function that returns a constant value

[ https://issues.apache.org/jira/browse/CALCITE-4334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726294#comment-17726294 ] Julian Hyde commented on CALCITE-4334: -- {{rexList}} seems like an abstraction that

[jira] [Updated] (CALCITE-4334) LITERAL_AGG, an aggregate function that returns a constant value

[ https://issues.apache.org/jira/browse/CALCITE-4334?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-4334: Labels: pull-request-available (was: ) > LITERAL_AGG, an aggregate function that returns

[jira] [Commented] (CALCITE-4334) LITERAL_AGG, an aggregate function that returns a constant value

[ https://issues.apache.org/jira/browse/CALCITE-4334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726266#comment-17726266 ] Ruben Q L commented on CALCITE-4334: I agree with [~libenchao]  on the benefits of

[jira] [Assigned] (CALCITE-5723) Oracle dialect generates SQL that cannot be recognized by lower version Oracle Server(<12) when unparsing OffsetFetch

[ https://issues.apache.org/jira/browse/CALCITE-5723?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ZheHu reassigned CALCITE-5723: -- Assignee: ZheHu > Oracle dialect generates SQL that cannot be recognized by lower version > Oracle

[jira] [Updated] (CALCITE-5723) Oracle dialect generates SQL that cannot be recognized by lower version Oracle Server(<12) when unparsing OffsetFetch

[ https://issues.apache.org/jira/browse/CALCITE-5723?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ZheHu updated CALCITE-5723: --- Summary: Oracle dialect generates SQL that cannot be recognized by lower version Oracle Server(<12) when un

[jira] [Created] (CALCITE-5723) Oracle dialect generates SQL that cannot be recoginized by lower version Oracle Server(<12) when unparsing OffsetFetch

ZheHu created CALCITE-5723: -- Summary: Oracle dialect generates SQL that cannot be recoginized by lower version Oracle Server(<12) when unparsing OffsetFetch Key: CALCITE-5723 URL: https://issues.apache.org/jira/browse/CA

[jira] [Assigned] (CALCITE-5721) Capture build scans on ge.apache.org to benefit from deep build insights

[ https://issues.apache.org/jira/browse/CALCITE-5721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis reassigned CALCITE-5721: Assignee: Clay Johnson > Capture build scans on ge.apache.org to benefit