Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-14158

SQL. Calcite: returns an empty string instead of null values for numeric types.

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: sql
    • Labels:
    • Ignite Flags:
      Docs Required, Release Notes Required

      Description

      Example:

      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','','','','','','','','','',''
      

      H2 return:

      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',''
      
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                alex_pl Aleksey Plekhanov
                Reporter:
                prom1se Fedor Malchikov
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 10m
                  10m