Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3324

Boolean fields with null are evaluated to false

XMLWordPrintable

      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

              rhn-engineering-shawkins Steven Hawkins
              redfox999 Salvatore R. (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: