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)
