[jira] [Commented] (CALCITE-883) Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16798667#comment-16798667 ] Hongze Zhang commented on CALCITE-883: -- {quote}causing some "if ...else..." and it seems

[jira] [Issue Comment Deleted] (CALCITE-883) Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang updated CALCITE-883: - Comment: was deleted (was: {quote}with my understanding the first operand of RexOver may become

[jira] [Comment Edited] (CALCITE-883) Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16798656#comment-16798656 ] Hongze Zhang edited comment on CALCITE-883 at 3/22/19 3:05 AM: --- [~Chunwei

[jira] [Commented] (CALCITE-2712) Add rule to remove null-generating side of a Join

[ https://issues.apache.org/jira/browse/CALCITE-2712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16798660#comment-16798660 ] Chunwei Lei commented on CALCITE-2712: -- [~julianhyde] Can I take this one? > Add rule to remove

[jira] [Commented] (CALCITE-883) Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16798657#comment-16798657 ] Hongze Zhang commented on CALCITE-883: -- {quote}with my understanding the first operand of RexOver

[jira] [Commented] (CALCITE-883) Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16798656#comment-16798656 ] Hongze Zhang commented on CALCITE-883: -- [~Chunwei Lei] - IMHO the case seems to be good enough

[jira] [Closed] (CALCITE-2896) RelBuilder supports creating TableFunctionScan

[ https://issues.apache.org/jira/browse/CALCITE-2896?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei closed CALCITE-2896. Resolution: Duplicate > RelBuilder supports creating TableFunctionScan >

[jira] [Updated] (CALCITE-2729) Introducing WindowReduceExpressionRule

[ https://issues.apache.org/jira/browse/CALCITE-2729?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei updated CALCITE-2729: - Summary: Introducing WindowReduceExpressionRule (was: Introducing WindowExpressionRules) >

[jira] [Created] (CALCITE-2944) Lack of test for Aggregate.indicator

Haisheng Yuan created CALCITE-2944: -- Summary: Lack of test for Aggregate.indicator Key: CALCITE-2944 URL: https://issues.apache.org/jira/browse/CALCITE-2944 Project: Calcite Issue Type:

[jira] [Issue Comment Deleted] (CALCITE-896) Remove Aggregate if grouping columns are unique and all functions are splittable

[ https://issues.apache.org/jira/browse/CALCITE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-896: -- Comment: was deleted (was: It seems like the patch in this PR triggered a bug in rule

[jira] [Commented] (CALCITE-2935) Support ANY, SOME, EVERY (also known as BOOL_OR, BOOL_AND) aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-2935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16798539#comment-16798539 ] Haisheng Yuan commented on CALCITE-2935: Agree, things get much easier to define BOOL_OR and

[jira] [Updated] (CALCITE-2903) Exception thrown when decorrelating query with TEMPORAL TABLE

[ https://issues.apache.org/jira/browse/CALCITE-2903?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-2903: --- Summary: Exception thrown when decorrelating query with TEMPORAL TABLE (was: Exception

[jira] [Updated] (CALCITE-2943) Materialized view rewriting logic calls getApplicableMaterializations each time the rule is triggered

[ https://issues.apache.org/jira/browse/CALCITE-2943?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-2943: Labels: pull-request-available (was: ) > Materialized view rewriting logic calls

[jira] [Created] (CALCITE-2943) Materialized view rewriting logic calls getApplicableMaterializations each time the rule is triggered

Jesus Camacho Rodriguez created CALCITE-2943: Summary: Materialized view rewriting logic calls getApplicableMaterializations each time the rule is triggered Key: CALCITE-2943 URL:

[jira] [Commented] (CALCITE-2935) Support ANY, SOME, EVERY (also known as BOOL_OR, BOOL_AND) aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-2935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16798460#comment-16798460 ] Julian Hyde commented on CALCITE-2935: -- Thanks for the review. It seems that {{BOOL_AND}},

[jira] [Commented] (CALCITE-2936) Simplify EXISTS or NOT EXISTS sub-query that has "GROUP BY ()"

[ https://issues.apache.org/jira/browse/CALCITE-2936?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16798331#comment-16798331 ] Julian Hyde commented on CALCITE-2936: -- Yeah, I agree it's a bit weird to use metaData during

[jira] [Commented] (CALCITE-2941) EnumerableLimitRule on Sort with no collation creates EnumerableLimit with wrong traitSet and cluster

[ https://issues.apache.org/jira/browse/CALCITE-2941?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16798320#comment-16798320 ] Julian Hyde commented on CALCITE-2941: -- Looks good (I'm glad that you switched to using the

[jira] [Updated] (CALCITE-2941) EnumerableLimitRule on Sort with no collation creates EnumerableLimit with wrong traitSet and cluster

[ https://issues.apache.org/jira/browse/CALCITE-2941?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-2941: - Fix Version/s: 1.20.0 > EnumerableLimitRule on Sort with no collation creates EnumerableLimit

[jira] [Assigned] (CALCITE-2942) Materialized view rewriting logic instantiates RelMetadataQuery each time the rule is triggered

[ https://issues.apache.org/jira/browse/CALCITE-2942?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jesus Camacho Rodriguez reassigned CALCITE-2942: Assignee: Jesus Camacho Rodriguez > Materialized view rewriting

[jira] [Updated] (CALCITE-2942) Materialized view rewriting logic instantiates RelMetadataQuery each time the rule is triggered

[ https://issues.apache.org/jira/browse/CALCITE-2942?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jesus Camacho Rodriguez updated CALCITE-2942: - Priority: Minor (was: Major) > Materialized view rewriting logic

[jira] [Updated] (CALCITE-2942) Materialized view rewriting logic instantiates RelMetadataQuery each time the rule is triggered

[ https://issues.apache.org/jira/browse/CALCITE-2942?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-2942: Labels: pull-request-available (was: ) > Materialized view rewriting logic instantiates

[jira] [Created] (CALCITE-2942) Materialized view rewriting logic instantiates RelMetadataQuery each time the rule is triggered

Jesus Camacho Rodriguez created CALCITE-2942: Summary: Materialized view rewriting logic instantiates RelMetadataQuery each time the rule is triggered Key: CALCITE-2942 URL:

[jira] [Commented] (CALCITE-2939) NPE Array Type serialToJdbc in TypedValue when executeBatch

[ https://issues.apache.org/jira/browse/CALCITE-2939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16798176#comment-16798176 ] Danny Chan commented on CALCITE-2939: - [~shining] Hi, i would like to take this issue if you agree,

[jira] [Comment Edited] (CALCITE-2937) Linq4j: implement LazyEnumerable

[ https://issues.apache.org/jira/browse/CALCITE-2937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16798113#comment-16798113 ] Ruben Quesada Lopez edited comment on CALCITE-2937 at 3/21/19 1:54 PM:

[jira] [Commented] (CALCITE-2937) Linq4j: implement LazyEnumerable

[ https://issues.apache.org/jira/browse/CALCITE-2937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16798113#comment-16798113 ] Ruben Quesada Lopez commented on CALCITE-2937: -- [~julianhyde], I agree that we can

[jira] [Commented] (CALCITE-883) RESPECT NULLS, IGNORE NULLS option for LEAD, LAG window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16798058#comment-16798058 ] Chunwei Lei commented on CALCITE-883: - Maybe I should say SqlOverOperator instead of RexOver. Let's

[jira] [Updated] (CALCITE-2208) MaterializedViewTable.MATERIALIZATION_CONNECTION breaks lex and case sensitivity for end user

[ https://issues.apache.org/jira/browse/CALCITE-2208?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-2208: Labels: pull-request-available (was: ) >

[jira] [Comment Edited] (CALCITE-2208) MaterializedViewTable.MATERIALIZATION_CONNECTION breaks lex and case sensitivity for end user

[ https://issues.apache.org/jira/browse/CALCITE-2208?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16798023#comment-16798023 ] Lai Zhou edited comment on CALCITE-2208 at 3/21/19 11:59 AM: -  I make a pr

[jira] [Updated] (CALCITE-2844) Babel parser should parse PostgreSQL table functions

[ https://issues.apache.org/jira/browse/CALCITE-2844?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Muhammad Gelbana updated CALCITE-2844: -- Fix Version/s: (was: 1.20.0) > Babel parser should parse PostgreSQL table

[jira] [Commented] (CALCITE-2208) MaterializedViewTable.MATERIALIZATION_CONNECTION breaks lex and case sensitivity for end user

[ https://issues.apache.org/jira/browse/CALCITE-2208?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16798023#comment-16798023 ] Lai Zhou commented on CALCITE-2208: --- [~julianhyde], I make a pr for this issue，the changes： 1.

[jira] [Updated] (CALCITE-2941) EnumerableLimitRule on Sort with no collation creates EnumerableLimit with wrong traitSet and cluster

[ https://issues.apache.org/jira/browse/CALCITE-2941?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Quesada Lopez updated CALCITE-2941: - Affects Version/s: 1.18.0 > EnumerableLimitRule on Sort with no collation

[jira] [Updated] (CALCITE-2941) EnumerableLimitRule on Sort with no collation creates EnumerableLimit with wrong traitSet and cluster

[ https://issues.apache.org/jira/browse/CALCITE-2941?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-2941: Labels: pull-request-available (was: ) > EnumerableLimitRule on Sort with no collation

[jira] [Updated] (CALCITE-2941) EnumerableLimitRule on Sort with no collation creates EnumerableLimit with wrong traitSet and cluster

[ https://issues.apache.org/jira/browse/CALCITE-2941?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Quesada Lopez updated CALCITE-2941: - Description: EnumerableLimitRule _"converst a Sort that has offset or fetch

[jira] [Updated] (CALCITE-2941) EnumerableLimitRule on Sort with no collation creates EnumerableLimit with wrong traitSet and cluster

[ https://issues.apache.org/jira/browse/CALCITE-2941?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Quesada Lopez updated CALCITE-2941: - Description: EnumerableLimitRule _"converst a Sort that has offset or fetch

[jira] [Updated] (CALCITE-2941) EnumerableLimitRule on Sort with no collation creates EnumerableLimit with wrong traitSet and cluster

[ https://issues.apache.org/jira/browse/CALCITE-2941?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Quesada Lopez updated CALCITE-2941: - Description: EnumerableLimitRule _"converst a Sort that has offset or fetch

[jira] [Updated] (CALCITE-2941) EnumerableLimitRule on Sort with no collation creates EnumerableLimit with wrong traitSet and cluster

[ https://issues.apache.org/jira/browse/CALCITE-2941?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Quesada Lopez updated CALCITE-2941: - Description: EnumerableLimitRule "converst a Sort that has offset or fetch set

[jira] [Assigned] (CALCITE-2941) EnumerableLimitRule on Sort with no collation creates EnumerableLimit with wrong traitSet and cluster

[ https://issues.apache.org/jira/browse/CALCITE-2941?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Quesada Lopez reassigned CALCITE-2941: Assignee: Ruben Quesada Lopez > EnumerableLimitRule on Sort with no

[jira] [Created] (CALCITE-2941) EnumerableLimitRule on Sort with no collation creates EnumerableLimit with wrong traitSet and cluster

Ruben Quesada Lopez created CALCITE-2941: Summary: EnumerableLimitRule on Sort with no collation creates EnumerableLimit with wrong traitSet and cluster Key: CALCITE-2941 URL:

[jira] [Comment Edited] (CALCITE-883) RESPECT NULLS, IGNORE NULLS option for LEAD, LAG window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16797938#comment-16797938 ] Hongze Zhang edited comment on CALCITE-883 at 3/21/19 9:46 AM: --- {quote}

[jira] [Commented] (CALCITE-883) RESPECT NULLS, IGNORE NULLS option for LEAD, LAG window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16797938#comment-16797938 ] Hongze Zhang commented on CALCITE-883: -- {quote} with my understanding the first operand of RexOver

[jira] [Commented] (CALCITE-883) RESPECT NULLS, IGNORE NULLS option for LEAD, LAG window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16797921#comment-16797921 ] Chunwei Lei commented on CALCITE-883: - [~zhztheplayer] I really appreciate your patient analysis.

[jira] [Commented] (CALCITE-2928) Make UDF lookup default to case insensitive

[ https://issues.apache.org/jira/browse/CALCITE-2928?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16797911#comment-16797911 ] Julian Hyde commented on CALCITE-2928: -- I somewhat agree. Quite a few Oracle users (especially

[jira] [Closed] (CALCITE-2940) CalcitePrepareImpl always creates a default SqlParser without user's CalciteConnectionConfig

[ https://issues.apache.org/jira/browse/CALCITE-2940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou closed CALCITE-2940. - Resolution: Duplicate > CalcitePrepareImpl always creates a default SqlParser without user's >

[jira] [Updated] (CALCITE-2940) CalcitePrepareImpl always creates a default SqlParser without user's CalciteConnectionConfig

[ https://issues.apache.org/jira/browse/CALCITE-2940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2940: -- Description: CalcitePrepareImpl 's method {code:java} private ParseResult parse_(Context context,

[jira] [Created] (CALCITE-2940) CalcitePrepareImpl always creates a default SqlParser without user's CalciteConnectionConfig

Lai Zhou created CALCITE-2940: - Summary: CalcitePrepareImpl always creates a default SqlParser without user's CalciteConnectionConfig Key: CALCITE-2940 URL: https://issues.apache.org/jira/browse/CALCITE-2940

[jira] [Comment Edited] (CALCITE-2939) NPE Array Type serialToJdbc in TypedValue when executeBatch

[ https://issues.apache.org/jira/browse/CALCITE-2939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16797861#comment-16797861 ] shining edited comment on CALCITE-2939 at 3/21/19 6:21 AM: --- I view the code

[jira] [Commented] (CALCITE-2939) NPE Array Type serialToJdbc in TypedValue when executeBatch

[ https://issues.apache.org/jira/browse/CALCITE-2939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16797861#comment-16797861 ] shining commented on CALCITE-2939: -- I view the code of protoToJdbc method in TypedValue.java:

[jira] [Created] (CALCITE-2939) NPE Array Type serialToJdbc in TypedValue when executeBatch

shining created CALCITE-2939: Summary: NPE Array Type serialToJdbc in TypedValue when executeBatch Key: CALCITE-2939 URL: https://issues.apache.org/jira/browse/CALCITE-2939 Project: Calcite