[IGNITE-14157] SQL. Calcite: Return human-readable column names for expression results in select

• 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:08
• Updated: 11/Nov/22 07:41
• Resolved: 04/Mar/21 09:46

Description

Example:

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

H2 return as expected:

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

Issue Links

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