[teiid-issues] [JBoss JIRA] Commented: (TEIID-1566) More complex join: ORDER BY and LIMIT not pushed down
Mark Addleman (JIRA)
jira-events at lists.jboss.org
Sun Apr 24 11:54:18 EDT 2011
[ https://issues.jboss.org/browse/TEIID-1566?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12597706#comment-12597706 ]
Mark Addleman commented on TEIID-1566:
--------------------------------------
Last statemnet should read: I think there are two problems with the plan for this query: First, neither the ORDER BY nor the LIMIT clause are pushed down to DB2. However, event if it is wasn't pushed down, the plan should apply the ORDER & LIMIT before it tries to join to the notes table.
> More complex join: ORDER BY and LIMIT not pushed down
> ------------------------------------------------------
>
> Key: TEIID-1566
> URL: https://issues.jboss.org/browse/TEIID-1566
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Reporter: Mark Addleman
> Assignee: Steven Hawkins
>
> Query: SELECT B."SYSID", B."USERID", J0.APPNAME as "SYSOFUSER at APPNAME", B."NAME", B."PROC", B."SUSPEND", B."UID", (select count(*) from (select * from notes.RETRIEVE_NOTES where OBJECT_PKEY = xmlserialize(xmlelement("SECURITY.BASEUSER", XMLATTRIBUTES(B."SYSID",B."USERID")) as String)) as foo) as C_notesForObject, 'SECURITY.BASEUSER' as "__objecttype__" FROM "SECURITY.BASEUSER" as B left join security.sysinfo J0 on J0.sysid=B.sysid ORDER BY J0.APPNAME ASC LIMIT 9990,10; args: []
> I think there are two problems with the plan for this query: First, neither the ORDER BY nor the LIMIT clause are pushed down to DB2. However, if it is was pushed down, the plan should apply the ORDER & LIMIT before it tries to join to the notes table.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the teiid-issues
mailing list