[jira] [Comment Edited] (CALCITE-4242) Wrong plan for nested NOT EXISTS subqueries

2020-09-16 Thread Martin Raszyk (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17197422#comment-17197422 ] Martin Raszyk edited comment on CALCITE-4242 at 9/17/20, 6:45 AM: ---

[jira] [Commented] (CALCITE-4242) Wrong plan for nested NOT EXISTS subqueries

2020-09-16 Thread Martin Raszyk (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17197422#comment-17197422 ] Martin Raszyk commented on CALCITE-4242: I tried to use `LEFT SEMI JOIN` in Pos

[jira] [Commented] (CALCITE-4197) Provide utility to visualize RelNode plans

2020-09-16 Thread Liya Fan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17197365#comment-17197365 ] Liya Fan commented on CALCITE-4197: --- To make discussions clearer, I have opened anoth

[jira] [Created] (CALCITE-4260) Support plan explain with dot format

2020-09-16 Thread Liya Fan (Jira)
Liya Fan created CALCITE-4260: - Summary: Support plan explain with dot format Key: CALCITE-4260 URL: https://issues.apache.org/jira/browse/CALCITE-4260 Project: Calcite Issue Type: Task

[jira] [Comment Edited] (CALCITE-4197) Provide utility to visualize RelNode plans

2020-09-16 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17197336#comment-17197336 ] Chunwei Lei edited comment on CALCITE-4197 at 9/17/20, 3:06 AM: -

[jira] [Commented] (CALCITE-4197) Provide utility to visualize RelNode plans

2020-09-16 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17197336#comment-17197336 ] Chunwei Lei commented on CALCITE-4197: -- [~julianhyde], I did not notice that there

[jira] [Commented] (CALCITE-4197) Provide utility to visualize RelNode plans

2020-09-16 Thread Liya Fan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17197327#comment-17197327 ] Liya Fan commented on CALCITE-4197: --- [~julianhyde] Please don't worry. I will provide

[jira] [Updated] (CALCITE-4259) Support JDK 15

2020-09-16 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4259?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-4259: Labels: pull-request-available (was: ) > Support JDK 15 > -- > >

[jira] [Assigned] (CALCITE-4259) Support JDK 15

2020-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4259?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-4259: Assignee: Julian Hyde > Support JDK 15 > -- > > Key: CALCITE

[jira] [Commented] (CALCITE-4259) Support JDK 15

2020-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4259?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17197191#comment-17197191 ] Julian Hyde commented on CALCITE-4259: -- [~danny0405], I see you added tests in CAL

[jira] [Updated] (CALCITE-4259) Support JDK 15

2020-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4259?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4259: - Description: JDK 15 is now GA (released 2020/09/15). We should support it (and OpenJDK 15) as

[jira] [Updated] (CALCITE-4259) Support JDK 15

2020-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4259?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4259: - Description: JDK 15 is now GA (released 2020/09/15). We should support it (and OpenJDK 15) as

[jira] [Created] (CALCITE-4259) Support JDK 15

2020-09-16 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-4259: Summary: Support JDK 15 Key: CALCITE-4259 URL: https://issues.apache.org/jira/browse/CALCITE-4259 Project: Calcite Issue Type: Bug Reporter: Juli

[jira] [Commented] (CALCITE-4197) Provide utility to visualize RelNode plans

2020-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17197152#comment-17197152 ] Julian Hyde commented on CALCITE-4197: -- [~Chunwei Lei], We agreed that this featur

[jira] [Commented] (CALCITE-4182) MV recognition fails when query has constant filter for group by list in mv, but without group by

2020-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4182?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17197140#comment-17197140 ] Julian Hyde commented on CALCITE-4182: -- Commit message is not great. It contains j

[jira] [Commented] (CALCITE-4189) Simplify 'P OR P IS NOT TRUE' to 'TRUE'

2020-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4189?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17197106#comment-17197106 ] Julian Hyde commented on CALCITE-4189: -- The dual of {{simplifyAnd2ForUnknownAsFals

[jira] [Commented] (CALCITE-4189) Simplify 'P OR P IS NOT TRUE' to 'TRUE'

2020-09-16 Thread Thomas Rebele (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4189?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17197045#comment-17197045 ] Thomas Rebele commented on CALCITE-4189: A similar optimization is done for AND

[jira] [Resolved] (CALCITE-4182) MV recognition fails when query has constant filter for group by list in mv, but without group by

2020-09-16 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4182?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin resolved CALCITE-4182. -- Resolution: Fixed > MV recognition fails when query has constant filter for group by list in

[jira] [Commented] (CALCITE-4182) MV recognition fails when query has constant filter for group by list in mv, but without group by

2020-09-16 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4182?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17196989#comment-17196989 ] Wang Yanlin commented on CALCITE-4182: -- Fixed in   https://github.com/apache/calci

[jira] [Commented] (CALCITE-4258) SqlToRelConverter: SELECT 1 IS [NOT] DISTINCT FROM NULL fails with AssertionError

2020-09-16 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4258?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17196964#comment-17196964 ] Ruben Q L commented on CALCITE-4258: PR created. [~julianhyde], could you please ta

[jira] [Updated] (CALCITE-4258) SqlToRelConverter: SELECT 1 IS [NOT] DISTINCT FROM NULL fails with AssertionError

2020-09-16 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4258?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-4258: Labels: pull-request-available (was: ) > SqlToRelConverter: SELECT 1 IS [NOT] DISTINCT F

[jira] [Assigned] (CALCITE-4258) SqlToRelConverter: SELECT 1 IS [NOT] DISTINCT FROM NULL fails with AssertionError

2020-09-16 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4258?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-4258: -- Assignee: Ruben Q L > SqlToRelConverter: SELECT 1 IS [NOT] DISTINCT FROM NULL fails with >

[jira] [Updated] (CALCITE-4258) SqlToRelConverter: SELECT 1 IS [NOT] DISTINCT FROM NULL fails with AssertionError

2020-09-16 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4258?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4258: --- Fix Version/s: 1.26.0 > SqlToRelConverter: SELECT 1 IS [NOT] DISTINCT FROM NULL fails with > Asser

[jira] [Commented] (CALCITE-4258) SqlToRelConverter: SELECT 1 IS [NOT] DISTINCT FROM NULL fails with AssertionError

2020-09-16 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4258?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17196915#comment-17196915 ] Ruben Q L commented on CALCITE-4258: I have just discovered the issue in {{RelOptP

[jira] [Comment Edited] (CALCITE-4258) SqlToRelConverter: SELECT 1 IS [NOT] DISTINCT FROM NULL fails with AssertionError

2020-09-16 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4258?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17196900#comment-17196900 ] Ruben Q L edited comment on CALCITE-4258 at 9/16/20, 11:32 AM: --

[jira] [Commented] (CALCITE-4258) SqlToRelConverter: SELECT 1 IS [NOT] DISTINCT FROM NULL fails with AssertionError

2020-09-16 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4258?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17196900#comment-17196900 ] Ruben Q L commented on CALCITE-4258: First of all, SqlToRelConverter transforms {{1

[jira] [Commented] (CALCITE-4256) RexSimplify should not simplify P AND P to P, if it contains a call to RAND or RAND_INTEGER

2020-09-16 Thread Thomas Rebele (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4256?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17196863#comment-17196863 ] Thomas Rebele commented on CALCITE-4256: Personally, if I write a query with RA

[jira] [Commented] (CALCITE-4159) RexSimplify should simplify more always true OR expressions

2020-09-16 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4159?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17196838#comment-17196838 ] Ruben Q L commented on CALCITE-4159: This ticket seems to have caused a regression:

[jira] [Commented] (CALCITE-4258) SqlToRelConverter: SELECT 1 IS [NOT] DISTINCT FROM NULL fails with AssertionError

2020-09-16 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4258?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17196834#comment-17196834 ] Ruben Q L commented on CALCITE-4258: I have tried to pinpoint when this regression