]
RH Bugzilla Integration commented on TEIID-3324:
------------------------------------------------
Matus Makovy <mmakovy(a)redhat.com> changed the Status of [bug
Boolean fields with null are evaluated to false
-----------------------------------------------
Key: TEIID-3324
URL:
https://issues.jboss.org/browse/TEIID-3324
Project: Teiid
Issue Type: Bug
Components: JDBC Connector
Affects Versions: 7.1
Reporter: Salvatore R
Assignee: Steven Hawkins
Fix For: 8.10, 8.7.2, 8.7.1.6_2
I have a source table defined as follows (e.g. in PostgreSQL):
{code:sql}
CREATE TABLE public.test
(
id integer,
iscustomer boolean
)
{code}
and the table contains these rows:
{code:sql}
insert into public.test values(1, null);
insert into public.test values(2, true);
insert into public.test values(3, false);
{code}
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|