[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&focusedCommentId=16798667#comment-16798667 ] Hongze Zhang commented on CALCITE-883: -- {quote}causing some "if ...else..." and it

[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&focusedCommentId=16798656#comment-16798656 ] Hongze Zhang edited comment on CALCITE-883 at 3/22/19 3:05 AM: ---

[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&focusedCommentId=16798660#comment-16798660 ] Chunwei Lei commented on CALCITE-2712: -- [~julianhyde] Can I take this one? > Add

[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&focusedCommentId=16798657#comment-16798657 ] Hongze Zhang commented on CALCITE-883: -- {quote}with my understanding the first oper

[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&focusedCommentId=16798656#comment-16798656 ] Hongze Zhang commented on CALCITE-883: -- [~Chunwei Lei] - IMHO the case seems to be

[jira] [Updated] (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 ] Chunwei Lei updated CALCITE-883: Summary: Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE window

[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) > In

[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: Impr

[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 matching

[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&focusedCommentId=16798539#comment-16798539 ] Haisheng Yuan commented on CALCITE-2935: Agree, things get much easier to defin

[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 thr

[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 getAppl

[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: https://issues.apache

[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&focusedCommentId=16798460#comment-16798460 ] Julian Hyde commented on CALCITE-2935: -- Thanks for the review. It seems that {{BOO

[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&focusedCommentId=16798331#comment-16798331 ] Julian Hyde commented on CALCITE-2936: -- Yeah, I agree it's a bit weird to use meta

[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&focusedCommentId=16798320#comment-16798320 ] Julian Hyde commented on CALCITE-2941: -- Looks good (I'm glad that you switched to

[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 w

[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 insta

[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: https://issues.apache.org/j

[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&focusedCommentId=16798176#comment-16798176 ] Danny Chan commented on CALCITE-2939: - [~shining] Hi, i would like to take this iss

[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&focusedCommentId=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&focusedCommentId=16798113#comment-16798113 ] Ruben Quesada Lopez commented on CALCITE-2937: -- [~julianhyde], I agree tha

[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&focusedCommentId=16798058#comment-16798058 ] Chunwei Lei commented on CALCITE-883: - Maybe I should say SqlOverOperator instead of

[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: ) > MaterializedViewTable.MATERIALIZATION_CONNECTIO

[jira] [Issue Comment Deleted] (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 ] Lai Zhou updated CALCITE-2208: -- Comment: was deleted (was:  I make a pr for this issue，the changes： 1. Schemas now uses the config o

[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&focusedCommentId=16798023#comment-16798023 ] Lai Zhou edited comment on CALCITE-2208 at 3/21/19 11:59 AM:

[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 functio

[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&focusedCommentId=16798023#comment-16798023 ] Lai Zhou commented on CALCITE-2208: --- [~julianhyde], I make a pr for this issue，the ch

[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 creat

[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 c

[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] [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] [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] [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] [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: tbd (was: EnumerableLimitRule on Sort with no collation creates E

[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 coll

[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: https://issues.apache.org/jir

[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&focusedCommentId=16797938#comment-16797938 ] Hongze Zhang edited comment on CALCITE-883 at 3/21/19 9:46 AM: ---

[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&focusedCommentId=16797938#comment-16797938 ] Hongze Zhang commented on CALCITE-883: -- {quote} with my understanding the first ope

[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&focusedCommentId=16797921#comment-16797921 ] Chunwei Lei commented on CALCITE-883: - [~zhztheplayer] I really appreciate your pati

[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&focusedCommentId=16797911#comment-16797911 ] Julian Hyde commented on CALCITE-2928: -- I somewhat agree. Quite a few Oracle users

[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 > Calcite

[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, Str

[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