[ https://issues.apache.org/jira/browse/IGNITE-14158?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17283585#comment-17283585 ]
Aleksey Plekhanov commented on IGNITE-14158: -------------------------------------------- [~tledkov-gridgain], can you please review the patch? > 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 > Assignee: Aleksey Plekhanov > Priority: Major > Labels: calcite > Time Spent: 10m > Remaining Estimate: 0h > > 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)