You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Aleksey Plekhanov (Jira)" <ji...@apache.org> on 2021/02/11 10:15:00 UTC
[jira] [Assigned] (IGNITE-14158) SQL. Calcite: returns an empty
string instead of null values for numeric types.
[ https://issues.apache.org/jira/browse/IGNITE-14158?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aleksey Plekhanov reassigned IGNITE-14158:
------------------------------------------
Assignee: Aleksey Plekhanov
> 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
>
> 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)