[jira] [Commented] (CALCITE-3363) JoinUnionTransposeRule.RIGHT_UNION should not match ANTI Join

2019-09-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16933107#comment-16933107 ] Wang Yanlin commented on CALCITE-3363: -- OK, I see. for *A anti join (B union C)*

[jira] [Updated] (CALCITE-3363) JoinUnionTransposeRule.RIGHT_UNION should not match ANTI Join

2019-09-18 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3363?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3363: -- Description: JoinUnionTransposeRule works by pull up union from below to top of join. Thus it should

[jira] [Comment Edited] (CALCITE-3363) JoinUnionTransposeRule.RIGHT_UNION should not match SEMI/ANTI Join

2019-09-18 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16933093#comment-16933093 ] jin xing edited comment on CALCITE-3363 at 9/19/19 6:25 AM:

[jira] [Updated] (CALCITE-3363) JoinUnionTransposeRule.RIGHT_UNION should not match ANTI Join

2019-09-18 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3363?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3363: -- Summary: JoinUnionTransposeRule.RIGHT_UNION should not match ANTI Join (was: JoinUnionTransposeRule.

[jira] [Commented] (CALCITE-3363) JoinUnionTransposeRule.RIGHT_UNION should not match SEMI/ANTI Join

2019-09-18 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16933093#comment-16933093 ] jin xing commented on CALCITE-3363: --- Check my PR please; For sql like below: select

[jira] [Commented] (CALCITE-3353) ProjectJoinTransposeRule caused AssertionError when creating a new Join

2019-09-18 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16933090#comment-16933090 ] jin xing commented on CALCITE-3353: --- [~danny0405] It sometime comes to me that it mi

[jira] [Commented] (CALCITE-3363) JoinUnionTransposeRule.RIGHT_UNION should not match SEMI/ANTI Join

2019-09-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16933072#comment-16933072 ] Wang Yanlin commented on CALCITE-3363: -- Can you give some more specific examples,

[jira] [Updated] (CALCITE-3363) JoinUnionTransposeRule.RIGHT_UNION should not match SEMI/ANTI Join

2019-09-18 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3363?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3363: Labels: pull-request-available (was: ) > JoinUnionTransposeRule.RIGHT_UNION should not m

[jira] [Commented] (CALCITE-3355) Deduce whether CASE and COALESCE may produce NULL values

2019-09-18 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16933046#comment-16933046 ] Danny Chan commented on CALCITE-3355: - Thanks [~kirillkozlov] for reporting this ~

[jira] [Created] (CALCITE-3363) JoinUnionTransposeRule.RIGHT_UNION should not match SEMI/ANTI Join

2019-09-18 Thread jin xing (Jira)
jin xing created CALCITE-3363: - Summary: JoinUnionTransposeRule.RIGHT_UNION should not match SEMI/ANTI Join Key: CALCITE-3363 URL: https://issues.apache.org/jira/browse/CALCITE-3363 Project: Calcite

[jira] [Updated] (CALCITE-3346) Enable some ignored tests in RelOptRuleTests

2019-09-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3346?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3346: - Issue Type: Test (was: Improvement) > Enable some ignored tests in RelOptRuleTests > -

[jira] [Commented] (CALCITE-3355) Deduce whether CASE and COALESCE may produce NULL values

2019-09-18 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16933010#comment-16933010 ] Chunwei Lei commented on CALCITE-3355: -- [~kirillkozlov] , I would like to task thi

[jira] [Comment Edited] (CALCITE-3355) Deduce whether CASE and COALESCE may produce NULL values

2019-09-18 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16933010#comment-16933010 ] Chunwei Lei edited comment on CALCITE-3355 at 9/19/19 2:46 AM: --

[jira] [Updated] (CALCITE-3362) Implementation for some empty tests of Lattice

2019-09-18 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3362?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3362: Labels: pull-request-available (was: ) > Implementation for some empty tests of Lattice

[jira] [Created] (CALCITE-3362) Implementation for some empty tests of Lattice

2019-09-18 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3362: Summary: Implementation for some empty tests of Lattice Key: CALCITE-3362 URL: https://issues.apache.org/jira/browse/CALCITE-3362 Project: Calcite Issue Type

[jira] [Updated] (CALCITE-3360) SqlValidator throws NEP for unregistered function without implicit type coercion

2019-09-18 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3360?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3360: Labels: pull-request-available (was: ) > SqlValidator throws NEP for unregistered functi

[jira] [Commented] (CALCITE-963) Hoist literals

2019-09-18 Thread Scott Reynolds (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16932924#comment-16932924 ] Scott Reynolds commented on CALCITE-963: Giving it some more thought, going to t

[jira] [Commented] (CALCITE-3349) Add Function DDL into SqlKind DDL enum

2019-09-18 Thread Rong Rong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3349?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16932903#comment-16932903 ] Rong Rong commented on CALCITE-3349: +1 on [~suez1224]'s point combining into one P

[jira] [Commented] (CALCITE-963) Hoist literals

2019-09-18 Thread Scott Reynolds (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16932891#comment-16932891 ] Scott Reynolds commented on CALCITE-963: {quote} * I was surprised that HoistedV

[jira] [Commented] (CALCITE-963) Hoist literals

2019-09-18 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16932872#comment-16932872 ] Julian Hyde commented on CALCITE-963: - I looked at the PR briefly: * I was surprised

[jira] [Commented] (CALCITE-1178) Allow SqlBetweenOperator to compare DATE and TIMESTAMP

2019-09-18 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1178?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16932868#comment-16932868 ] Haisheng Yuan commented on CALCITE-1178: Not a bug. I think it is a yet impleme

[jira] [Comment Edited] (CALCITE-963) Hoist literals

2019-09-18 Thread Scott Reynolds (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16932829#comment-16932829 ] Scott Reynolds edited comment on CALCITE-963 at 9/18/19 9:14 PM: -

[jira] [Comment Edited] (CALCITE-963) Hoist literals

2019-09-18 Thread Scott Reynolds (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16932829#comment-16932829 ] Scott Reynolds edited comment on CALCITE-963 at 9/18/19 9:09 PM: -

[jira] [Comment Edited] (CALCITE-963) Hoist literals

2019-09-18 Thread Scott Reynolds (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16932829#comment-16932829 ] Scott Reynolds edited comment on CALCITE-963 at 9/18/19 9:09 PM: -

[jira] [Comment Edited] (CALCITE-963) Hoist literals

2019-09-18 Thread Scott Reynolds (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16932829#comment-16932829 ] Scott Reynolds edited comment on CALCITE-963 at 9/18/19 8:57 PM: -

[jira] [Updated] (CALCITE-963) Hoist literals

2019-09-18 Thread Scott Reynolds (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Scott Reynolds updated CALCITE-963: --- Attachment: (was: HoistedVariables.png) > Hoist literals > -- > >

[jira] [Comment Edited] (CALCITE-963) Hoist literals

2019-09-18 Thread Scott Reynolds (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16932829#comment-16932829 ] Scott Reynolds edited comment on CALCITE-963 at 9/18/19 8:56 PM: -

[jira] [Commented] (CALCITE-963) Hoist literals

2019-09-18 Thread Scott Reynolds (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16932829#comment-16932829 ] Scott Reynolds commented on CALCITE-963: h1. Goal When a query is issued to Cal

[jira] [Updated] (CALCITE-963) Hoist literals

2019-09-18 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-963: --- Labels: pull-request-available (was: ) > Hoist literals > -- > >

[jira] [Created] (CALCITE-3361) Add a test that parses and validates a SQL statement with every built-in Redshift function

2019-09-18 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-3361: Summary: Add a test that parses and validates a SQL statement with every built-in Redshift function Key: CALCITE-3361 URL: https://issues.apache.org/jira/browse/CALCITE-3361

[jira] [Updated] (CALCITE-3353) ProjectJoinTransposeRule caused AssertionError when creating a new Join

2019-09-18 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3353: Labels: pull-request-available (was: ) > ProjectJoinTransposeRule caused AssertionError

[jira] [Comment Edited] (CALCITE-3353) ProjectJoinTransposeRule caused AssertionError when creating a new Join

2019-09-18 Thread TANG Wen-hui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16932413#comment-16932413 ] TANG Wen-hui edited comment on CALCITE-3353 at 9/18/19 1:00 PM: -

[jira] [Comment Edited] (CALCITE-3353) ProjectJoinTransposeRule caused AssertionError when creating a new Join

2019-09-18 Thread TANG Wen-hui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16932413#comment-16932413 ] TANG Wen-hui edited comment on CALCITE-3353 at 9/18/19 12:59 PM:

[jira] [Commented] (CALCITE-3353) ProjectJoinTransposeRule caused AssertionError when creating a new Join

2019-09-18 Thread TANG Wen-hui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16932413#comment-16932413 ] TANG Wen-hui commented on CALCITE-3353: --- [~danny0405],Yes, "forbidden to match co

[jira] [Commented] (CALCITE-1178) Allow SqlBetweenOperator to compare DATE and TIMESTAMP

2019-09-18 Thread Jacob Roldan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1178?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16932382#comment-16932382 ] Jacob Roldan commented on CALCITE-1178: --- Since calcite 1.21 it's possible to do {

[jira] [Created] (CALCITE-3360) SqlValidator throws NEP for unregistered function without implicit type coercion

2019-09-18 Thread Danny Chan (Jira)
Danny Chan created CALCITE-3360: --- Summary: SqlValidator throws NEP for unregistered function without implicit type coercion Key: CALCITE-3360 URL: https://issues.apache.org/jira/browse/CALCITE-3360 Pro

[jira] [Commented] (CALCITE-2707) Information about distinct aggregation is lost in MATCH_RECOGNIZE

2019-09-18 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2707?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16932181#comment-16932181 ] Danny Chan commented on CALCITE-2707: - When can we fix this issue, there is a copy

[jira] [Commented] (CALCITE-2405) In Babel parser: allow to use some reserved keyword as identifier

2019-09-18 Thread Enrico Olivelli (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16932171#comment-16932171 ] Enrico Olivelli commented on CALCITE-2405: -- [~julianhyde] do you think it is f