1 Reply Latest reply on Jul 2, 2013 6:44 AM by shawkins

    How to handle nulls

    mbisne

      Hi,

       

      I am firing a select * query in SQL scrapbook, it works fine.But the follwing query does not work:

       

      Select * from <table> where <column> is not null

       

      This query returns data but the filter "not null" is not applied.

       

      Can anyone help me with this.

       

      Thanks,

      Mandar

        • 1. Re: How to handle nulls
          shawkins

          If you can supply the Teiid version and a query plan, that would help give you some initial feedback.  Even better if this is reproducibly with a small test case you could provide a sample vdb and user query.

           

          Steve