[
https://issues.jboss.org/browse/TEIID-2568?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-2568:
----------------------------------
Summary: Order by is omitted when projection is raised above ordering with
grouping (was: Teiid Query Optimizer doesn't work properly with constants)
Fix Version/s: 8.4.1
8.5
Priority: Critical (was: Major)
Affects Version/s: 7.7
Component/s: Query Engine
Order by is omitted when projection is raised above ordering with
grouping
--------------------------------------------------------------------------
Key: TEIID-2568
URL:
https://issues.jboss.org/browse/TEIID-2568
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.7
Environment: Windows and teiid 8.1
Reporter: RAKESH BALGURI
Assignee: Steven Hawkins
Priority: Critical
Fix For: 8.4.1, 8.5
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