[teiid-issues] [JBoss JIRA] Commented: (TEIID-1438) Teiid is attempting to push a string concat down.

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-1438?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12575760#comment-12575760 ] 

Steven Hawkins commented on TEIID-1438:
---------------------------------------

I know this has been fixed in 7.3 (because the pushdown check excludes procedures) but I'm not sure why it is failing as it should not see the concat parameter as needing evaluated.  Does this need addressed in 7.1.1?

> Teiid is attempting to push a string concat down.
> -------------------------------------------------
>
>                 Key: TEIID-1438
>                 URL: https://issues.jboss.org/browse/TEIID-1438
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.1.1
>            Reporter: John Doyle
>
> That attached VDB is invoking the yahoo quote service.  Invoking the BrokenQuote procedure like this:
> Exec VGetQuote.BrokenQuote('IBM');
>  results in the following exception:
> Remote org.teiid.api.exception.query.QueryPlannerException: Source command "EXEC GetQuote.invokeHttp('GET', null, concat('?f=snd1l1&s=', VGETQUOTE.BROKENQUOTE.Ticker))" contains non-pushdown constructs. 
> The GetQuote and Quote procedures divide the SQL from BrokenQuote into two procedures and does not produce the exception, but I don't see why BrokenQuote does not work.

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira