[jira] [Commented] (CALCITE-4364) Simplify "a IN (1, 2) AND a = 1" to "a = 1"

[ https://issues.apache.org/jira/browse/CALCITE-4364?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17229760#comment-17229760 ] Danny Chen commented on CALCITE-4364: - Thanks, the latest change: 1. Refactor out {

[jira] [Commented] (CALCITE-4386) Support RelShuttle visit specific logical operators

[ https://issues.apache.org/jira/browse/CALCITE-4386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17229718#comment-17229718 ] Haisheng Yuan commented on CALCITE-4386: Sorry, I still don't get it. Can you a

[jira] [Commented] (CALCITE-4386) Support RelShuttle visit specific logical operators

[ https://issues.apache.org/jira/browse/CALCITE-4386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17229710#comment-17229710 ] xzh_dz commented on CALCITE-4386: - Thanks.  If we want `RelShuttle` to access an operat

[jira] [Updated] (CALCITE-4375) Optimize join when condition has "OR" and can be extracted common expression

[ https://issues.apache.org/jira/browse/CALCITE-4375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiatao Tao updated CALCITE-4375: Summary: Optimize join when condition has "OR" and can be extracted common expression (was: Merg

[jira] [Commented] (CALCITE-4375) Merge join condition that has "OR"

[ https://issues.apache.org/jira/browse/CALCITE-4375?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17229670#comment-17229670 ] Jiatao Tao commented on CALCITE-4375: - Sure, I'll remove this. > Merge join condit

[jira] [Updated] (CALCITE-4375) Merge join condition that has "OR"

[ https://issues.apache.org/jira/browse/CALCITE-4375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiatao Tao updated CALCITE-4375: Summary: Merge join condition that has "OR" (was: Merge join condition that has "OR" as much as

[jira] [Updated] (CALCITE-4375) Merge join condition that has "OR" as much as possible

[ https://issues.apache.org/jira/browse/CALCITE-4375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiatao Tao updated CALCITE-4375: Description: SQL: SELECT * FROM emps,depts WHERE (emps.name = depts.name AND empno=1) OR (

[jira] [Commented] (CALCITE-4386) Support RelShuttle visit specific logical operators

[ https://issues.apache.org/jira/browse/CALCITE-4386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17229641#comment-17229641 ] Haisheng Yuan commented on CALCITE-4386: AbstractRelNode has default implementa

[jira] [Commented] (CALCITE-4364) Simplify "a IN (1, 2) AND a = 1" to "a = 1"

[ https://issues.apache.org/jira/browse/CALCITE-4364?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17229426#comment-17229426 ] Julian Hyde commented on CALCITE-4364: -- The new {{flattenOperands}} is very simila

[jira] [Updated] (CALCITE-4364) Simplify "a IN (1, 2) AND a = 1" to "a = 1"

[ https://issues.apache.org/jira/browse/CALCITE-4364?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4364: - Description: Calcite should simplify "\{{a IN (1, 2) AND a = 1}}" to "\{{a = 1}}". Check this

[jira] [Updated] (CALCITE-4364) Simplify "a IN (1, 2) AND a = 1" to "a = 1"

[ https://issues.apache.org/jira/browse/CALCITE-4364?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4364: - Summary: Simplify "a IN (1, 2) AND a = 1" to "a = 1" (was: "a in (1, 2) and a = 1" should be s

[jira] [Created] (CALCITE-4391) When the join condition order is different, materialized view recognition fails

xzh_dz created CALCITE-4391: --- Summary: When the join condition order is different, materialized view recognition fails Key: CALCITE-4391 URL: https://issues.apache.org/jira/browse/CALCITE-4391 Project: Calc

[jira] [Commented] (CALCITE-4375) Merge join condition that has "OR" as much as possible

[ https://issues.apache.org/jira/browse/CALCITE-4375?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17229090#comment-17229090 ] Vladimir Sitnikov commented on CALCITE-4375: {quote} as much as possible{qu

[jira] [Created] (CALCITE-4390) SqlMatchRecognize returns wrong operand list

Dawid Wysakowicz created CALCITE-4390: - Summary: SqlMatchRecognize returns wrong operand list Key: CALCITE-4390 URL: https://issues.apache.org/jira/browse/CALCITE-4390 Project: Calcite Is

[jira] [Comment Edited] (CALCITE-4385) Simplifies AND/OR condition that has common expressions, extract and eliminate/merge them as much as possible

[ https://issues.apache.org/jira/browse/CALCITE-4385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17228489#comment-17228489 ] Jiatao Tao edited comment on CALCITE-4385 at 11/10/20, 8:16 AM: -

[jira] [Commented] (CALCITE-4385) Simplifies AND/OR condition that has common expressions, extract and eliminate/merge them as much as possible

[ https://issues.apache.org/jira/browse/CALCITE-4385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17229050#comment-17229050 ] Jiatao Tao commented on CALCITE-4385: - Hi, [~Chunwei Lei] I updated the title and t

[jira] [Comment Edited] (CALCITE-4385) Simplifies AND/OR condition that has common expressions, extract and eliminate/merge them as much as possible

[ https://issues.apache.org/jira/browse/CALCITE-4385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17228489#comment-17228489 ] Jiatao Tao edited comment on CALCITE-4385 at 11/10/20, 8:12 AM: -

[jira] [Comment Edited] (CALCITE-4385) Simplifies AND/OR condition that has common expressions, extract and eliminate/merge them as much as possible

[ https://issues.apache.org/jira/browse/CALCITE-4385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17228489#comment-17228489 ] Jiatao Tao edited comment on CALCITE-4385 at 11/10/20, 8:12 AM: -

[jira] [Updated] (CALCITE-4385) Simplifies AND/OR condition that has common expressions, extract and eliminate/merge them as much as possible

[ https://issues.apache.org/jira/browse/CALCITE-4385?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiatao Tao updated CALCITE-4385: Summary: Simplifies AND/OR condition that has common expressions, extract and eliminate/merge the