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

Boolean fields with null are evaluated to false

    XMLWordPrintable

Details

    Description

      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

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: