Teiid engine moves the position of LIMIT phrase into a sub query
Issue
This is the query JDV client executes.
SELECT A, B, C FROM AAA WHERE A = 1 LIMIT 10
Sometimes Teiid engine executes following query as DATA SRC COMMAND.
SELECT v_0.c_0, v_0.c_1, v0.c_2 FROM (SELECT A, B, C FROM AAA WHERE A = 1 LIMIT 10) AS v_0
The position of LIMIT phrase is changed. 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.