[
https://issues.apache.org/jira/browse/IGNITE-20048?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yury Gerzhedovich resolved IGNITE-20048.
----------------------------------------
Resolution: Cannot Reproduce
Seems the issue already fixed
> 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
> Priority: Major
> Labels: ignite-3
>
> 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
> But actually database store null values, for example, queries like:
> {noformat}
> SELECT * FROM test WHERE vali IS null{noformat}
> will return:
> {noformat}
> ID VALI VALS3
> 2 0 2{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
