[jira] [Assigned] (CALCITE-3605) Semantics of relation operator changed after decorrelated

2019-12-16 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin reassigned CALCITE-3605: Assignee: Wang Yanlin > Semantics of relation operator changed after decorrelated >

[jira] [Created] (CALCITE-3605) Semantics of relation operator changed after decorrelated

2019-12-16 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3605: Summary: Semantics of relation operator changed after decorrelated Key: CALCITE-3605 URL: https://issues.apache.org/jira/browse/CALCITE-3605 Project: Calcite

[jira] [Created] (CALCITE-3596) Sql in annotation of OverScope class has syntax error

2019-12-11 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3596: Summary: Sql in annotation of OverScope class has syntax error Key: CALCITE-3596 URL: https://issues.apache.org/jira/browse/CALCITE-3596 Project: Calcite

[jira] [Commented] (CALCITE-3413) AssertionError for interpertering union/intersect/minus with null value

2019-10-15 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3413?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16951926#comment-16951926 ] Wang Yanlin commented on CALCITE-3413: -- Fix together with 

[jira] [Closed] (CALCITE-3413) AssertionError for interpertering union/intersect/minus with null value

2019-10-15 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3413?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin closed CALCITE-3413. Resolution: Fixed > AssertionError for interpertering union/intersect/minus with null value >

[jira] [Comment Edited] (CALCITE-3413) AssertionError for interpertering union/intersect/minus with null value

2019-10-15 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3413?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16951926#comment-16951926 ] Wang Yanlin edited comment on CALCITE-3413 at 10/15/19 1:37 PM: Fix

[jira] [Commented] (CALCITE-3447) Fix equivalents in method SubstitutionVisitor#go

2019-10-25 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3447?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16959712#comment-16959712 ] Wang Yanlin commented on CALCITE-3447: -- I just wonder how would it affect the function of

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

2019-10-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3424?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954335#comment-16954335 ] Wang Yanlin commented on CALCITE-3424: -- The difference for *Object* and *List* lies in

[jira] [Assigned] (CALCITE-3423) Support using CAST operation and BOOLEAN type value in table macro

2019-10-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3423?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin reassigned CALCITE-3423: Assignee: Wang Yanlin > Support using CAST operation and BOOLEAN type value in table

[jira] [Assigned] (CALCITE-3400) Implement left/right/semi/anti/full join in Interpreter

2019-10-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin reassigned CALCITE-3400: Assignee: Wang Yanlin > Implement left/right/semi/anti/full join in Interpreter >

[jira] [Assigned] (CALCITE-3408) Add support for Enumerable Intersect/Minus all

2019-10-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin reassigned CALCITE-3408: Assignee: Wang Yanlin > Add support for Enumerable Intersect/Minus all >

[jira] [Assigned] (CALCITE-3362) Implementation for some empty tests of Lattice

2019-10-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3362?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin reassigned CALCITE-3362: Assignee: Wang Yanlin > Implementation for some empty tests of Lattice >

[jira] [Assigned] (CALCITE-3378) AssertionError for checking RexNode implify

2019-10-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3378?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin reassigned CALCITE-3378: Assignee: Wang Yanlin > AssertionError for checking RexNode implify >

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

2019-10-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954386#comment-16954386 ] Wang Yanlin commented on CALCITE-3402: -- Add this test case in *JdbcTest* to reproduce {code:java}

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

2019-10-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954417#comment-16954417 ] Wang Yanlin commented on CALCITE-3402: -- I think you are right about "SQL03 7.10 Rule 11a". The

[jira] [Commented] (CALCITE-3423) Support using CAST operation and BOOLEAN type value in table macro

2019-10-17 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3423?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954220#comment-16954220 ] Wang Yanlin commented on CALCITE-3423: -- But, I can only find

[jira] [Commented] (CALCITE-3423) Support using CAST operation and BOOLEAN type value in table macro

