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:

      idiscustomer
      1false
      2true
      3false

       

      I reproduced this behavior in Teiid-8.10.0-Beta2.