[jira] [Updated] (CALCITE-2311) case when returns redundant white space

[ https://issues.apache.org/jira/browse/CALCITE-2311?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2311: Affects Version/s: (was: 1.1.0-incubating) 1.12.0 Fix

[jira] [Created] (CALCITE-2311) case when returns redundant white space

pengzhiwei created CALCITE-2311: --- Summary: case when returns redundant white space Key: CALCITE-2311 URL: https://issues.apache.org/jira/browse/CALCITE-2311 Project: Calcite Issue Type: Bug

[jira] [Updated] (CALCITE-2311) case when returns redundant white space

[ https://issues.apache.org/jira/browse/CALCITE-2311?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2311: Fix Version/s: (was: 1.17.0) 1.12.0 > case when returns redundant white

[jira] [Updated] (CALCITE-2311) case when returns redundant white space

[ https://issues.apache.org/jira/browse/CALCITE-2311?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2311: Description: If the case-when expression has two branches which returns string literal,redundant

[jira] [Created] (CALCITE-2393) RexSimplify optimization error for expression 'x is not null and x <> 5'

pengzhiwei created CALCITE-2393: --- Summary: RexSimplify optimization error for expression 'x is not null and x <> 5' Key: CALCITE-2393 URL: https://issues.apache.org/jira/browse/CALCITE-2393 Project:

[jira] [Comment Edited] (CALCITE-2382) Column not found when subquery join lateral table function

[ https://issues.apache.org/jira/browse/CALCITE-2382?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16524568#comment-16524568 ] pengzhiwei edited comment on CALCITE-2382 at 6/27/18 4:52 AM: -- Hello

[jira] [Updated] (CALCITE-2382) Column not found when subquery join lateral table function

[ https://issues.apache.org/jira/browse/CALCITE-2382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2382: Attachment: 屏幕快照 2018-06-27 下午12.39.46.png > Column not found when subquery join lateral table

[jira] [Commented] (CALCITE-2382) Column not found when subquery join lateral table function

[ https://issues.apache.org/jira/browse/CALCITE-2382?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16524568#comment-16524568 ] pengzhiwei commented on CALCITE-2382: - Hello Julian,I have test on top of your branch.A exception

[jira] [Comment Edited] (CALCITE-2382) Column not found when subquery join lateral table function

[ https://issues.apache.org/jira/browse/CALCITE-2382?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16524568#comment-16524568 ] pengzhiwei edited comment on CALCITE-2382 at 6/27/18 4:55 AM: -- Hello

[jira] [Comment Edited] (CALCITE-2382) Column not found when subquery join lateral table function

[ https://issues.apache.org/jira/browse/CALCITE-2382?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16524568#comment-16524568 ] pengzhiwei edited comment on CALCITE-2382 at 6/27/18 5:00 AM: -- Hello

[jira] [Created] (CALCITE-2382) Column not found when subquery join lateral table function

pengzhiwei created CALCITE-2382: --- Summary: Column not found when subquery join lateral table function Key: CALCITE-2382 URL: https://issues.apache.org/jira/browse/CALCITE-2382 Project: Calcite

[jira] [Updated] (CALCITE-2382) Column not found when subquery join lateral table function

[ https://issues.apache.org/jira/browse/CALCITE-2382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2382: Description: When using subquery join lateral table function as followed:   {code:java} select

[jira] [Updated] (CALCITE-2382) Column not found when subquery join lateral table function

[ https://issues.apache.org/jira/browse/CALCITE-2382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2382: Description: When using subquery join lateral table function as followed:   {code:java} select

[jira] [Updated] (CALCITE-2382) Column not found when subquery join lateral table function

[ https://issues.apache.org/jira/browse/CALCITE-2382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2382: Description: When using subquery join lateral table function as followed:   {code:java} select

[jira] [Closed] (CALCITE-2393) RexSimplify optimization error for expression 'x is not null and x <> 5'

[ https://issues.apache.org/jira/browse/CALCITE-2393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei closed CALCITE-2393. --- Resolution: Not A Problem > RexSimplify optimization error for expression 'x is not null and x <>

[jira] [Commented] (CALCITE-2393) RexSimplify optimization error for expression 'x is not null and x <> 5'

[ https://issues.apache.org/jira/browse/CALCITE-2393?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16530770#comment-16530770 ] pengzhiwei commented on CALCITE-2393: - Thank [~kgyrtkirk] and [~julianhyde]  very much!  I have

[jira] [Created] (CALCITE-2438) RexCall#isAlwaysTrue return incorrect result

pengzhiwei created CALCITE-2438: --- Summary: RexCall#isAlwaysTrue return incorrect result Key: CALCITE-2438 URL: https://issues.apache.org/jira/browse/CALCITE-2438 Project: Calcite Issue Type:

[jira] [Updated] (CALCITE-2438) RexCall#isAlwaysTrue return incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-2438?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2438: Description: In the expression as followed: {code:java} ((sal IS NULL) IS NOT NULL) IS FALSE

[jira] [Updated] (CALCITE-2424) AggregateProjectPullUpConstantsRule throws AssertionError when sql contains "where 'a' is null"

[ https://issues.apache.org/jira/browse/CALCITE-2424?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2424: Affects Version/s: (was: 1.16.0) 1.17.0 >

[jira] [Commented] (CALCITE-2448) AggregateProjectPullUpConstantsRule throws AssertionError

[ https://issues.apache.org/jira/browse/CALCITE-2448?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16577111#comment-16577111 ] pengzhiwei commented on CALCITE-2448: - I make a pr for this issue,anybody can have a check for

[jira] [Issue Comment Deleted] (CALCITE-2448) AggregateProjectPullUpConstantsRule throws AssertionError

[ https://issues.apache.org/jira/browse/CALCITE-2448?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2448: Comment: was deleted (was: Hi  @[~atris]  I am sorry that I have another pr has not been

[jira] [Commented] (CALCITE-2438) RexCall#isAlwaysTrue return incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-2438?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16569080#comment-16569080 ] pengzhiwei commented on CALCITE-2438: - Hi [~julianhyde] ,here is my pr for this problem: 

[jira] [Comment Edited] (CALCITE-2438) RexCall#isAlwaysTrue return incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-2438?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16571077#comment-16571077 ] pengzhiwei edited comment on CALCITE-2438 at 8/7/18 6:55 AM: - I think the

[jira] [Commented] (CALCITE-2438) RexCall#isAlwaysTrue return incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-2438?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16571077#comment-16571077 ] pengzhiwei commented on CALCITE-2438: - I think the pr of [~vladimirsitnikov] is a more general

[jira] [Comment Edited] (CALCITE-2438) RexCall#isAlwaysTrue return incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-2438?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16571077#comment-16571077 ] pengzhiwei edited comment on CALCITE-2438 at 8/7/18 3:16 AM: - I think the

[jira] [Comment Edited] (CALCITE-2438) RexCall#isAlwaysTrue return incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-2438?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16571077#comment-16571077 ] pengzhiwei edited comment on CALCITE-2438 at 8/7/18 6:32 AM: - I think the

[jira] [Comment Edited] (CALCITE-2438) RexCall#isAlwaysTrue return incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-2438?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16571077#comment-16571077 ] pengzhiwei edited comment on CALCITE-2438 at 8/7/18 6:57 AM: - Hi

[jira] [Comment Edited] (CALCITE-2438) RexCall#isAlwaysTrue return incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-2438?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16571077#comment-16571077 ] pengzhiwei edited comment on CALCITE-2438 at 8/7/18 6:29 AM: - I think the

[jira] [Updated] (CALCITE-2469) RexSimplify should not optimize 'not(x) is null' to 'x is not null

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2469: Description: The RexSimplify has optimized the 'not（x) is null' to 'x is not null'.

[jira] [Updated] (CALCITE-2469) RexSimplify should not optimize 'not(x) is null' to 'x is not null

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2469: Description: The RexSimplify has optimized the 'not（x) is null' to 'x is not null'.

[jira] [Updated] (CALCITE-2469) RexSimplify should not optimize 'not(x) is null' to 'x is not null

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2469: Description: The RexSimplify has optimized the 'not（x) is null' to 'x is not null'.

[jira] [Created] (CALCITE-2469) RexSimplify should not optimize 'not(x) is null' to 'x is not null

pengzhiwei created CALCITE-2469: --- Summary: RexSimplify should not optimize 'not(x) is null' to 'x is not null Key: CALCITE-2469 URL: https://issues.apache.org/jira/browse/CALCITE-2469 Project: Calcite

[jira] [Updated] (CALCITE-2469) RexSimplify should not optimize 'not(x) is null' to 'x is not null

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2469: Description: The RexSimplify will optimize the 'not（x) is null' to 'x is not null'.

[jira] [Updated] (CALCITE-2469) RexSimplify should not optimize 'not(x) is null' to 'x is not null

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2469: Description: The RexSimplify has optimized the 'not(x) is null' to 'x is not null'.

[jira] [Updated] (CALCITE-2469) RexSimplify should not optimize 'not(x) is null' to 'x is not null

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2469: Description: The RexSimplify has optimized the 'not（x) is null' to 'x is not null'.

[jira] [Commented] (CALCITE-2469) RexSimplify should not optimize 'not(x) is null' to 'x is not null

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16582069#comment-16582069 ] pengzhiwei commented on CALCITE-2469: - I have made a PR for this problem,Anybody can have a check

[jira] [Comment Edited] (CALCITE-2469) RexSimplify should not optimize 'not(x) is null' to 'x is not null

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16582745#comment-16582745 ] pengzhiwei edited comment on CALCITE-2469 at 8/16/18 4:04 PM: -- I agree

[jira] [Commented] (CALCITE-2469) RexSimplify should not optimize 'not(x) is null' to 'x is not null

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16582745#comment-16582745 ] pengzhiwei commented on CALCITE-2469: - I agree with you [~vladimirsitnikov] that 'not(x) is null'

[jira] [Comment Edited] (CALCITE-2469) RexSimplify should not optimize 'not(x) is null' to 'x is not null

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16582745#comment-16582745 ] pengzhiwei edited comment on CALCITE-2469 at 8/16/18 4:06 PM: -- I agree

[jira] [Comment Edited] (CALCITE-2469) RexSimplify should not optimize '(not x) is null' to 'x is not null

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16583330#comment-16583330 ] pengzhiwei edited comment on CALCITE-2469 at 8/17/18 6:45 AM: --

[jira] [Commented] (CALCITE-2469) RexSimplify should not optimize 'not(x) is null' to 'x is not null

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16583298#comment-16583298 ] pengzhiwei commented on CALCITE-2469: - Hi @[~vladimirsitnikov]  {noformat} | I'm not convinced

[jira] [Commented] (CALCITE-2469) RexSimplify should not optimize '(not x) is null' to 'x is not null

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16583330#comment-16583330 ] pengzhiwei commented on CALCITE-2469: - [~julianhyde] and [~vladimirsitnikov] I have change the

[jira] [Updated] (CALCITE-2469) RexSimplify should not optimize '(not x) is null' to 'x is not null

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2469: Description: The RexSimplify will optimize the '(not x) is null' to 'x is not null'.

[jira] [Updated] (CALCITE-2469) RexSimplify should not optimize '(not x) is null' to 'x is not null

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2469: Summary: RexSimplify should not optimize '(not x) is null' to 'x is not null (was: RexSimplify

[jira] [Issue Comment Deleted] (CALCITE-2469) RexSimplify should not optimize '(not x) is null' to 'x is not null

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2469: Comment: was deleted (was: Hi @[~vladimirsitnikov]  {noformat} | I'm not convinced why another

[jira] [Comment Edited] (CALCITE-2469) RexSimplify should not optimize '(not x) is null' to 'x is not null

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16582069#comment-16582069 ] pengzhiwei edited comment on CALCITE-2469 at 8/17/18 6:44 AM: -- I have made

[jira] [Comment Edited] (CALCITE-2469) RexSimplify should not optimize '(not x) is null' to 'x is not null

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16583330#comment-16583330 ] pengzhiwei edited comment on CALCITE-2469 at 8/17/18 6:44 AM: --

[jira] [Comment Edited] (CALCITE-2469) RexSimplify should not optimize '(not x) is null' to 'x is not null

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16583330#comment-16583330 ] pengzhiwei edited comment on CALCITE-2469 at 8/17/18 6:47 AM: --

[jira] [Updated] (CALCITE-2469) RexSimplify should not optimize '(not x) is null' to 'x is not null'

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2469: Summary: RexSimplify should not optimize '(not x) is null' to 'x is not null' (was: RexSimplify

[jira] [Comment Edited] (CALCITE-2469) RexSimplify should not optimize '(not x) is null' to 'x is not null

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16583330#comment-16583330 ] pengzhiwei edited comment on CALCITE-2469 at 8/17/18 9:38 AM: --

[jira] [Updated] (CALCITE-2448) AggregateProjectPullUpConstantsRule throws AssertionError

[ https://issues.apache.org/jira/browse/CALCITE-2448?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2448: Affects Version/s: 1.17.0 > AggregateProjectPullUpConstantsRule throws AssertionError >

[jira] [Updated] (CALCITE-2448) AggregateProjectPullUpConstantsRule throws AssertionError

[ https://issues.apache.org/jira/browse/CALCITE-2448?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2448: Description: In the sql as followed: {code:java} select 'a',-emp.deptno from emp where 'a' is

[jira] [Created] (CALCITE-2448) AggregateProjectPullUpConstantsRule throws AssertionError

pengzhiwei created CALCITE-2448: --- Summary: AggregateProjectPullUpConstantsRule throws AssertionError Key: CALCITE-2448 URL: https://issues.apache.org/jira/browse/CALCITE-2448 Project: Calcite

[jira] [Updated] (CALCITE-2448) AggregateProjectPullUpConstantsRule throws AssertionError

[ https://issues.apache.org/jira/browse/CALCITE-2448?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2448: Description: In the sql as followed: {code:java} select 'a',-emp.deptno from emp where 'a' is

[jira] [Closed] (CALCITE-2424) AggregateProjectPullUpConstantsRule throws AssertionError when sql contains "where 'a' is null"

[ https://issues.apache.org/jira/browse/CALCITE-2424?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei closed CALCITE-2424. --- Resolution: Duplicate > AggregateProjectPullUpConstantsRule throws AssertionError when sql

[jira] [Updated] (CALCITE-2448) AggregateProjectPullUpConstantsRule throws AssertionError

[ https://issues.apache.org/jira/browse/CALCITE-2448?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2448: Description: In the sql as followed: {code:java} select 'a',-emp.deptno from emp where 'a' is

[jira] [Updated] (CALCITE-2448) AggregateProjectPullUpConstantsRule throws AssertionError

[ https://issues.apache.org/jira/browse/CALCITE-2448?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2448: Attachment: 屏幕快照 2018-08-06 下午9.19.48.png > AggregateProjectPullUpConstantsRule throws

[jira] [Comment Edited] (CALCITE-2438) RexCall#isAlwaysTrue return incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-2438?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16571510#comment-16571510 ] pengzhiwei edited comment on CALCITE-2438 at 8/7/18 12:04 PM: -- Thank 

[jira] [Commented] (CALCITE-2448) AggregateProjectPullUpConstantsRule throws AssertionError

[ https://issues.apache.org/jira/browse/CALCITE-2448?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16570282#comment-16570282 ] pengzhiwei commented on CALCITE-2448: - Hi  @[~atris]  I am sorry that I have another pr has not

[jira] [Commented] (CALCITE-2448) AggregateProjectPullUpConstantsRule throws AssertionError

[ https://issues.apache.org/jira/browse/CALCITE-2448?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16570298#comment-16570298 ] pengzhiwei commented on CALCITE-2448: - Hi @[~Sergey Nuyanzin],In the command line mode,the 

[jira] [Comment Edited] (CALCITE-2448) AggregateProjectPullUpConstantsRule throws AssertionError

[ https://issues.apache.org/jira/browse/CALCITE-2448?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16577111#comment-16577111 ] pengzhiwei edited comment on CALCITE-2448 at 8/13/18 3:08 AM: -- Hi

[jira] [Commented] (CALCITE-2469) RexSimplify should not optimize '(not x) is null' to 'x is not null'

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16593237#comment-16593237 ] pengzhiwei commented on CALCITE-2469: - Hi @[~vladimirsitnikov] ,do we need to fix this issue or

[jira] [Comment Edited] (CALCITE-2469) RexSimplify should not optimize '(not x) is null' to 'x is not null'

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16583330#comment-16583330 ] pengzhiwei edited comment on CALCITE-2469 at 8/23/18 7:31 AM: --

[jira] [Updated] (CALCITE-2424) AggregateProjectPullUpConstantsRule throws AssertionError when sql contains "where 'a' is null"

[ https://issues.apache.org/jira/browse/CALCITE-2424?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2424: Summary: AggregateProjectPullUpConstantsRule throws AssertionError when sql contains "where

[jira] [Updated] (CALCITE-2424) AggregateProjectPullUpConstantsRule throws AssertionError when sql contains "where 'a' is null"

[ https://issues.apache.org/jira/browse/CALCITE-2424?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2424: Fix Version/s: (was: 1.17.0) > AggregateProjectPullUpConstantsRule throws AssertionError

[jira] [Updated] (CALCITE-2424) AggregateProjectPullUpConstantsRule throws AssertionError when sql has "where 'a' is null"

[ https://issues.apache.org/jira/browse/CALCITE-2424?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2424: Description: In the sql shown bellow: {code:java} select 'a',-emp.deptno from emp where 'a' is

[jira] [Created] (CALCITE-2424) AggregateProjectPullUpConstantsRule throws AssertionError when sql has "where 'a' is null"

pengzhiwei created CALCITE-2424: --- Summary: AggregateProjectPullUpConstantsRule throws AssertionError when sql has "where 'a' is null" Key: CALCITE-2424 URL: https://issues.apache.org/jira/browse/CALCITE-2424

[jira] [Updated] (CALCITE-2424) AggregateProjectPullUpConstantsRule throws AssertionError when sql has "where 'a' is null"

[ https://issues.apache.org/jira/browse/CALCITE-2424?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2424: Description: In the sql shown bellow: {code:java} select 'a',-emp.deptno from emp where 'a' is

[jira] [Commented] (CALCITE-2469) RexSimplify should optimize '(NOT x) IS NULL' to 'x IS NULL'

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16598134#comment-16598134 ] pengzhiwei commented on CALCITE-2469: - Hi [~julianhyde],I find same problem in the "improvement for

[jira] [Comment Edited] (CALCITE-2469) RexSimplify should optimize '(NOT x) IS NULL' to 'x IS NULL'

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16598134#comment-16598134 ] pengzhiwei edited comment on CALCITE-2469 at 8/31/18 2:36 AM: -- Hi

[jira] [Comment Edited] (CALCITE-2469) RexSimplify should optimize '(NOT x) IS NULL' to 'x IS NULL'

[ https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16598134#comment-16598134 ] pengzhiwei edited comment on CALCITE-2469 at 8/31/18 11:14 AM: --- Hi

[jira] [Updated] (CALCITE-2551) ClassCastException in SqlToRelConverter#pushDownNotForIn

[ https://issues.apache.org/jira/browse/CALCITE-2551?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2551: Description: In the sql as follow: {code:java} select empno from emp where not case when true

[jira] [Updated] (CALCITE-2551) ClassCastException in SqlToRelConverter#pushDownNotForIn

[ https://issues.apache.org/jira/browse/CALCITE-2551?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2551: Description: In the sql as follow: {code:java} select empno from emp where not case when true

[jira] [Created] (CALCITE-2551) ClassCastException in SqlToRelConverter#pushDownNotForIn

pengzhiwei created CALCITE-2551: --- Summary: ClassCastException in SqlToRelConverter#pushDownNotForIn Key: CALCITE-2551 URL: https://issues.apache.org/jira/browse/CALCITE-2551 Project: Calcite

[jira] [Updated] (CALCITE-2551) ClassCastException in SqlToRelConverter#pushDownNotForIn

[ https://issues.apache.org/jira/browse/CALCITE-2551?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2551: Description: In the sql as follow: {code:java} select empno from emp where not case when true

[jira] [Updated] (CALCITE-2551) ClassCastException in SqlToRelConverter#pushDownNotForIn

[ https://issues.apache.org/jira/browse/CALCITE-2551?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2551: Description: In the sql as follow: {code:java} select empno from emp where not case when true

[jira] [Updated] (CALCITE-2551) ClassCastException in SqlToRelConverter#pushDownNotForIn

[ https://issues.apache.org/jira/browse/CALCITE-2551?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2551: Attachment: 屏幕快照 2018-09-12 上午11.12.11.png > ClassCastException in

[jira] [Updated] (CALCITE-2551) ClassCastException in SqlToRelConverter#pushDownNotForIn

[ https://issues.apache.org/jira/browse/CALCITE-2551?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2551: Description: In the sql as follow: {code:java} select empno from emp where not case when true

[jira] [Comment Edited] (CALCITE-2382) Column not found when subquery join lateral table function

[ https://issues.apache.org/jira/browse/CALCITE-2382?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16524568#comment-16524568 ] pengzhiwei edited comment on CALCITE-2382 at 6/29/18 2:42 AM: -- Hello

[jira] [Updated] (CALCITE-2382) Column not found when subquery join lateral table function

[ https://issues.apache.org/jira/browse/CALCITE-2382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2382: Description: # When using subquery join lateral table function as followed:   {code:java}

[jira] [Commented] (CALCITE-2620) Simplify "coalesce(null,x)" to "x"

[ https://issues.apache.org/jira/browse/CALCITE-2620?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16648733#comment-16648733 ] pengzhiwei commented on CALCITE-2620: - [~julianhyde],In  -CALCITE-2506- this issue has not fixed. I

[jira] [Comment Edited] (CALCITE-2620) Simplify "coalesce(null,x)" to "x"

[ https://issues.apache.org/jira/browse/CALCITE-2620?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16648733#comment-16648733 ] pengzhiwei edited comment on CALCITE-2620 at 10/13/18 4:09 AM: ---

[jira] [Comment Edited] (CALCITE-2620) Simplify "coalesce(null,x)" to "x"

[ https://issues.apache.org/jira/browse/CALCITE-2620?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16648733#comment-16648733 ] pengzhiwei edited comment on CALCITE-2620 at 10/13/18 4:10 AM: ---

[jira] [Comment Edited] (CALCITE-2620) Simplify "coalesce(null,x)" to "x"

[ https://issues.apache.org/jira/browse/CALCITE-2620?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16648733#comment-16648733 ] pengzhiwei edited comment on CALCITE-2620 at 10/13/18 4:09 AM: ---

[jira] [Commented] (CALCITE-2630) Convert SqlInOperator to In-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16656240#comment-16656240 ] pengzhiwei commented on CALCITE-2630: - Hi [~julianhyde],We are talking about keeping "In

[jira] [Comment Edited] (CALCITE-2630) Convert SqlInOperator to In-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16656410#comment-16656410 ] pengzhiwei edited comment on CALCITE-2630 at 10/19/18 7:57 AM: ---    _By

[jira] [Comment Edited] (CALCITE-2630) Convert SqlInOperator to In-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16656440#comment-16656440 ] pengzhiwei edited comment on CALCITE-2630 at 10/19/18 8:30 AM: --- _you can

[jira] [Comment Edited] (CALCITE-2630) Convert SqlInOperator to In-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16656440#comment-16656440 ] pengzhiwei edited comment on CALCITE-2630 at 10/19/18 8:33 AM: --- _you can

[jira] [Comment Edited] (CALCITE-2630) Convert SqlInOperator to In-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16656410#comment-16656410 ] pengzhiwei edited comment on CALCITE-2630 at 10/19/18 7:56 AM: ---    _By

[jira] [Comment Edited] (CALCITE-2630) Convert SqlInOperator to In-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16656240#comment-16656240 ] pengzhiwei edited comment on CALCITE-2630 at 10/19/18 8:01 AM: --- Hi

[jira] [Commented] (CALCITE-2630) Convert SqlInOperator to In-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16656440#comment-16656440 ] pengzhiwei commented on CALCITE-2630: - _you can have your optimized physical IN operator in your

[jira] [Commented] (CALCITE-2630) Convert SqlInOperator to In-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16656256#comment-16656256 ] pengzhiwei commented on CALCITE-2630: - [~zabetak] You are right that it may break the 3rd party

[jira] [Commented] (CALCITE-2630) Convert SqlInOperator to In-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16656410#comment-16656410 ] pengzhiwei commented on CALCITE-2630: -    _By adjusting the subQuertThreshold you can avoid the

[jira] [Comment Edited] (CALCITE-2630) Convert SqlInOperator to In-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16656256#comment-16656256 ] pengzhiwei edited comment on CALCITE-2630 at 10/19/18 6:51 AM: ---

[jira] [Comment Edited] (CALCITE-2630) Convert SqlInOperator to In-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16656256#comment-16656256 ] pengzhiwei edited comment on CALCITE-2630 at 10/19/18 6:50 AM: ---

[jira] [Comment Edited] (CALCITE-2630) Convert SqlInOperator to In-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16656256#comment-16656256 ] pengzhiwei edited comment on CALCITE-2630 at 10/19/18 6:50 AM: ---

[jira] [Assigned] (CALCITE-2630) Convert SqlInOperator to In-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei reassigned CALCITE-2630: --- Assignee: pengzhiwei (was: Julian Hyde) > Convert SqlInOperator to In-Expression >

[jira] [Updated] (CALCITE-2630) Convert SqlInOperator to In-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2630: Description: Currently Calcite translate "IN" to "OR" expression when the count of  IN's

[jira] [Created] (CALCITE-2630) Convert SqlInOperator to a IN-Function

pengzhiwei created CALCITE-2630: --- Summary: Convert SqlInOperator to a IN-Function Key: CALCITE-2630 URL: https://issues.apache.org/jira/browse/CALCITE-2630 Project: Calcite Issue Type:

[jira] [Updated] (CALCITE-2630) Convert SqlInOperator to a IN-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2630: Summary: Convert SqlInOperator to a IN-Expression (was: Convert SqlInOperator to a IN-Function)

  1   2   3   >