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

[Anton Vinogradov (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)