]
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: