Boolean fields with null are evaluated to false

[fox123]

Hi all,

I have a source table defined as follows (e.g. in PostgreSQL):

CREATE TABLE public.test
(
  id integer,
  iscustomer boolean
)

and the table contains these rows:

insert into public.test values(1, null);
insert into public.test values(2, true);
insert into public.test values(3, false);

When I try to get data from this table in Teiid, the "null" value is evaluated as false:

id	iscustomer
1	false
2	true
3	false

I reproduced this behavior in Teiid-8.10.0-Beta2.

[shawkins]

Yes, there is an issue there.  The JDBC translator reads for boolean values is not checking the ResultSet is null flag as it should.  Can you log an issue for this?

[fox123]

Hi Steven,

thanks for the quick reply, as usual.

I created a new issue here:

[TEIID-3324] Boolean fields with null are evaluated to false - JBoss Issue Tracker

[shawkins]

Thanks, the fix will be in 8.10 CR1.