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 of over 48,000 articles and solutions.
Close
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.