[jira] [Closed] (CALCITE-2599) Support ASCII(string) in SqlFunctions

[ https://issues.apache.org/jira/browse/CALCITE-2599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei closed CALCITE-2599. > Support ASCII(string) in SqlFunctions > - > >

[jira] [Assigned] (CALCITE-2599) Support ASCII(string) in SqlFunctions

[ https://issues.apache.org/jira/browse/CALCITE-2599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei reassigned CALCITE-2599: Assignee: Chunwei Lei > Support ASCII(string) in SqlFunctions >

[jira] [Closed] (CALCITE-2895) Some arguments are undocumented in constructor of LogicalAggregate

[ https://issues.apache.org/jira/browse/CALCITE-2895?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei closed CALCITE-2895. > Some arguments are undocumented in constructor of LogicalAggregate >

[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=16797825#comment-16797825 ] Hongze Zhang edited comment on CALCITE-883 at 3/21/19 5:12 AM: --- Thank you

[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=16797825#comment-16797825 ] Hongze Zhang commented on CALCITE-883: -- Thank you for starting the discussion here, [~Chunwei Lei]

[jira] [Commented] (CALCITE-1299) Reference type of Pulled Up Predicates is not handled properly

[ https://issues.apache.org/jira/browse/CALCITE-1299?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16797816#comment-16797816 ] Chunwei Lei commented on CALCITE-1299: -- I test it in the latest version and it looks like it is

[jira] [Assigned] (CALCITE-2729) Introducing WindowExpressionRules

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

[jira] [Assigned] (CALCITE-2895) Some arguments are undocumented in constructor of LogicalAggregate

[ https://issues.apache.org/jira/browse/CALCITE-2895?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei reassigned CALCITE-2895: Assignee: Chunwei Lei > Some arguments are undocumented in constructor of

[jira] [Assigned] (CALCITE-2908) Add LAST_DAY function

[ https://issues.apache.org/jira/browse/CALCITE-2908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei reassigned CALCITE-2908: Assignee: Chunwei Lei > Add LAST_DAY function > - > >

[jira] [Assigned] (CALCITE-2658) Introducing more ReduceExpressionRules

[ https://issues.apache.org/jira/browse/CALCITE-2658?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei reassigned CALCITE-2658: Assignee: Chunwei Lei (was: Julian Hyde) > Introducing more ReduceExpressionRules >

[jira] [Assigned] (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:all-tabpanel ] Chunwei Lei reassigned CALCITE-883: --- Assignee: Chunwei Lei (was: Sean Hsuan-Yi Chu) > RESPECT NULLS, IGNORE NULLS option for

[jira] [Assigned] (CALCITE-1515) Support TableFunctionScan in RelBuilder

[ https://issues.apache.org/jira/browse/CALCITE-1515?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei reassigned CALCITE-1515: Assignee: Chunwei Lei > Support TableFunctionScan in RelBuilder >

[jira] [Commented] (CALCITE-1515) Support TableFunctionScan in RelBuilder

[ https://issues.apache.org/jira/browse/CALCITE-1515?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16797776#comment-16797776 ] Chunwei Lei commented on CALCITE-1515: -- [~julianhyde] Since you reviewed the PR and left some

[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=16797760#comment-16797760 ] Danny Chan commented on CALCITE-2928: - [~julianhyde] Yes, thx for your rely. I think there are 2

[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=16797756#comment-16797756 ] Chunwei Lei edited comment on CALCITE-883 at 3/21/19 2:52 AM: -- I am sorry

[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=16797756#comment-16797756 ] Chunwei Lei commented on CALCITE-883: - I am sorry that I don't mention the conflict in the PR. It is

[jira] [Updated] (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:all-tabpanel ] ASF GitHub Bot updated CALCITE-2936: Labels: pull-request-available (was: ) > Simplify EXISTS or NOT EXISTS sub-query that

[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=16797659#comment-16797659 ] Haisheng Yuan commented on CALCITE-2936: Revoke my previous statement. We can use

[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=16797653#comment-16797653 ] Haisheng Yuan commented on CALCITE-2936: In that case, the logical relational node we get from

[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=16797645#comment-16797645 ] Haisheng Yuan commented on CALCITE-2935: Yes, makes sense. Unfortunately, there is no

[jira] [Commented] (CALCITE-2926) IN operator type validation failure

[ https://issues.apache.org/jira/browse/CALCITE-2926?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16797637#comment-16797637 ] Julian Hyde commented on CALCITE-2926: -- Those queries don't look valid. In each case,

[jira] [Updated] (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:all-tabpanel ] Julian Hyde updated CALCITE-2935: - Summary: Support ANY, SOME, EVERY (also known as BOOL_OR, BOOL_AND) aggregate functions

[jira] [Commented] (CALCITE-2935) Support ANY, SOME, EVERY aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-2935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16797624#comment-16797624 ] Julian Hyde commented on CALCITE-2935: -- SOME, ANY, ALL are already part of SQL, and are

[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=16797623#comment-16797623 ] Julian Hyde commented on CALCITE-2936: -- Consider using the RelMdRowCount statistic for this. If it

[jira] [Updated] (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:all-tabpanel ] Julian Hyde updated CALCITE-2936: - Description: An EXISTS or NOT EXISTS sub-query whose inner child is an aggregate with no

[jira] [Updated] (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:all-tabpanel ] Julian Hyde updated CALCITE-2936: - Summary: Simplify EXISTS or NOT EXISTS sub-query that has "GROUP BY ()" (was: Existential

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

[ https://issues.apache.org/jira/browse/CALCITE-2937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16797475#comment-16797475 ] Andrei Sereda commented on CALCITE-2937: This makes sense. Do you think we still need

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

[ https://issues.apache.org/jira/browse/CALCITE-2937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16797467#comment-16797467 ] Julian Hyde commented on CALCITE-2937: -- An {{Enumerable}} is basically a supplier of an

[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=16797439#comment-16797439 ] Julian Hyde commented on CALCITE-883: - I see the latest PR has 67 files changed. Changes that large

[jira] [Updated] (CALCITE-2843) Babel parser should parse PostgreSQL-style '::' cast operator

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

[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: 1.20.0 > Babel parser should parse PostgreSQL table functions >

[jira] [Comment Edited] (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=16797394#comment-16797394 ] Julian Hyde edited comment on CALCITE-2928 at 3/20/19 6:00 PM: --- So,

[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=16797394#comment-16797394 ] Julian Hyde commented on CALCITE-2928: -- So, you're saying that Oracle uses the same

[jira] [Commented] (CALCITE-2911) Release Calcite 1.19.0

[ https://issues.apache.org/jira/browse/CALCITE-2911?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16797256#comment-16797256 ] Kevin Risden commented on CALCITE-2911: --- Blockers have been resolved after RC1. Starting RC2 >

[jira] [Resolved] (CALCITE-2929) Simplification of IS NULL checks are incorrectly assuming that CAST-s are possible

[ https://issues.apache.org/jira/browse/CALCITE-2929?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Risden resolved CALCITE-2929. --- Resolution: Fixed merged in commit a648f9c12309cc253628930b0cab98591caa66ab >

[jira] [Updated] (CALCITE-2930) FilterCorrelateRule on a Correlate with SemiJoinType SEMI (or ANTI) throws IllegalStateException

[ https://issues.apache.org/jira/browse/CALCITE-2930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Risden updated CALCITE-2930: -- Fix Version/s: (was: 1.19.0) 1.20.0 > FilterCorrelateRule on a

[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=16797176#comment-16797176 ] Kevin Risden commented on CALCITE-2928: --- Updated fix version to 1.20.0 since this was created

[jira] [Commented] (CALCITE-2930) FilterCorrelateRule on a Correlate with SemiJoinType SEMI (or ANTI) throws IllegalStateException

[ https://issues.apache.org/jira/browse/CALCITE-2930?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16797179#comment-16797179 ] Kevin Risden commented on CALCITE-2930: --- Updated fix version to 1.20.0 since this was created

[jira] [Updated] (CALCITE-2930) FilterCorrelateRule on a Correlate with SemiJoinType SEMI (or ANTI) throws IllegalStateException

[ https://issues.apache.org/jira/browse/CALCITE-2930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Risden updated CALCITE-2930: -- Affects Version/s: 1.19.0 > FilterCorrelateRule on a Correlate with SemiJoinType SEMI (or

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

[ https://issues.apache.org/jira/browse/CALCITE-2928?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Risden updated CALCITE-2928: -- Fix Version/s: (was: 1.19.0) 1.20.0 > Make UDF lookup default to case

[jira] [Commented] (CALCITE-2933) In Druid adapter, expression like "cast(cast(\"timestamp\" as timestamp) as varchar)" returns as epoch millisecond

[ https://issues.apache.org/jira/browse/CALCITE-2933?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16797138#comment-16797138 ] Danny Chan commented on CALCITE-2933: - [~zhztheplayer] I have found the reason, it is because in

[jira] [Created] (CALCITE-2938) Druid adapter do wrong behavior for casts from timestamp type to date type

Danny Chan created CALCITE-2938: --- Summary: Druid adapter do wrong behavior for casts from timestamp type to date type Key: CALCITE-2938 URL: https://issues.apache.org/jira/browse/CALCITE-2938 Project:

[jira] [Updated] (CALCITE-2933) In Druid adapter, expression like "cast(cast(\"timestamp\" as timestamp) as varchar)" returns as epoch millisecond

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

[jira] [Commented] (CALCITE-2933) In Druid adapter, expression like "cast(cast(\"timestamp\" as timestamp) as varchar)" returns as epoch millisecond

[ https://issues.apache.org/jira/browse/CALCITE-2933?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16796937#comment-16796937 ] Hongze Zhang commented on CALCITE-2933: --- [~danny0405] - This seems like that the Druid

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

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

[jira] [Commented] (CALCITE-2933) In Druid adapter, expression like "cast(cast(\"timestamp\" as timestamp) as varchar)" returns as epoch millisecond

[ https://issues.apache.org/jira/browse/CALCITE-2933?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16796923#comment-16796923 ] Danny Chan commented on CALCITE-2933: - [~zhztheplayer] Sorry, my fault, all my test cases throw

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

[ https://issues.apache.org/jira/browse/CALCITE-2937?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Quesada Lopez reassigned CALCITE-2937: Assignee: Ruben Quesada Lopez > Linq4j: implement LazyEnumerable >

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

[ https://issues.apache.org/jira/browse/CALCITE-2937?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Quesada Lopez updated CALCITE-2937: - Description: Implement a LazyEnumerable: an Enumerable whose computation (via

[jira] [Commented] (CALCITE-2933) In Druid adapter, expression like "cast(cast(\"timestamp\" as timestamp) as varchar)" returns as epoch millisecond

[ https://issues.apache.org/jira/browse/CALCITE-2933?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16796912#comment-16796912 ] Danny Chan commented on CALCITE-2933: - [~zhztheplayer] It seems that the error does not has any

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

Ruben Quesada Lopez created CALCITE-2937: Summary: Linq4j: implement LazyEnumerable Key: CALCITE-2937 URL: https://issues.apache.org/jira/browse/CALCITE-2937 Project: Calcite Issue

[jira] [Updated] (CALCITE-2936) Existential subquery that has aggregate without grouping key should be simplified

[ https://issues.apache.org/jira/browse/CALCITE-2936?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-2936: --- Description: An existential subquery whose inner child is an aggregate with no grouping

[jira] [Created] (CALCITE-2936) Existential subquery that has aggregate without grouping key should be simplified

Haisheng Yuan created CALCITE-2936: -- Summary: Existential subquery that has aggregate without grouping key should be simplified Key: CALCITE-2936 URL: https://issues.apache.org/jira/browse/CALCITE-2936