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

["Aleksey Plekhanov (Jira)" <ji...@apache.org>]

    [ 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)