[jira] [Created] (IGNITE-20048) Wrong null type for null values in DB tools

["Alexander Belyak (Jira)" <ji...@apache.org>]

Alexander Belyak created IGNITE-20048:
-----------------------------------------

             Summary: Wrong null type for null values in DB tools
                 Key: IGNITE-20048
                 URL: https://issues.apache.org/jira/browse/IGNITE-20048
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 3.0
            Reporter: Alexander Belyak


In tools like DB Visualizer, IDEA, DBeaver user will get:
 * 0 instead of null in integer fields
 * false instead of null in varchar fields

Reproducer:
{noformat}
DROP TABLE IF EXISTS test;CREATE TABLE test (id int PRIMARY KEY, vali int, vals varchar);INSERT INTO test(id, vali, vals) values(1,1,'1'),(2,NULL,'2'),(3,3,null);SELECT * FROM test{noformat}
Expected result:
{noformat}
ID     VALI     VALS3
3      3        (null)
2      (null)   2
1      1        1{noformat}
Actual results:
{noformat}
ID      VALI     VALS3
3	3        false
2	0	 2
1	1	 1{noformat}
Commit id: f34beaed



--
This message was sent by Atlassian Jira
(v8.20.10#820010)