2019-10-17 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3423?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954219#comment-16954219 ] Wang Yanlin commented on CALCITE-3423: -- I was hesitate about this test cast. {code:java}

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

2019-10-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3424?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954331#comment-16954331 ] Wang Yanlin commented on CALCITE-3424: -- Strange, that, if you define method *generateStrings2*

[jira] [Updated] (CALCITE-3423) Support using CAST operation and BOOLEAN type value in table macro

2019-10-17 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3423?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3423: - Description: Currently, using bool type or cast operation in table macro, got exception. Add

[jira] [Comment Edited] (CALCITE-3423) Support using CAST operation and BOOLEAN type value in table macro

2019-10-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3423?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954220#comment-16954220 ] Wang Yanlin edited comment on CALCITE-3423 at 10/18/19 9:01 AM: But, I

[jira] [Updated] (CALCITE-3429) Refinement for implementation of sql type factory

2019-10-20 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3429: - Description: 1. Add map info from Java Map class to SqlTypeName.Map 2. SqlTypeName.Map is not

[jira] [Updated] (CALCITE-3429) Support MAP type for JavaToSqlTypeConversionRules

2019-10-21 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3429: - Summary: Support MAP type for JavaToSqlTypeConversionRules (was: Refinement for

[jira] [Created] (CALCITE-3429) Refinement for implementation of sql type factory

2019-10-18 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3429: Summary: Refinement for implementation of sql type factory Key: CALCITE-3429 URL: https://issues.apache.org/jira/browse/CALCITE-3429 Project: Calcite Issue

[jira] [Assigned] (CALCITE-3429) Refinement for implementation of sql type factory

2019-10-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin reassigned CALCITE-3429: Assignee: Wang Yanlin > Refinement for implementation of sql type factory >

[jira] [Updated] (CALCITE-3429) Refinement for implementation of sql type factory

2019-10-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3429: - Description: 1. The SqlTypeName of data type created with subclass of Map should be

[jira] [Commented] (CALCITE-3408) Add support for Enumerable Intersect/Minus all

2019-10-16 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16952681#comment-16952681 ] Wang Yanlin commented on CALCITE-3408: -- OK. updated. > Add support for Enumerable Intersect/Minus

[jira] [Created] (CALCITE-3413) AssertionError for interpertering union/intersect/minus with null value

2019-10-15 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3413: Summary: AssertionError for interpertering union/intersect/minus with null value Key: CALCITE-3413 URL: https://issues.apache.org/jira/browse/CALCITE-3413 Project:

[jira] [Updated] (CALCITE-3413) AssertionError for interpertering union/intersect/minus with null value

2019-10-15 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3413?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3413: - Issue Type: Bug (was: New Feature) > AssertionError for interpertering union/intersect/minus

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

2019-10-24 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3443?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16959366#comment-16959366 ] Wang Yanlin edited comment on CALCITE-3443 at 10/25/19 2:28 AM: try

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

2019-10-24 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3443?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16959366#comment-16959366 ] Wang Yanlin commented on CALCITE-3443: -- try this one in *RemotePreparedStatementParametersTest*

[jira] [Updated] (CALCITE-3429) Support MAP type for JavaToSqlTypeConversionRules

2019-10-29 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3429: - Description: Using Map type in table function cause AssertionError. Add this test case in

[jira] [Updated] (CALCITE-3429) Support MAP type for JavaToSqlTypeConversionRules

2019-10-29 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3429: - Issue Type: Bug (was: Improvement) > Support MAP type for JavaToSqlTypeConversionRules >

[jira] [Updated] (CALCITE-3429) AssertionError thrown for user-defined table function with map argument

2019-10-29 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3429: - Summary: AssertionError thrown for user-defined table function with map argument (was:

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

2019-10-29 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3429: - Summary: AssertionError thrown for user-defined table function with array argument (was:

[jira] [Updated] (CALCITE-3429) Support MAP type for JavaToSqlTypeConversionRules

2019-10-29 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3429: - Description: Similar to [CALCITE-3424|https://issues.apache.org/jira/browse/CALCITE-3424],

[jira] [Updated] (CALCITE-3459) AssertionError for using Timestamp/Time/Date in user defined table function

2019-10-29 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3459?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3459: - Summary: AssertionError for using Timestamp/Time/Date in user defined table function (was:

[jira] [Assigned] (CALCITE-3459) AssertionError for using Timestamp/Time/Date in user defined table function

2019-10-29 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3459?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin reassigned CALCITE-3459: Assignee: Wang Yanlin > AssertionError for using Timestamp/Time/Date in user defined

[jira] [Created] (CALCITE-3459) AssertionError for using Timestamp/Time/Date in table function

2019-10-29 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3459: Summary: AssertionError for using Timestamp/Time/Date in table function Key: CALCITE-3459 URL: https://issues.apache.org/jira/browse/CALCITE-3459 Project: Calcite

[jira] [Updated] (CALCITE-3423) Support using CAST operation and BOOLEAN type value in table macro

2019-10-17 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3423?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3423: - Summary: Support using CAST operation and BOOLEAN type value in table macro (was: Support

[jira] [Updated] (CALCITE-3423) Support using CAST operation and BOOLEAN type value in table macro

2019-10-17 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3423?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3423: - Description: Currently, using bool type or cast operation in table macro, got exception. Add

[jira] [Commented] (CALCITE-3423) Support using CAST operation and BOOLEAN type value in table macro

2019-10-17 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3423?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954208#comment-16954208 ] Wang Yanlin commented on CALCITE-3423: -- Sure. Jira and PR updated. > Support using CAST

[jira] [Created] (CALCITE-3423) Support using CAST operation and bool type value in table macro

2019-10-17 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3423: Summary: Support using CAST operation and bool type value in table macro Key: CALCITE-3423 URL: https://issues.apache.org/jira/browse/CALCITE-3423 Project: Calcite

[jira] [Updated] (CALCITE-3423) Support using CAST operation and bool type value in table macro

2019-10-17 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3423?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3423: - Description: Currently, using bool type or cast operation in table macro, got exception. Add

[jira] [Commented] (CALCITE-3407) Implement Minus and Intersect relational operators in the interpreter

2019-10-17 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3407?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16953496#comment-16953496 ] Wang Yanlin commented on CALCITE-3407: -- OK. Is it a convention for checking sql with

[jira] [Updated] (CALCITE-3400) Implement left/right/semi/anti/full join in Interpreter

2019-10-17 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3400: - Summary: Implement left/right/semi/anti/full join in Interpreter (was: Add support for

[jira] [Commented] (CALCITE-3447) Fix equivalents in method SubstitutionVisitor#go

2019-10-26 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3447?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16960304#comment-16960304 ] Wang Yanlin commented on CALCITE-3447: -- Yes, the HepPlanner use the pair of digest and rowType of

[jira] [Commented] (CALCITE-3449) Modify sql will have sub schema in it's table name

2019-10-26 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16960502#comment-16960502 ] Wang Yanlin commented on CALCITE-3449: -- I guess that's because the result of *tableName* function

[jira] [Commented] (CALCITE-3473) Getting unique result for table scan should contain key column(s)

2019-12-01 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16985866#comment-16985866 ] Wang Yanlin commented on CALCITE-3473: -- We should add a check in RelMdUniqueKeys.getUniqueKeys for

[jira] [Updated] (CALCITE-3459) AssertionError for using Timestamp/Time/Date in user defined table function

2019-10-29 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3459?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3459: - Component/s: core > AssertionError for using Timestamp/Time/Date in user defined table

[jira] [Updated] (CALCITE-3464) RexSimplify simplifies plan having filter with NULL to empty values

2019-10-31 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3464?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3464: - Attachment: pics.jpg > RexSimplify simplifies plan having filter with NULL to empty values >

[jira] [Commented] (CALCITE-3464) RexSimplify simplifies plan having filter with NULL to empty values

2019-10-31 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3464?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16963892#comment-16963892 ] Wang Yanlin commented on CALCITE-3464: -- Hi, [~zabetak] and [~kgyrtkirk], very thanks for your fast

[jira] [Closed] (CALCITE-3464) RexSimplify simplifies plan having filter with NULL to empty values

2019-10-31 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3464?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin closed CALCITE-3464. Assignee: Wang Yanlin Resolution: Not A Problem > RexSimplify simplifies plan having

[jira] [Assigned] (CALCITE-3473) Result of getting unique result for table scan should contain key column(s)

2019-11-04 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3473?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin reassigned CALCITE-3473: Assignee: Wang Yanlin > Result of getting unique result for table scan should contain

[jira] [Updated] (CALCITE-3473) Result of getting unique result for table scan should contain key column(s)

2019-11-04 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3473?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3473: - Summary: Result of getting unique result for table scan should contain key column(s) (was:

[jira] [Created] (CALCITE-3473) Unique keys of table scan should contain key column(s)

2019-11-04 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3473: Summary: Unique keys of table scan should contain key column(s) Key: CALCITE-3473 URL: https://issues.apache.org/jira/browse/CALCITE-3473 Project: Calcite

[jira] [Created] (CALCITE-3464) RexSimplify simplifies plan having filter with NULL to empty values

2019-10-31 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3464: Summary: RexSimplify simplifies plan having filter with NULL to empty values Key: CALCITE-3464 URL: https://issues.apache.org/jira/browse/CALCITE-3464 Project:

[jira] [Updated] (CALCITE-3473) Getting unique result for table scan should contain key column(s)

2019-11-04 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3473?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3473: - Summary: Getting unique result for table scan should contain key column(s) (was: Result of

[jira] [Commented] (CALCITE-3466) JDBC adapter dropped group by statement in subquery

2019-10-31 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3466?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16963973#comment-16963973 ] Wang Yanlin commented on CALCITE-3466: -- {code:java} select a, avg(c1) from ( select

[jira] [Created] (CALCITE-3494) Support decimal type aggregate in Interpreter

2019-11-12 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3494: Summary: Support decimal type aggregate in Interpreter Key: CALCITE-3494 URL: https://issues.apache.org/jira/browse/CALCITE-3494 Project: Calcite Issue

[jira] [Assigned] (CALCITE-3494) Support decimal type aggregate in Interpreter

2019-11-12 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin reassigned CALCITE-3494: Assignee: Wang Yanlin > Support decimal type aggregate in Interpreter >

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

2019-10-08 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3388?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16946752#comment-16946752 ] Wang Yanlin edited comment on CALCITE-3388 at 10/8/19 11:40 AM: Well,

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

2019-10-08 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3388?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16946752#comment-16946752 ] Wang Yanlin commented on CALCITE-3388: -- This exception is not from any product environment. I

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

2019-10-10 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16948237#comment-16948237 ] Wang Yanlin commented on CALCITE-3379: -- Currently, this test case in *ServerTest* run success,

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

2019-10-10 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16948284#comment-16948284 ] Wang Yanlin commented on CALCITE-3379: -- it's *trims* not *trim*. Trim is valid, but trims is

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

2019-10-10 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3397?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3397: - Description: when interpretering sql  *select multiset['a', 'b', 'c']* got, {code:java}

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

2019-10-10 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3397: Summary: AssertionError for interpreter multiset Key: CALCITE-3397 URL: https://issues.apache.org/jira/browse/CALCITE-3397 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-3400) Add support for interpretering outer/semi/anti/full join

2019-10-11 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3400: Summary: Add support for interpretering outer/semi/anti/full join Key: CALCITE-3400 URL: https://issues.apache.org/jira/browse/CALCITE-3400 Project: Calcite

[jira] [Updated] (CALCITE-3400) Add support for interpretering left/right/semi/anti/full join

2019-10-11 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3400: - Description: Currently, 

[jira] [Updated] (CALCITE-3400) Add support for interpretering left/right/semi/anti/full join

2019-10-11 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3400: - Description: Currently, 

[jira] [Updated] (CALCITE-3400) Add support for interpretering left/right/semi/anti/full join

2019-10-11 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3400: - Summary: Add support for interpretering left/right/semi/anti/full join (was: Add support for

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

2019-10-10 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16949061#comment-16949061 ] Wang Yanlin commented on CALCITE-3379: -- Agree that we need to validate both DDL and expression of

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

2019-10-10 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3376?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16949062#comment-16949062 ] Wang Yanlin commented on CALCITE-3376: -- This seems to be fixed after 

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

2019-10-10 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3376?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3376: - Comment: was deleted (was: This seems to be fixed after 

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

2019-10-04 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3388: Summary: StackOverflowError for creating structured RelDataType from class type Key: CALCITE-3388 URL: https://issues.apache.org/jira/browse/CALCITE-3388 Project:

[jira] [Closed] (CALCITE-3374) Error format check result for explain plan as json

2019-10-04 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin closed CALCITE-3374. > Error format check result for explain plan as json >

[jira] [Commented] (CALCITE-3406) duplicate initialize scope

2019-10-14 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3406?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16950750#comment-16950750 ] Wang Yanlin commented on CALCITE-3406: -- I don't think this is a problem. > duplicate initialize

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

2019-10-14 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3388?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16950757#comment-16950757 ] Wang Yanlin commented on CALCITE-3388: -- Seems unnecessary, I'll just close this jira We can

[jira] [Updated] (CALCITE-3408) Add support for Enumerable Intersect/Minus all

2019-10-14 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3408: - Issue Type: Improvement (was: New Feature) > Add support for Enumerable Intersect/Minus all >

[jira] [Created] (CALCITE-3407) Add support for interpretering minus/intersect relational set operators

2019-10-14 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3407: Summary: Add support for interpretering minus/intersect relational set operators Key: CALCITE-3407 URL: https://issues.apache.org/jira/browse/CALCITE-3407 Project:

[jira] [Updated] (CALCITE-3407) Add support for interpretering minus/intersect relational set operators

2019-10-14 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3407?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3407: - Component/s: core > Add support for interpretering minus/intersect relational set operators >

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

2019-10-14 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3388?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin closed CALCITE-3388. Resolution: Cannot Reproduce > StackOverflowError for creating structured RelDataType from class

[jira] [Created] (CALCITE-3408) Add support for Enumerable Intersect/Minus all

2019-10-14 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3408: Summary: Add support for Enumerable Intersect/Minus all Key: CALCITE-3408 URL: https://issues.apache.org/jira/browse/CALCITE-3408 Project: Calcite Issue

[jira] [Updated] (CALCITE-3408) Add support for Enumerable Intersect/Minus all

2019-10-14 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3408: - Description: When running sql with calcite driver {code:java} final String sql = "select *

[jira] [Assigned] (CALCITE-3557) ClassCastException for using nested multiset or array inside multiset

2019-12-03 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3557?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin reassigned CALCITE-3557: Assignee: Wang Yanlin > ClassCastException for using nested multiset or array inside

[jira] [Created] (CALCITE-3561) Support using unnest in Interpreter

2019-12-03 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3561: Summary: Support using unnest in Interpreter Key: CALCITE-3561 URL: https://issues.apache.org/jira/browse/CALCITE-3561 Project: Calcite Issue Type:

[jira] [Assigned] (CALCITE-3561) Support using unnest in Interpreter

2019-12-03 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3561?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin reassigned CALCITE-3561: Assignee: Wang Yanlin > Support using unnest in Interpreter >

[jira] [Created] (CALCITE-3583) Support serialized to json and deserialized from json for Exchange relation operator

2019-12-09 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3583: Summary: Support serialized to json and deserialized from json for Exchange relation operator Key: CALCITE-3583 URL: https://issues.apache.org/jira/browse/CALCITE-3583

[jira] [Closed] (CALCITE-3639) JoinConditionPushRule fail to push filter to inputs

2019-12-27 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin closed CALCITE-3639. Resolution: Not A Bug > JoinConditionPushRule fail to push filter to inputs >

[jira] [Commented] (CALCITE-3639) JoinConditionPushRule fail to push filter to inputs

2019-12-27 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17004120#comment-17004120 ] Wang Yanlin commented on CALCITE-3639: -- Actually, this is not a bug. {code:java}

[jira] [Closed] (CALCITE-3664) Sort in subquery is lost when converting SqlNode to Relnode

2020-01-03 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3664?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin closed CALCITE-3664. Resolution: Not A Problem > Sort in subquery is lost when converting SqlNode to Relnode >

[jira] [Commented] (CALCITE-3664) Sort in subquery is lost when converting SqlNode to Relnode

2020-01-03 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3664?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17007306#comment-17007306 ] Wang Yanlin commented on CALCITE-3664: -- Thanks [~hyuan]  , now I got.  I'll just close this jira.

[jira] [Created] (CALCITE-3664) Lost sort in subquery when converting SqlNode to Relnode

2020-01-02 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3664: Summary: Lost sort in subquery when converting SqlNode to Relnode Key: CALCITE-3664 URL: https://issues.apache.org/jira/browse/CALCITE-3664 Project: Calcite

[jira] [Assigned] (CALCITE-3664) Lost sort in subquery when converting SqlNode to Relnode

2020-01-02 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3664?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin reassigned CALCITE-3664: Assignee: Wang Yanlin > Lost sort in subquery when converting SqlNode to Relnode >

[jira] [Updated] (CALCITE-3664) Sort in subquery is lost when converting SqlNode to Relnode

2020-01-02 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3664?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3664: - Summary: Sort in subquery is lost when converting SqlNode to Relnode (was: Lost sort in

[jira] [Commented] (CALCITE-3639) JoinConditionPushRule fail to push filter to inputs

2019-12-29 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17005089#comment-17005089 ] Wang Yanlin commented on CALCITE-3639: -- Because it's left join, and no rows join success, so use

[jira] [Created] (CALCITE-3651) NullPointerException when convert relational algebra that correlates TableFunctionScan

2019-12-30 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3651: Summary: NullPointerException when convert relational algebra that correlates TableFunctionScan Key: CALCITE-3651 URL: https://issues.apache.org/jira/browse/CALCITE-3651

[jira] [Assigned] (CALCITE-3651) NullPointerException when convert relational algebra that correlates TableFunctionScan

2019-12-30 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3651?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin reassigned CALCITE-3651: Assignee: Wang Yanlin > NullPointerException when convert relational algebra that

[jira] [Created] (CALCITE-3639) JoinConditionPushRule fail to push filter to inputs

2019-12-27 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3639: Summary: JoinConditionPushRule fail to push filter to inputs Key: CALCITE-3639 URL: https://issues.apache.org/jira/browse/CALCITE-3639 Project: Calcite

[jira] [Assigned] (CALCITE-3639) JoinConditionPushRule fail to push filter to inputs

2019-12-27 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin reassigned CALCITE-3639: Assignee: Wang Yanlin > JoinConditionPushRule fail to push filter to inputs >

[jira] [Created] (CALCITE-3929) NullPointerException when deserialize UDAF aggregate call from json string

2020-04-15 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3929: Summary: NullPointerException when deserialize UDAF aggregate call from json string Key: CALCITE-3929 URL: https://issues.apache.org/jira/browse/CALCITE-3929

<    1   2   3   >