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

[Fedor Malchikov (Jira)]

Fedor Malchikov  created IGNITE-14158:
-----------------------------------------

             Summary: SQL. Calcite:  returns an empty string instead of null 
values for numeric types.
                 Key: IGNITE-14158
                 URL: https://issues.apache.org/jira/browse/IGNITE-14158
             Project: Ignite
          Issue Type: Bug
          Components: sql
            Reporter: Fedor Malchikov 


Example:
{code:sql}
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','','','','','','','','','',''
{code}
H2 return:
{code:sql}
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',''

{code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)