[jira] [Comment Edited] (CALCITE-3368) Some problems about expression is null simplification

2019-09-29 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16940255#comment-16940255 ] Danny Chen edited comment on CALCITE-3368 at 9/29/19 6:32 AM: -- I tried

[jira] [Comment Edited] (CALCITE-3368) Some problems about expression is null simplification

2019-09-29 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16940255#comment-16940255 ] Danny Chen edited comment on CALCITE-3368 at 9/29/19 6:14 AM: -- I tried

[jira] [Updated] (CALCITE-3368) Some problems about expression is null simplification

2019-09-29 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3368: Summary: Some problems about expression is null simplification (was: 'is null' expression in

[jira] [Commented] (CALCITE-3368) 'is null' expression in SQL may be optimized incorrectly in the underlying implementation

2019-09-29 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16940255#comment-16940255 ] Danny Chen commented on CALCITE-3368: - I tried this test case in SqlToRelConverterTest: {code:java}

[jira] [Commented] (CALCITE-3376) VolcanoPlanner CannotPlanException: best rel is null even though there is an option with non-infinite cost

2019-09-27 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3376?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16939547#comment-16939547 ] Danny Chen commented on CALCITE-3376: - [~rubenql] Did you try CALCITE-2018 ? It fix some cases of

[jira] [Created] (CALCITE-3379) Support expand atom expression in table to relational node conversion

2019-09-29 Thread Danny Chen (Jira)
Danny Chen created CALCITE-3379: --- Summary: Support expand atom expression in table to relational node conversion Key: CALCITE-3379 URL: https://issues.apache.org/jira/browse/CALCITE-3379 Project:

[jira] [Commented] (CALCITE-3358) Make Function DDLs implement SqlExecutableStatement

2019-10-07 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3358?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16946417#comment-16946417 ] Danny Chen commented on CALCITE-3358: - Not able to, seems you do not have the JIRA contribution

[jira] [Updated] (CALCITE-3379) Support expand STRING column expression in table during sql-to-rel conversion

2019-10-07 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3379?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3379: Summary: Support expand STRING column expression in table during sql-to-rel conversion (was:

[jira] [Updated] (CALCITE-3379) Support expand atom expression in table to relational node conversion

2019-10-07 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3379?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3379: Description: Now there are 2 ways to convert a RelOptTable to LogicalTableScan: 1. One way is

[jira] [Comment Edited] (CALCITE-3379) Support expand STRING column expression in table during sql-to-rel conversion

2019-10-07 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16946450#comment-16946450 ] Danny Chen edited comment on CALCITE-3379 at 10/8/19 3:37 AM: --

[jira] [Commented] (CALCITE-3388) StackOverflowError for creating structured RelDataType from class type

2019-10-07 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3388?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16946397#comment-16946397 ] Danny Chen commented on CALCITE-3388: - How could a type reference itself ? {code:java} private

[jira] [Commented] (CALCITE-3368) Some problems simplifying ‘expression IS NULL’

2019-10-07 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16946421#comment-16946421 ] Danny Chen commented on CALCITE-3368: - [~kgyrtkirk] Can you please take a look on this issue ? >

[jira] [Commented] (CALCITE-3379) Support expand STRING column expression in table during sql-to-rel conversion

2019-10-07 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16946450#comment-16946450 ] Danny Chen commented on CALCITE-3379: - [~julianhyde] [~hyuan],yes, the linked PR is not relevant

[jira] [Commented] (CALCITE-3379) Support expand STRING column expression in table during sql-to-rel conversion

2019-10-09 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16948187#comment-16948187 ] Danny Chen commented on CALCITE-3379: - Yes, column expression need to be validated, this is

[jira] [Commented] (CALCITE-3394) Can not register implementation of a UDF with RexImpTable and use the same with RelBuilder

2019-10-09 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3394?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16948122#comment-16948122 ] Danny Chen commented on CALCITE-3394: - [~vaishnavee] This is because 

[jira] [Commented] (CALCITE-3395) add BuiltinMethod for Substring(String, int)

2019-10-09 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16948127#comment-16948127 ] Danny Chen commented on CALCITE-3395: - Calcite support 2 style of subString function: # One is 

[jira] [Resolved] (CALCITE-3392) Column expression in DDL should be validated before converting to RexNode

2019-10-09 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3392?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen resolved CALCITE-3392. - Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-3379) Support expand STRING column expression in table during sql-to-rel conversion

2019-10-10 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16948301#comment-16948301 ] Danny Chen commented on CALCITE-3379: - Finally i decide not to support a pure string column

[jira] [Comment Edited] (CALCITE-3379) Support expand STRING column expression in table during sql-to-rel conversion

2019-10-10 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16948269#comment-16948269 ] Danny Chen edited comment on CALCITE-3379 at 10/10/19 7:19 AM: --- > And

[jira] [Commented] (CALCITE-3379) Support expand STRING column expression in table during sql-to-rel conversion

2019-10-10 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16948269#comment-16948269 ] Danny Chen commented on CALCITE-3379: - > And exception occurs when trying to query the table.

[jira] [Commented] (CALCITE-3379) Support expand STRING column expression in table during sql-to-rel conversion

2019-10-10 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16948295#comment-16948295 ] Danny Chen commented on CALCITE-3379: - Okey, got your idea, personally, i'm inclined to validate

[jira] [Commented] (CALCITE-3368) Some problems simplifying ‘expression IS NULL’

2019-10-11 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16949168#comment-16949168 ] Danny Chen commented on CALCITE-3368: - Personally, i'm + 1 to add a switch for the PLUS/MINUS/TIMES

[jira] [Comment Edited] (CALCITE-3379) Support expand STRING column expression in table during sql-to-rel conversion

2019-10-10 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16948295#comment-16948295 ] Danny Chen edited comment on CALCITE-3379 at 10/11/19 1:43 AM: --- Okey, got

[jira] [Commented] (CALCITE-963) Hoist literals

2019-10-10 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16949073#comment-16949073 ] Danny Chen commented on CALCITE-963: [~ScottReynolds] Sorry to bother, can you explain more about

[jira] [Updated] (CALCITE-3397) AssertionError for interpreter multiset

2019-10-10 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3397?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3397: Component/s: core > AssertionError for interpreter multiset >

[jira] [Resolved] (CALCITE-3397) AssertionError for interpreter multiset

2019-10-10 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3397?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen resolved CALCITE-3397. - Fix Version/s: 1.22.0 Assignee: Danny Chen Resolution: Fixed Fixed in

[jira] [Updated] (CALCITE-3379) Support expand STRING column expression of table during sql-to-rel conversion

2019-10-11 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3379?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3379: Summary: Support expand STRING column expression of table during sql-to-rel conversion (was:

[jira] [Updated] (CALCITE-3368) PLUS, MUNUS and TIMES should be unsafe when simplifying ‘expression IS NULL’

2019-10-11 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3368: Summary: PLUS, MUNUS and TIMES should be unsafe when simplifying ‘expression IS NULL’ (was:

[jira] [Created] (CALCITE-3392) Column expression in DDL should be validated before converting to RexNode

2019-10-09 Thread Danny Chen (Jira)
Danny Chen created CALCITE-3392: --- Summary: Column expression in DDL should be validated before converting to RexNode Key: CALCITE-3392 URL: https://issues.apache.org/jira/browse/CALCITE-3392 Project:

[jira] [Assigned] (CALCITE-3368) Some problems simplifying ‘expression IS NULL’

2019-10-09 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen reassigned CALCITE-3368: --- Assignee: Leonard Xu (was: Danny Chen) > Some problems simplifying ‘expression IS NULL’

[jira] [Commented] (CALCITE-3368) Some problems simplifying ‘expression IS NULL’

2019-10-09 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16947635#comment-16947635 ] Danny Chen commented on CALCITE-3368: - Thanks for taking this issue, [~Leonard Xu] ! > Some

[jira] [Commented] (CALCITE-2221) RelRoot.project does not take into account flattened record type

2019-10-09 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16947598#comment-16947598 ] Danny Chen commented on CALCITE-2221: - Thanks for the reminder [~IhorHuzenko] ! > RelRoot.project

[jira] [Updated] (CALCITE-3404) Treat agg expressions that can ignore distinct constraint as distinct in AggregateExpandDistinctAggregatesRule when all the other agg expressions are distinct and have

2019-10-12 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3404: Summary: Treat agg expressions that can ignore distinct constraint as distinct in

[jira] [Updated] (CALCITE-3404) Treat agg expressions that can ignore distinct constraint as distinct in AggregateExpandDistinctAggregatesRule when all the other agg expressions are distinct and have

2019-10-12 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3404: Description: After CALCITE-3159, the distinct constraint for MAX/MIN/BIT_OR/BIT_AND are removed

[jira] [Resolved] (CALCITE-3217) Support "SELECT NULL"

2019-10-11 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3217?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen resolved CALCITE-3217. - Fix Version/s: 1.21.0 Assignee: Danny Chen Resolution: Duplicate Mark as

[jira] [Commented] (CALCITE-3404) Promote plan for AggregateExpandDistinctAggregatesRule when all the agg expressions are distinct and have same arguments

2019-10-12 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16949924#comment-16949924 ] Danny Chen commented on CALCITE-3404: - Thanks for the feedback Julian, working now ~ > Promote

[jira] [Created] (CALCITE-3404) Promote plan for AggregateExpandDistinctAggregatesRule when all the agg expressions are distinct and have same arguments

2019-10-11 Thread Danny Chen (Jira)
Danny Chen created CALCITE-3404: --- Summary: Promote plan for AggregateExpandDistinctAggregatesRule when all the agg expressions are distinct and have same arguments Key: CALCITE-3404 URL:

[jira] [Updated] (CALCITE-3404) In AggregateExpandDistinctAggregatesRule, treat all the agg expressions as distinct if they have the same arguments and the non-distinct expressions distinct constraint

2019-10-12 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3404: Summary: In AggregateExpandDistinctAggregatesRule, treat all the agg expressions as distinct if

[jira] [Commented] (CALCITE-3404) Treat agg expressions that can ignore distinct constraint as distinct in AggregateExpandDistinctAggregatesRule when all the other agg expressions are distinct and hav

2019-10-12 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16949954#comment-16949954 ] Danny Chen commented on CALCITE-3404: - Julian, i have did some refactoring for the code, hopes it

[jira] [Closed] (CALCITE-3217) Support "SELECT NULL"

2019-10-13 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3217?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen closed CALCITE-3217. --- > Support "SELECT NULL" > - > > Key: CALCITE-3217 >

[jira] [Commented] (CALCITE-3081) Literal NULL should be generated in SqlDialect

2019-10-13 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3081?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16950665#comment-16950665 ] Danny Chen commented on CALCITE-3081: - Hi, [~donnyzone], Calcite has supported "select null" now in

[jira] [Resolved] (CALCITE-3404) In AggregateExpandDistinctAggregatesRule, treat all the agg expressions as distinct if they have the same arguments and the non-distinct expressions distinct constrain

2019-10-13 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen resolved CALCITE-3404. - Resolution: Fixed Fixed in 

[jira] [Closed] (CALCITE-3326) SQL with invalid function throws NullPointerException if typeCoercion is disabled

2019-10-13 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3326?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen closed CALCITE-3326. --- Fix Version/s: 1.22.0 Assignee: Danny Chen Resolution: Fixed Close and duplicated

[jira] [Closed] (CALCITE-2829) Use consistent types when processing ranges

2019-10-13 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2829?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen closed CALCITE-2829. --- Fix Version/s: 1.21.0 Assignee: Danny Chen (was: Juhwan Kim) Resolution: Fixed

[jira] [Created] (CALCITE-3410) Simplify RelOptRulesTest and HepPlannerTest by making test methods fluent

2019-10-14 Thread Danny Chen (Jira)
Danny Chen created CALCITE-3410: --- Summary: Simplify RelOptRulesTest and HepPlannerTest by making test methods fluent Key: CALCITE-3410 URL: https://issues.apache.org/jira/browse/CALCITE-3410 Project:

[jira] [Resolved] (CALCITE-3379) Support expand STRING column expression of table during sql-to-rel conversion

2019-10-11 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3379?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen resolved CALCITE-3379. - Resolution: Fixed Finally i changed my idea and provide a default impl to support string

[jira] [Updated] (CALCITE-3318) Preserving CAST of VARCHAR operand in binary comparison for BigQuery

2019-10-18 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3318?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3318: Summary: Preserving CAST of VARCHAR operand in binary comparison for BigQuery (was: Preserving

[jira] [Resolved] (CALCITE-3390) ITEM expression does not get pushed to the right input of left-outer-join

2019-10-28 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen resolved CALCITE-3390. - Fix Version/s: 1.22.0 Resolution: Fixed Fixed in

[jira] [Updated] (CALCITE-3442) In ElasticSearch adapter, set `stored_fields = _none_` to prohibit FetchPhase get involved

2019-10-28 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3442?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3442: Summary: In ElasticSearch adapter, set `stored_fields = _none_` to prohibit FetchPhase get

[jira] [Commented] (CALCITE-3433) EQUALS operator between date/timestamp types returns false if the type is nullable

2019-10-28 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3433?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16960957#comment-16960957 ] Danny Chen commented on CALCITE-3433: - Thanks [~donnyzone], can we gen code with out {code:java}

[jira] [Comment Edited] (CALCITE-3433) EQUALS operator between date/timestamp types returns false if the type is nullable

2019-10-28 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3433?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16960957#comment-16960957 ] Danny Chen edited comment on CALCITE-3433 at 10/28/19 11:46 AM: Thanks

[jira] [Commented] (CALCITE-3412) FLOOR(timestamp TO WEEK) gives wrong result

2019-10-17 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954213#comment-16954213 ] Danny Chen commented on CALCITE-3412: - Thanks for the fixing, Julian ~ > FLOOR(timestamp TO WEEK)

[jira] [Commented] (CALCITE-2303) In EXTRACT function, support MICROSECONDS, MILLISECONDS, EPOCH, ISODOW, ISOYEAR and DECADE time units

2019-10-17 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2303?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954211#comment-16954211 ] Danny Chen commented on CALCITE-2303: - Thanks for the fixing, Julian ~ > In EXTRACT function,

[jira] [Commented] (CALCITE-3425) Inconsistent behavior of MetadataProvider in RelOptCluster

2019-10-18 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3425?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954388#comment-16954388 ] Danny Chen commented on CALCITE-3425: - Thanks [~hyuan] for firing this issue, let's continue the

[jira] [Updated] (CALCITE-3426) Complement validConstant type in RexLiteral

2019-10-20 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3426?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3426: Summary: Complement validConstant type in RexLiteral (was: compensate validConstant type in

[jira] [Commented] (CALCITE-3414) Unify Expression'type cast and conversion as a robust one

2019-10-20 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16955692#comment-16955692 ] Danny Chen commented on CALCITE-3414: - Reviewing now ~ > Unify Expression'type cast and conversion

[jira] [Updated] (CALCITE-3415) Supports REGEXP_SUBSTR function

2019-10-20 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3415?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3415: Summary: Supports REGEXP_SUBSTR function (was: Cannot parse REGEXP_SUBSTR in BigQuery) >

[jira] [Closed] (CALCITE-3432) RexBuilder construct method with the default of RelDataTypeFactory.

2019-10-20 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3432?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen closed CALCITE-3432. --- Resolution: Won't Do > RexBuilder construct method with the default of RelDataTypeFactory. >

[jira] [Updated] (CALCITE-3414) [CALCITE-3414] In calcite-core, use RexToLixTranslator.convert for type conversion code generation uniformly

2019-10-20 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3414: Summary: [CALCITE-3414] In calcite-core, use RexToLixTranslator.convert for type conversion code

[jira] [Updated] (CALCITE-3414) In calcite-core, use RexToLixTranslator.convert for type conversion code generation uniformly

2019-10-20 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3414: Summary: In calcite-core, use RexToLixTranslator.convert for type conversion code generation

[jira] [Assigned] (CALCITE-3415) Supports REGEXP_SUBSTR function

2019-10-20 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3415?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen reassigned CALCITE-3415: --- Assignee: Danny Chen > Supports REGEXP_SUBSTR function > ---

[jira] [Assigned] (CALCITE-3416) SQL Dialects "DEFAULT"s should be more extensible

2019-10-21 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3416?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen reassigned CALCITE-3416: --- Assignee: Danny Chen > SQL Dialects "DEFAULT"s should be more extensible >

[jira] [Commented] (CALCITE-3293) Add strcmp function

2019-10-21 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16955816#comment-16955816 ] Danny Chen commented on CALCITE-3293: - I found one in the Oracle doc:

[jira] [Resolved] (CALCITE-3318) Preserving CAST of STRING operands in comparison operator

2019-10-18 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3318?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen resolved CALCITE-3318. - Fix Version/s: 1.22.0 Assignee: Danny Chen Resolution: Fixed Fixed in

[jira] [Comment Edited] (CALCITE-3318) Preserving CAST of VARCHAR operand in binary comparison for BigQuery

2019-10-18 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3318?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954453#comment-16954453 ] Danny Chen edited comment on CALCITE-3318 at 10/18/19 11:04 AM: Fixed

[jira] [Commented] (CALCITE-3293) Add strcmp function

2019-10-21 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16955817#comment-16955817 ] Danny Chen commented on CALCITE-3293: - Sorry, my fault, the Oracle one seems with "@" as prefix. >

[jira] [Commented] (CALCITE-3368) PLUS, MUNUS and TIMES should be unsafe when simplifying ‘expression IS NULL’

2019-10-15 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16952471#comment-16952471 ] Danny Chen commented on CALCITE-3368: - I tested these queries in MYSQL 5.6: {code:sql} select

[jira] [Commented] (CALCITE-3415) Cannot parse REGEXP_SUBSTR in BigQuery

2019-10-15 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3415?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16952442#comment-16952442 ] Danny Chen commented on CALCITE-3415: - Thanks [~pranay.parmar] for reporting this, i checked that

[jira] [Comment Edited] (CALCITE-3368) PLUS, MUNUS and TIMES should be unsafe when simplifying ‘expression IS NULL’

2019-10-15 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16952471#comment-16952471 ] Danny Chen edited comment on CALCITE-3368 at 10/16/19 3:19 AM: --- I tested

[jira] [Commented] (CALCITE-1075) UDF Error of Calcite 1.6

2019-10-15 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1075?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16952481#comment-16952481 ] Danny Chen commented on CALCITE-1075: - I think it is because internally Calcite use Long to

[jira] [Commented] (CALCITE-3416) SQL Dialects "DEFAULT"s should be more extensible

2019-10-15 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3416?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16952457#comment-16952457 ] Danny Chen commented on CALCITE-3416: - Well, i think [~swtalbot]'s request is that how to config or

[jira] [Comment Edited] (CALCITE-3368) PLUS, MUNUS and TIMES should be unsafe when simplifying ‘expression IS NULL’

2019-10-15 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16952471#comment-16952471 ] Danny Chen edited comment on CALCITE-3368 at 10/16/19 3:14 AM: --- I tested

[jira] [Commented] (CALCITE-3414) Unify Expression'type cast and conversion as a robust one

2019-10-15 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16952480#comment-16952480 ] Danny Chen commented on CALCITE-3414: - Thanks Julian for clarifying the strategy, then i think keep

[jira] [Commented] (CALCITE-3412) Response Error for FLOOR TIMESTAMP TO WEEK

2019-10-15 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16952489#comment-16952489 ] Danny Chen commented on CALCITE-3412: - I didn't find any engine to support 'FLOOR(... TO XXX)'

[jira] [Assigned] (CALCITE-3415) Cannot parse REGEXP_SUBSTR in BigQuery

2019-10-16 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3415?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen reassigned CALCITE-3415: --- Assignee: (was: Danny Chen) > Cannot parse REGEXP_SUBSTR in BigQuery >

[jira] [Commented] (CALCITE-3415) Cannot parse REGEXP_SUBSTR in BigQuery

2019-10-16 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3415?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16952643#comment-16952643 ] Danny Chen commented on CALCITE-3415: - Sorry for cannot doing that because you have no contrition

[jira] [Assigned] (CALCITE-3415) Cannot parse REGEXP_SUBSTR in BigQuery

2019-10-16 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3415?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen reassigned CALCITE-3415: --- Assignee: Danny Chen > Cannot parse REGEXP_SUBSTR in BigQuery >

[jira] [Commented] (CALCITE-3414) Unify Expression'type cast and conversion as a robust one

2019-10-16 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16952595#comment-16952595 ] Danny Chen commented on CALCITE-3414: - For (1) i think we can make a fix, for (2) could we make

[jira] [Commented] (CALCITE-3416) SQL Dialects "DEFAULT"s should be more extensible

2019-10-16 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3416?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16952594#comment-16952594 ] Danny Chen commented on CALCITE-3416: - Yes, we may need a way to give user a "default" initial

[jira] [Resolved] (CALCITE-3410) Simplify RelOptRulesTest and HepPlannerTest by making test methods fluent

2019-10-14 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3410?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen resolved CALCITE-3410. - Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-3419) Tools for converting List to SQL expression string

2019-10-16 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3419?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16952685#comment-16952685 ] Danny Chen commented on CALCITE-3419: - You can use SqlImplementor#toSql[1] to convert RexNode to

[jira] [Created] (CALCITE-3420) NullPointerException throws for implicit type coercion of nested SET operations

2019-10-16 Thread Danny Chen (Jira)
Danny Chen created CALCITE-3420: --- Summary: NullPointerException throws for implicit type coercion of nested SET operations Key: CALCITE-3420 URL: https://issues.apache.org/jira/browse/CALCITE-3420

[jira] [Commented] (CALCITE-3412) Response Error for FLOOR TIMESTAMP TO WEEK

2019-10-15 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16951666#comment-16951666 ] Danny Chen commented on CALCITE-3412: - I'm curious what is the right start day of a week, Sunday ?

[jira] [Commented] (CALCITE-3402) Allow RANGE with compoud ORDER BY clause

2019-10-22 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16956862#comment-16956862 ] Danny Chen commented on CALCITE-3402: - It's not surprise the cases you gave for RANGE and ROWS

[jira] [Resolved] (CALCITE-3393) RelStructuredTypeFlattener: improve support for functions with struct input

2019-10-22 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen resolved CALCITE-3393. - Fix Version/s: 1.22.0 Resolution: Fixed Fixed in

[jira] [Created] (CALCITE-3446) Make RelMetadataQuery extendible

2019-10-24 Thread Danny Chen (Jira)
Danny Chen created CALCITE-3446: --- Summary: Make RelMetadataQuery extendible Key: CALCITE-3446 URL: https://issues.apache.org/jira/browse/CALCITE-3446 Project: Calcite Issue Type: Improvement

[jira] [Commented] (CALCITE-3443) Doesn't parse PreparedStatement successfully for there are placeholders in select area

2019-10-24 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3443?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16959364#comment-16959364 ] Danny Chen commented on CALCITE-3443: - [~kofiori] You are right, there is already an issue

[jira] [Commented] (CALCITE-3402) Allow RANGE with compoud ORDER BY clause

2019-10-24 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16959365#comment-16959365 ] Danny Chen commented on CALCITE-3402: - [~benj641], do you think we can close this issue now, it

[jira] [Updated] (CALCITE-3446) Make RelMetadataQuery extendible

2019-10-24 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3446: Description: As discussed in the DEV mailing list:

[jira] [Closed] (CALCITE-3402) Allow RANGE with compoud ORDER BY clause

2019-10-25 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3402?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen closed CALCITE-3402. --- Assignee: Danny Chen Resolution: Not A Problem > Allow RANGE with compoud ORDER BY clause >

[jira] [Updated] (CALCITE-3433) EQUALS operator between date/timestamp types returns false if the type is nullable

2019-10-28 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3433?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3433: Description: sql {code:sql} select time0 = time1 from (select timestamp'2000-12-30

[jira] [Resolved] (CALCITE-3442) In ElasticSearch adapter, set `stored_fields = _none_` to prohibit FetchPhase get involved

2019-10-28 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3442?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen resolved CALCITE-3442. - Fix Version/s: (was: next) 1.22.0 Assignee: Danny Chen

[jira] [Commented] (CALCITE-3433) EQUALS operator between date/timestamp types returns false if the type is nullable

2019-10-28 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3433?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16961605#comment-16961605 ] Danny Chen commented on CALCITE-3433: - > Binary operators like Equals/NotEquals/Add are implemented

[jira] [Created] (CALCITE-3456) AssertionError throws when aggregation has non-aggregate calls

2019-10-29 Thread Danny Chen (Jira)
Danny Chen created CALCITE-3456: --- Summary: AssertionError throws when aggregation has non-aggregate calls Key: CALCITE-3456 URL: https://issues.apache.org/jira/browse/CALCITE-3456 Project: Calcite

[jira] [Commented] (CALCITE-3415) Supports REGEXP_SUBSTR function

2019-10-29 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3415?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16962636#comment-16962636 ] Danny Chen commented on CALCITE-3415: - Reviewing now~ > Supports REGEXP_SUBSTR function >

[jira] [Resolved] (CALCITE-3446) Make RelMetadataQuery extensible

2019-10-29 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen resolved CALCITE-3446. - Resolution: Fixed Fixed in

[jira] [Updated] (CALCITE-3456) AssertionError throws when aggregation same digest in subquery in different scope

2019-10-29 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3456?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3456: Summary: AssertionError throws when aggregation same digest in subquery in different scope

[jira] [Commented] (CALCITE-3368) PLUS, MINUS and TIMES should be unsafe when simplifying ‘expression IS NULL’

2019-10-23 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16957811#comment-16957811 ] Danny Chen commented on CALCITE-3368: - I tried these sql: {code:java} create table t( a int, b

[jira] [Resolved] (CALCITE-3424) AssertionError thrown for user-defined table function with array argument

2019-10-23 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3424?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen resolved CALCITE-3424. - Fix Version/s: 1.22.0 Resolution: Fixed Fixed in

[jira] [Created] (CALCITE-3441) Remove SqlTypeExplicitPrecedenceList.COMPACT_NUMERIC_TYPES because the NULL delimiters are useless

2019-10-23 Thread Danny Chen (Jira)
Danny Chen created CALCITE-3441: --- Summary: Remove SqlTypeExplicitPrecedenceList.COMPACT_NUMERIC_TYPES because the NULL delimiters are useless Key: CALCITE-3441 URL:

  1   2   >