[jira] [Comment Edited] (CALCITE-3998) Bad datatype for sum(n), it should be BIGINT but it is sometimes INTEGER

[ https://issues.apache.org/jira/browse/CALCITE-3998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106893#comment-17106893 ] TANG Wen-hui edited comment on CALCITE-3998 at 5/14/20, 5:10 AM: - The

[jira] [Comment Edited] (CALCITE-3998) Bad datatype for sum(n), it should be BIGINT but it is sometimes INTEGER

[ https://issues.apache.org/jira/browse/CALCITE-3998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106893#comment-17106893 ] TANG Wen-hui edited comment on CALCITE-3998 at 5/14/20, 5:10 AM: - The

[jira] [Comment Edited] (CALCITE-3998) Bad datatype for sum(n), it should be BIGINT but it is sometimes INTEGER

[ https://issues.apache.org/jira/browse/CALCITE-3998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106893#comment-17106893 ] TANG Wen-hui edited comment on CALCITE-3998 at 5/14/20, 5:09 AM: - The

[jira] [Comment Edited] (CALCITE-3998) Bad datatype for sum(n), it should be BIGINT but it is sometimes INTEGER

[ https://issues.apache.org/jira/browse/CALCITE-3998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106893#comment-17106893 ] TANG Wen-hui edited comment on CALCITE-3998 at 5/14/20, 5:09 AM: - The

[jira] [Commented] (CALCITE-3998) Bad datatype for sum(n), it should be BIGINT but it is sometimes INTEGER

[ https://issues.apache.org/jira/browse/CALCITE-3998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106893#comment-17106893 ] TANG Wen-hui commented on CALCITE-3998: --- The commit

[jira] [Commented] (CALCITE-3998) Bad datatype for sum(n), it should be BIGINT but it is sometimes INTEGER

[ https://issues.apache.org/jira/browse/CALCITE-3998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106848#comment-17106848 ] Feng Zhu commented on CALCITE-3998: --- {quote}I also noted that sometimes the type of sum(N) where N is

[jira] [Commented] (CALCITE-3998) Bad datatype for sum(n), it should be BIGINT but it is sometimes INTEGER

[ https://issues.apache.org/jira/browse/CALCITE-3998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106837#comment-17106837 ] TANG Wen-hui commented on CALCITE-3998: --- I will check whether this issue is related with commit 

[jira] [Commented] (CALCITE-3999) Simplify DialectPool implementation using Guava cache

[ https://issues.apache.org/jira/browse/CALCITE-3999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106808#comment-17106808 ] Jesus Camacho Rodriguez commented on CALCITE-3999: -- I have created a PR in

[jira] [Updated] (CALCITE-3999) Simplify DialectPool implementation using Guava cache

[ https://issues.apache.org/jira/browse/CALCITE-3999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jesus Camacho Rodriguez updated CALCITE-3999: - Summary: Simplify DialectPool implementation using Guava cache (was:

[jira] [Created] (CALCITE-3999) Simplify DialectPool implementation

Jesus Camacho Rodriguez created CALCITE-3999: Summary: Simplify DialectPool implementation Key: CALCITE-3999 URL: https://issues.apache.org/jira/browse/CALCITE-3999 Project: Calcite

[jira] [Commented] (CALCITE-3977) RelDecorrelator does not resolve correlation variable with field accesses

[ https://issues.apache.org/jira/browse/CALCITE-3977?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106701#comment-17106701 ] Stamatis Zampetakis commented on CALCITE-3977: -- I think for a long time the optimizer,

[jira] [Commented] (CALCITE-3994) RexSimplify reduce concat calls with constant arguments

[ https://issues.apache.org/jira/browse/CALCITE-3994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106695#comment-17106695 ] Stamatis Zampetakis commented on CALCITE-3994: -- I agree with [~julianhyde]. I have the

[jira] [Commented] (CALCITE-3979) Simplification might have removed CAST expression(s) incorrectly

[ https://issues.apache.org/jira/browse/CALCITE-3979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106679#comment-17106679 ] Haisheng Yuan commented on CALCITE-3979: No problem, I think we can get it into 1.23.0. >

[jira] [Commented] (CALCITE-3979) Simplification might have removed CAST expression(s) incorrectly

[ https://issues.apache.org/jira/browse/CALCITE-3979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106678#comment-17106678 ] Zoltan Haindrich commented on CALCITE-3979: --- [~hyuan] please consider this for 1.23.0 - it's

[jira] [Commented] (CALCITE-3979) Simplification might have removed CAST expression(s) incorrectly

[ https://issues.apache.org/jira/browse/CALCITE-3979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106670#comment-17106670 ] Zoltan Haindrich commented on CALCITE-3979: --- I see - this logic is org.eigenbase old - so it

[jira] [Commented] (CALCITE-3996) Fix NPE when query syntax is invalid

[ https://issues.apache.org/jira/browse/CALCITE-3996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=1710#comment-1710 ] Laurent Goujon commented on CALCITE-3996: - Can you please provide a more detailed description?

[jira] [Commented] (CALCITE-2997) Avoid pushing down join condition in SqlToRelConverter

[ https://issues.apache.org/jira/browse/CALCITE-2997?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106658#comment-17106658 ] Julian Hyde commented on CALCITE-2997: -- I agree, [~swtalbot]. I have re-opened the issue. It

[jira] [Updated] (CALCITE-3998) Bad datatype for sum(n), it should be BIGINT but it is sometimes INTEGER

[ https://issues.apache.org/jira/browse/CALCITE-3998?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Enrico Olivelli updated CALCITE-3998: - Description: I also noted that sometimes the type of sum(N) where N is an INTEGER

[jira] [Updated] (CALCITE-3993) Add isDefault(), keys(), keyBits() to RelTrait interface

[ https://issues.apache.org/jira/browse/CALCITE-3993?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3993: --- Description: It is an extremely frequent usage to check whether the distribution is

[jira] [Commented] (CALCITE-3993) Add isDefault(), keys(), keyBits() to RelTrait interface

[ https://issues.apache.org/jira/browse/CALCITE-3993?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106632#comment-17106632 ] Haisheng Yuan commented on CALCITE-3993: I mean, in downstream system, not in Calcite, :).

[jira] [Commented] (CALCITE-3993) Add isDefault(), keys(), keyBits() to RelTrait interface

[ https://issues.apache.org/jira/browse/CALCITE-3993?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106628#comment-17106628 ] Xiening Dai commented on CALCITE-3993: -- I understand it's new. You claim it's an extremely

[jira] [Commented] (CALCITE-3993) Add isDefault(), keys(), keyBits() to RelTrait interface

[ https://issues.apache.org/jira/browse/CALCITE-3993?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106623#comment-17106623 ] Haisheng Yuan commented on CALCITE-3993: It just adds the method. I didn't use the API in the

[jira] [Commented] (CALCITE-3993) Add isDefault(), keys(), keyBits() to RelTrait interface

[ https://issues.apache.org/jira/browse/CALCITE-3993?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106620#comment-17106620 ] Xiening Dai commented on CALCITE-3993: -- I don't see the new isDefault() API being used in your PR.

[jira] [Reopened] (CALCITE-3996) Fix NPE when query syntax is invalid

[ https://issues.apache.org/jira/browse/CALCITE-3996?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Kim reopened CALCITE-3996: > Fix NPE when query syntax is invalid > > >

[jira] [Reopened] (CALCITE-2997) Avoid pushing down join condition in SqlToRelConverter

[ https://issues.apache.org/jira/browse/CALCITE-2997?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reopened CALCITE-2997: -- Assignee: Julian Hyde > Avoid pushing down join condition in SqlToRelConverter >

[jira] [Commented] (CALCITE-3979) Simplification might have removed CAST expression(s) incorrectly

[ https://issues.apache.org/jira/browse/CALCITE-3979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106601#comment-17106601 ] Julian Hyde commented on CALCITE-3979: -- bq. do you see any reasons to keep the cast removal logic

[jira] [Commented] (CALCITE-3998) Bad datatype for sum(n), it should be BIGINT but it is sometimes INTEGER

[ https://issues.apache.org/jira/browse/CALCITE-3998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106593#comment-17106593 ] Haisheng Yuan commented on CALCITE-3998: There is a change on the method, no sure it is related

[jira] [Commented] (CALCITE-2997) Avoid pushing down join condition in SqlToRelConverter

[ https://issues.apache.org/jira/browse/CALCITE-2997?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106592#comment-17106592 ] Steven Talbot commented on CALCITE-2997: cc [~julianhyde] I'd move to reopen this. Even if the

[jira] [Commented] (CALCITE-3994) RexSimplify reduce concat calls with constant arguments

[ https://issues.apache.org/jira/browse/CALCITE-3994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106583#comment-17106583 ] Julian Hyde commented on CALCITE-3994: -- Why is this not a job for constant reduction? >

[jira] [Comment Edited] (CALCITE-3998) Bad datatype for sum(n), it should be BIGINT but it is sometimes INTEGER

[ https://issues.apache.org/jira/browse/CALCITE-3998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106576#comment-17106576 ] Julian Hyde edited comment on CALCITE-3998 at 5/13/20, 6:51 PM: Can you

[jira] [Commented] (CALCITE-3998) Bad datatype for sum(n), it should be BIGINT but it is sometimes INTEGER

[ https://issues.apache.org/jira/browse/CALCITE-3998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106576#comment-17106576 ] Julian Hyde commented on CALCITE-3998: -- Can you use {code} or {format} markup and fix the emojis

[jira] [Commented] (CALCITE-3970) Table-valued function TUMBLE uses non-standard syntax

[ https://issues.apache.org/jira/browse/CALCITE-3970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106493#comment-17106493 ] Rui Wang commented on CALCITE-3970: --- While we are continuing discussing, an actionable task is to

[jira] [Comment Edited] (CALCITE-3970) Table-valued function TUMBLE uses non-standard syntax

[ https://issues.apache.org/jira/browse/CALCITE-3970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106470#comment-17106470 ] Rui Wang edited comment on CALCITE-3970 at 5/13/20, 5:10 PM: - >Julian: So,

[jira] [Comment Edited] (CALCITE-3970) Table-valued function TUMBLE uses non-standard syntax

[ https://issues.apache.org/jira/browse/CALCITE-3970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106470#comment-17106470 ] Rui Wang edited comment on CALCITE-3970 at 5/13/20, 5:09 PM: - >Julian: So,

[jira] [Comment Edited] (CALCITE-3970) Table-valued function TUMBLE uses non-standard syntax

[ https://issues.apache.org/jira/browse/CALCITE-3970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106470#comment-17106470 ] Rui Wang edited comment on CALCITE-3970 at 5/13/20, 5:05 PM: - >Julian: So,

[jira] [Comment Edited] (CALCITE-3970) Table-valued function TUMBLE uses non-standard syntax

[ https://issues.apache.org/jira/browse/CALCITE-3970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106470#comment-17106470 ] Rui Wang edited comment on CALCITE-3970 at 5/13/20, 5:04 PM: - >Julian: So,

[jira] [Comment Edited] (CALCITE-3970) Table-valued function TUMBLE uses non-standard syntax

[ https://issues.apache.org/jira/browse/CALCITE-3970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106470#comment-17106470 ] Rui Wang edited comment on CALCITE-3970 at 5/13/20, 5:03 PM: - >Julian: So,

[jira] [Commented] (CALCITE-3970) Table-valued function TUMBLE uses non-standard syntax

[ https://issues.apache.org/jira/browse/CALCITE-3970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106470#comment-17106470 ] Rui Wang commented on CALCITE-3970: --- >Julian: So, how about allowing TABLE as an alternative to

[jira] [Commented] (CALCITE-3997) Problem with MERGE JOIN: java.lang.AssertionError: cannot merge join: left input is not sorted on left keys

[ https://issues.apache.org/jira/browse/CALCITE-3997?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106432#comment-17106432 ] Haisheng Yuan commented on CALCITE-3997: No, maybe CALCITE-3576. The context is

[jira] [Updated] (CALCITE-3576) Remove Enumerable convention check in FilterIntoJoinRule

[ https://issues.apache.org/jira/browse/CALCITE-3576?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3576: --- Description: Context: https://github.com/apache/calcite/pull/1247#discussion_r289489174 >

[jira] [Commented] (CALCITE-3977) RelDecorrelator does not resolve correlation variable with field accesses

[ https://issues.apache.org/jira/browse/CALCITE-3977?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106399#comment-17106399 ] Ruben Q L commented on CALCITE-3977: Looking inside RelDecorrelator code, it seems that this use

[jira] [Commented] (CALCITE-3997) Problem with MERGE JOIN: java.lang.AssertionError: cannot merge join: left input is not sorted on left keys

[ https://issues.apache.org/jira/browse/CALCITE-3997?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106372#comment-17106372 ] Enrico Olivelli commented on CALCITE-3997: -- can be issue related to CALCITE-3982 ? > Problem

[jira] [Created] (CALCITE-3998) Bad datatype for sum(n), it should be BIGINT but it is sometimes INTEGER

Enrico Olivelli created CALCITE-3998: Summary: Bad datatype for sum(n), it should be BIGINT but it is sometimes INTEGER Key: CALCITE-3998 URL: https://issues.apache.org/jira/browse/CALCITE-3998

[jira] [Created] (CALCITE-3997) Problem with MERGE JOIN: java.lang.AssertionError: cannot merge join: left input is not sorted on left keys

Enrico Olivelli created CALCITE-3997: Summary: Problem with MERGE JOIN: java.lang.AssertionError: cannot merge join: left input is not sorted on left keys Key: CALCITE-3997 URL:

[jira] [Commented] (CALCITE-3505) Infinite matching of FilterProjectTransposeRule causes stackoverflow

[ https://issues.apache.org/jira/browse/CALCITE-3505?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106227#comment-17106227 ] Jiatao Tao commented on CALCITE-3505: - "I strongly think we should resolve the infinite rule

[jira] [Commented] (CALCITE-3994) RexSimplify reduce concat calls with constant arguments

[ https://issues.apache.org/jira/browse/CALCITE-3994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106175#comment-17106175 ] Stamatis Zampetakis commented on CALCITE-3994: -- Can you explain a bit more what's the

[jira] [Commented] (CALCITE-3970) Table-valued function TUMBLE uses non-standard syntax

[ https://issues.apache.org/jira/browse/CALCITE-3970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106167#comment-17106167 ] Danny Chen commented on CALCITE-3970: - [~julianhyde] Another question is for query {code:sql}