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, tools, and much more.