Teiid engine moves the position of LIMIT phrase into a sub query

Solution Verified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content