[
https://issues.apache.org/jira/browse/IGNITE-20048?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alexander Belyak updated IGNITE-20048:
--------------------------------------
Description:
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}
was:
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
> 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)
