Bug 780370 (SOA-2780)

Summary: Teiid is attempting to push a string concat down.
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: John Doyle <jdoyle>
Component: EDSAssignee: Van Halbert <vhalbert>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.1.0.ER6   
Target Milestone: ---   
Target Release: 5.1.0.CR1   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-2780
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-02-07 20:08:18 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Attachments:
Description Flags
YahooQuote.zip
none
StockQuote-ds.xml none

Description John Doyle 2011-01-14 18:10:30 UTC 
Steps to Reproduce: Deploy the attached VDB and DS.
Workaround: Workaround Exists
Workaround Description: Dived the SQL up as shown in Quote and GetQuote.
project_key: SOA

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.
Comment 1 John Doyle 2011-01-14 18:12:31 UTC 
Designer project archive and data source.
Comment 2 John Doyle 2011-01-14 18:12:31 UTC 
Attachment: Added: YahooQuote.zip
Attachment: Added: StockQuote-ds.xml
Comment 3 Van Halbert 2011-01-14 18:12:38 UTC 
Link: Added: This issue Cloned to SOA-2781
Comment 5 John Doyle 2011-02-07 20:08:18 UTC 
Validated with SOA-ER9