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.
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.
Retrieving data ...