[IGNITE-14158] SQL. Calcite: returns an empty string instead of null values for numeric types.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: sql
• Labels: calcite
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Aleksey Plekhanov
• Reporter: Fedor Malchikov
• Created: 10/Feb/21 12:23
• Updated: 04/Aug/21 08:59
• Resolved: 16/Feb/21 14:48

Description

Example:

CREATE TABLE t1 ( id INT NOT NULL, bool_col BOOLEAN, tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, varchar_col VARCHAR, char_col CHAR, float_col FLOAT, double_col DOUBLE, time_col TIME, PRIMARY KEY (id));
INSERT INTO t1 (id,bool_col,tinyint_col,smallint_col,int_col,bigint_col,varchar_col,char_col,float_col,double_col,time_col) VALUES (1, null, null, null, null, null, null, null, null, null, null);
SELECT * FROM t1;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
'1','','','','','','','','','',''

H2 return:

SELECT * FROM t1;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
'1','','null','null','null','null','','','null','null',''

Issue Links

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