[jira] [Closed] (CALCITE-3543) JDBC adapter converts count with single column to count star

2019-12-16 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3543?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong closed CALCITE-3543. - Resolution: Not A Problem > JDBC adapter converts count with single column to count star >

[jira] [Commented] (CALCITE-3543) JDBC adapter converts count with single column to count star

2019-12-16 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3543?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16997366#comment-16997366 ] Wang Weidong commented on CALCITE-3543: --- [~donnyzone][~amaliujia] I've read and debugged the

[jira] [Commented] (CALCITE-3543) JDBC adapter converts count with single column to count star

2019-11-29 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3543?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984955#comment-16984955 ] Wang Weidong commented on CALCITE-3543: --- [~donnyzone] Yes, I will check other places about sql

[jira] [Commented] (CALCITE-3543) JDBC adapter converts count with single column to count star

2019-11-29 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3543?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984950#comment-16984950 ] Wang Weidong commented on CALCITE-3543: --- [~amaliujia] Yes, I want to fix it next week. > JDBC

[jira] [Created] (CALCITE-3543) JDBC adapter converts count with single column to count star

2019-11-27 Thread Wang Weidong (Jira)
Wang Weidong created CALCITE-3543: - Summary: JDBC adapter converts count with single column to count star Key: CALCITE-3543 URL: https://issues.apache.org/jira/browse/CALCITE-3543 Project: Calcite

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

2019-11-26 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3466?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16982409#comment-16982409 ] Wang Weidong commented on CALCITE-3466: --- [~julianhyde] [~yanlin-Lynn] Hi, I've submit a pr, could

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

2019-11-26 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3466?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16982409#comment-16982409 ] Wang Weidong edited comment on CALCITE-3466 at 11/26/19 12:00 PM: --

[jira] [Closed] (CALCITE-3532) SqlValidator throws exception with message of db not found while table not existed

2019-11-24 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3532?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong closed CALCITE-3532. - Resolution: Invalid > SqlValidator throws exception with message of db not found while table

[jira] [Commented] (CALCITE-3532) SqlValidator throws exception with message of db not found while table not existed

2019-11-24 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3532?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16981289#comment-16981289 ] Wang Weidong commented on CALCITE-3532: --- [~amaliujia] I've found that this problem was caused by

[jira] [Updated] (CALCITE-3532) SqlValidator throws exception with message of db not found while table not existed

2019-11-22 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3532?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3532: -- Description: I found that if a SqlNode of a sql with an not existed table is validated, an

[jira] [Updated] (CALCITE-3532) SqlValidator throws exception with message of db not found while table not existed

2019-11-22 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3532?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3532: -- Description: I found that if a SqlNode of a sql with an not existed table is validated, an

[jira] [Updated] (CALCITE-3532) SqlValidator throws exception with message of db not found while table not existed

2019-11-22 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3532?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3532: -- Description: I found that if a SqlNode of a sql with an not existed table is validated, >

[jira] [Created] (CALCITE-3532) SqlValidator throws exception with message of db not found while table not existed

2019-11-22 Thread Wang Weidong (Jira)
Wang Weidong created CALCITE-3532: - Summary: SqlValidator throws exception with message of db not found while table not existed Key: CALCITE-3532 URL: https://issues.apache.org/jira/browse/CALCITE-3532

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

2019-11-19 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong reassigned CALCITE-3466: - Assignee: Wang Weidong > JDBC adapter dropped group by statement in subquery >

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

2019-11-19 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3466?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16978043#comment-16978043 ] Wang Weidong commented on CALCITE-3466: --- Is there anyone who wants to fix this bug? I will fix it

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

2019-11-01 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3466?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16964631#comment-16964631 ] Wang Weidong commented on CALCITE-3466: --- Hi, [~yanlin-Lynn] I don't agree with your deduction. We

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

2019-11-01 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3466: -- Attachment: screenshot-1.png > JDBC adapter dropped group by statement in subquery >

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

2019-10-31 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3466: -- Description: While convert RelNode to SqlNode, the "group by" statement in subquery was

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

2019-10-31 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3466: -- Description: While convert RelNode to SqlNode, the "group by" statement in subquery was

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

2019-10-31 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3466: -- Description: While convert RelNode to SqlNode, the "group by" statement in subquery was

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

2019-10-31 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3466: -- Description: While convert RelNode to SqlNode, the "group by" statement in subquery was

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

