[teiid-issues] [JBoss JIRA] (TEIID-3324) Boolean fields with null are evaluated to false

[Salvatore R (JIRA)]

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)