Why teiid engine modifies the query condition to "WHERE 1 = 0"
Issue
In a DB, there is a column "a" whoose datatype is NUMBER. I create a VDB including the column, and send a query to the VDB like this:
SELECT * FROM DEMO.TEST WHERE a = 'not good value'
Although the result, 0, is expected value, there is a totally different query in a command log:
SELECT * FROM DEMO.TEST WHERE 1 = 0
Is this expected behavior?
Environment
- Red Hat JBoss Data Virtualization
- 6.0.0
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.