3 Replies Latest reply on Feb 5, 2015 8:44 AM by Steven Hawkins

    Boolean fields with null are evaluated to false

    Salvatore R Newbie

      Hi all,


      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:



      I reproduced this behavior in Teiid-8.10.0-Beta2.