[teiid-issues] [JBoss JIRA] (TEIID-3324) Boolean fields with null are evaluated to false
Salvatore R created TEIID-3324:
----------------------------------
Summary: Boolean fields with null are evaluated to false
Key: TEIID-3324
URL: https://issues.jboss.org/browse/TEIID-3324
Project: Teiid
Issue Type: Bug
Reporter: Salvatore R
Assignee: Steven Hawkins
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|
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)