[
https://issues.apache.org/jira/browse/IGNITE-14156?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17286500#comment-17286500
]
Yury Gerzhedovich commented on IGNITE-14156:
--------------------------------------------
[~korlov], [~tledkov-gridgain] could you please review the patch.
> SQL. Calcite: Does not return the count result if there are 0 elements in
> the table.
> -------------------------------------------------------------------------------------
>
> Key: IGNITE-14156
> URL: https://issues.apache.org/jira/browse/IGNITE-14156
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Fedor Malchikov
> Assignee: Yury Gerzhedovich
> Priority: Major
> Labels: calcite
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Example:
> {code:sql}
> CREATE TABLE t1 ( id INT NOT NULL, int_col INT, PRIMARY KEY (id));
> SELECT COUNT(*) FROM t1;
> +--------------------------------+
> | EXPR$0 |
> +--------------------------------+
> +--------------------------------+
> {code}
> H2 return:
> {code:java}
> SELECT COUNT(*) FROM t1;
> +--------------------------------+
> | COUNT(*) |
> +--------------------------------+
> | 0 |
> +--------------------------------+
> {code}
> if add some elements, then calcite return value:
> {code:SQL}
> SELECT COUNT(*) FROM t1;
> +--------------------------------+
> | EXPR$0 |
> +--------------------------------+
> | 5 |
> +--------------------------------+
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