2019-10-31 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3466: -- Description: While convert RelNode to SqlNode, the "group by" statement in subquery was

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

2019-10-31 Thread Wang Weidong (Jira)
Wang Weidong created CALCITE-3466: - Summary: JDBC adapter dropped group by statement in subquery Key: CALCITE-3466 URL: https://issues.apache.org/jira/browse/CALCITE-3466 Project: Calcite

[jira] [Commented] (CALCITE-3299) Replace star identifier as select list of if no operands given while in the method "createCall"

2019-10-31 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3299?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16963700#comment-16963700 ] Wang Weidong commented on CALCITE-3299: --- Anyone response this issue? > Replace star identifier

[jira] [Commented] (CALCITE-3300) In JDBC adapter, when generating SQL for count star, generates the star argument of the call

2019-10-23 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16957886#comment-16957886 ] Wang Weidong commented on CALCITE-3300: --- [~danny0405] OK.Asking by the way, have you remove the

[jira] [Commented] (CALCITE-3300) Add a star identifier as operand to "SqlCountAggFunction" if no operands given while in the method "createCall"

2019-10-17 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16953562#comment-16953562 ] Wang Weidong commented on CALCITE-3300: --- [~danny0405] Thanks for you suggestions, I will fix my

[jira] [Comment Edited] (CALCITE-3300) Add a star identifier as operand to "SqlCountAggFunction" if no operands given while in the method "createCall"

2019-10-17 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16924714#comment-16924714 ] Wang Weidong edited comment on CALCITE-3300 at 10/17/19 9:33 AM: - I

[jira] [Comment Edited] (CALCITE-3300) Add a star identifier as operand to "SqlCountAggFunction" if no operands given while in the method "createCall"

2019-10-09 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16948167#comment-16948167 ] Wang Weidong edited comment on CALCITE-3300 at 10/10/19 3:31 AM: -

[jira] [Commented] (CALCITE-3300) Add a star identifier as operand to "SqlCountAggFunction" if no operands given while in the method "createCall"

2019-10-09 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16948167#comment-16948167 ] Wang Weidong commented on CALCITE-3300: --- [~julianhyde] Will reply my discussion ? > Add a star

[jira] [Comment Edited] (CALCITE-3300) Add a star identifier as operand to "SqlCountAggFunction" if no operands given while in the method "createCall"

2019-09-06 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16924714#comment-16924714 ] Wang Weidong edited comment on CALCITE-3300 at 9/7/19 3:54 AM: --- I support

[jira] [Comment Edited] (CALCITE-3300) Add a star identifier as operand to "SqlCountAggFunction" if no operands given while in the method "createCall"

2019-09-06 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16924714#comment-16924714 ] Wang Weidong edited comment on CALCITE-3300 at 9/7/19 3:54 AM: --- I support

[jira] [Commented] (CALCITE-3300) Add a star identifier as operand to "SqlCountAggFunction" if no operands given while in the method "createCall"

2019-09-06 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16924714#comment-16924714 ] Wang Weidong commented on CALCITE-3300: --- I support to standardize "assertThat". If COUNT() is

[jira] [Comment Edited] (CALCITE-3300) Add a star identifier as operand to "SqlCountAggFunction" if no operands given while in the method "createCall"

2019-09-03 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16921378#comment-16921378 ] Wang Weidong edited comment on CALCITE-3300 at 9/3/19 12:11 PM:

[jira] [Commented] (CALCITE-3300) Add a star identifier as operand to "SqlCountAggFunction" if no operands given while in the method "createCall"

2019-09-03 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16921378#comment-16921378 ] Wang Weidong commented on CALCITE-3300: --- [~julianhyde]  * "I don't think you should make 

[jira] [Updated] (CALCITE-3299) Replace star identifier as select list of if no operands given while in the method "createCall"

2019-08-29 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3299?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3299: -- Summary: Replace star identifier as select list of if no operands given while in the method

[jira] [Assigned] (CALCITE-3300) Add a star identifier as operand to "SqlCountAggFunction" if no operands given while in the method "createCall"

2019-08-29 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3300?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong reassigned CALCITE-3300: - Assignee: Wang Weidong > Add a star identifier as operand to "SqlCountAggFunction" if

[jira] [Updated] (CALCITE-3300) Add a star identifier as operand to "SqlCountAggFunction" if no operands given while in the method "createCall"

2019-08-29 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3300?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3300: -- Summary: Add a star identifier as operand to "SqlCountAggFunction" if no operands given

