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

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