[teiid-issues] [JBoss JIRA] (TEIID-2568) Teiid Query Optimizer doesn't work properly with constants

[RAKESH BALGURI (JIRA)]

RAKESH BALGURI created TEIID-2568:
-------------------------------------

             Summary: Teiid Query Optimizer doesn't work properly with constants
                 Key: TEIID-2568
                 URL: https://issues.jboss.org/browse/TEIID-2568
             Project: Teiid
          Issue Type: Bug
         Environment: Windows and teiid 8.1
            Reporter: RAKESH BALGURI
            Assignee: Steven Hawkins
         Attachments: Query_Plan_SQL_1.txt, Query_Plan_SQL_2.txt

I have a SQL which contain constants in the Select clause and also it contains Group By, Order By and Limit clauses in the SQL.
When I execute the SQL, the Order By clause is not being pushed to the underlying translator. My translator doesn't support "SelectExpressions" i.e. supportsSelectExpression() returns false.
When I remove the constant from the Select clause then the Order By is pushed to the translator.
 
Is this a bug in Teiid's query Optimizer?
 
The following are the sample queries and attached are the Query Plans for both the SQL's.
 
Query1: This SQL doesn't push the Order By clause to the translator.
 
SELECT B.RESCLASS, COUNT(*) AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__" FROM
SECURITY.BASERULE AS B GROUP BY B.RESCLASS ORDER BY B.RESCLASS DESC LIMIT 22
 
Query2: This SQL pushes the Order By to the translator.
 
SELECT B.RESCLASS, COUNT(*) AS GROUPING_COUNT FROM
SECURITY.BASERULE AS B GROUP BY B.RESCLASS ORDER BY B.RESCLASS DESC LIMIT 22

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira