[
https://issues.apache.org/jira/browse/IGNITE-14156?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Taras Ledkov resolved IGNITE-14156.
-----------------------------------
Resolution: Fixed
The patch is OK with me.
Merged to the branch
[sql-calcite|https://github.com/apache/ignite/commit/781bd1443e25164fca6923e3e3038f61a6a1a471].
> 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: 20m
> 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)
