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

[John Doyle (JIRA)]

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

John Doyle commented on TEIID-1438:
-----------------------------------

I think this is likely to be a common pattern in non-SOAP HTTP service invocation, so it could show up often, so I would like to see it fixed for 7.1.1.  It does have a easy enough work-around though that could be release noted.

> 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