[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1107) Add support for raising criteria if it has been pushed too far

Tue Jun 22 16:56:46 EDT 2010

     [ https://jira.jboss.org/browse/TEIID-1107?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Hawkins resolved TEIID-1107.
----------------------------------

    Resolution: Done

Adapted the fix added in 5.5.4.  In any raiseaccess run it will see if it can raise the access by moving parent selects.  This works well in most situations, except when criteria has been pushed through a non-removable view layer.  We'll see about covering that case (which may involve leaving phantom criteria nodes in place) if is comes up in practice.

> Add support for raising criteria if it has been pushed too far
> --------------------------------------------------------------
>
>                 Key: TEIID-1107
>                 URL: https://jira.jboss.org/browse/TEIID-1107
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 6.0.0
>            Reporter: Jerry Helbling
>            Assignee: Steven Hawkins
>            Priority: Minor
>             Fix For: 7.1
>
>
> Since a SELECT with criteria that includes a call to a Teiid function (for example formatDate) cannot be pushed down to a source, the aim of this modification is to move the SELECT so that it will not prevent other parts of the query from being pushed down.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira