Fedor Malchikov created IGNITE-14156:
-----------------------------------------
Summary: 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
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)