[jira] [Updated] (CALCITE-3300) Handle validating exception for SqlNode of count star converted by RelNode

2019-08-28 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3300?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3300: -- Description: h4. Procedure to reproduce the problem: - create table {{~^t^~}} - parse

[jira] [Updated] (CALCITE-3300) Handle validating exception for SqlNode of count star converted by RelNode

2019-08-28 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3300?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3300: -- Description: h4. Procedure to reproduce the problem: - create table {{~^t^~}} - parse

[jira] [Updated] (CALCITE-3300) Handle validating exception for SqlNode of count star converted by RelNode

2019-08-28 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3300?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3300: -- Description: h4. Procedure to reproduce the problem: - create table {{~^t^~}} - parse

[jira] [Updated] (CALCITE-3300) Handle validating exception for SqlNode of count star converted by RelNode

2019-08-28 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3300?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3300: -- Description: h4. Procedure to reproduce the problem: - create table {{~^t^~}} - parse

[jira] [Created] (CALCITE-3300) Handle validating exception for SqlNode of count star converted by RelNode

2019-08-28 Thread Wang Weidong (Jira)
Wang Weidong created CALCITE-3300: - Summary: Handle validating exception for SqlNode of count star converted by RelNode Key: CALCITE-3300 URL: https://issues.apache.org/jira/browse/CALCITE-3300

[jira] [Updated] (CALCITE-3299) Handle validating exception for SqlNode of select star converted by RelNode

2019-08-28 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3299?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3299: -- Description: h4. Procedure to reproduce the problem: - create table {{~^t^~}} - parse

[jira] [Updated] (CALCITE-3299) Handle validating exception for SqlNode of select star converted by RelNode

2019-08-28 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3299?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3299: -- Description: h4. Procedure to reproduce the problem: - create table {{~^t^~}} - parse

[jira] [Updated] (CALCITE-3299) Handle validating exception for SqlNode of select star converted by RelNode

2019-08-28 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3299?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3299: -- Description: h4. Procedure to reproduce the problem: - create table {{~^t^~}} - parse

[jira] [Updated] (CALCITE-3299) Handle validating exception for SqlNode of select star converted by RelNode

2019-08-28 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3299?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3299: -- Description: h4. Procedure to reproduce the problem: - create table {{~^t^~}} - parse

[jira] [Updated] (CALCITE-3299) Handle validating exception for SqlNode of select star converted by RelNode

2019-08-28 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3299?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3299: -- Description: h4. Procedure to reproduce the problem: - create table {{~^t^~}} - parse

[jira] [Updated] (CALCITE-3299) Handle validating exception for SqlNode of select star converted by RelNode

2019-08-28 Thread Wang Weidong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3299?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3299: -- Description: h4. Procedure to reproduce the problem: - create table {{~^t^~}} - parse

[jira] [Created] (CALCITE-3299) Handle validating exception for SqlNode of select star converted by RelNode

2019-08-28 Thread Wang Weidong (Jira)
Wang Weidong created CALCITE-3299: - Summary: Handle validating exception for SqlNode of select star converted by RelNode Key: CALCITE-3299 URL: https://issues.apache.org/jira/browse/CALCITE-3299

[jira] [Assigned] (CALCITE-3210) RelToSqlConverter convert "cast(null as $type)" just as null

2019-07-24 Thread Wang Weidong (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong reassigned CALCITE-3210: - Assignee: Wang Weidong > RelToSqlConverter convert "cast(null as $type)" just as

[jira] [Commented] (CALCITE-3210) RelToSqlConverter convert "cast(null as $type)" just as null

2019-07-24 Thread Wang Weidong (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16892382#comment-16892382 ] Wang Weidong commented on CALCITE-3210: --- I mean that cast was abandoned while  RelToSqlConverter

[jira] [Updated] (CALCITE-3210) RelToSqlConverter convert "cast(null as $type)" just as null

2019-07-24 Thread Wang Weidong (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Weidong updated CALCITE-3210: -- Description: I have as sql as follows:  {code:java} select cast(null as varchar) as a{code}

[jira] [Created] (CALCITE-3210) RelToSqlConverter convert "cast(null as $type)" just as null

2019-07-24 Thread Wang Weidong (JIRA)
Wang Weidong created CALCITE-3210: - Summary: RelToSqlConverter convert "cast(null as $type)" just as null Key: CALCITE-3210 URL: https://issues.apache.org/jira/browse/CALCITE-3210 Project: Calcite