[IGNITE-14156] SQL. Calcite: Does not return the count result if there are 0 elements in the table.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: sql
• Labels: calcite
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Iurii Gerzhedovich
• Reporter: Fedor Malchikov
• Created: 10/Feb/21 12:04
• Updated: 11/Nov/22 07:37
• Resolved: 20/Feb/21 09:12

Description

Example:

CREATE TABLE t1 ( id INT NOT NULL, int_col INT, PRIMARY KEY (id));
SELECT COUNT(*) FROM t1;
+--------------------------------+
|             EXPR$0             |
+--------------------------------+
+--------------------------------+

H2 return:

 SELECT COUNT(*) FROM t1;
+--------------------------------+
|            COUNT(*)            |
+--------------------------------+
| 0                              |
+--------------------------------+

if add some elements, then calcite return value:

SELECT COUNT(*) FROM t1;
+--------------------------------+
|             EXPR$0             |
+--------------------------------+
| 5                              |
+--------------------------------+

Issue Links

• is part of: IGNITE-12248 Apache Calcite based query execution engine
• links to: GitHub Pull Request #8812