Bug 780370 (SOA-2780) - Teiid is attempting to push a string concat down.
Summary: Teiid is attempting to push a string concat down.
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-2780
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: EDS
Version: 5.1.0.ER6
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 5.1.0.CR1
Assignee: Van Halbert
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-01-14 18:10 UTC by John Doyle
Modified: 2011-02-07 20:08 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-02-07 20:08:18 UTC
Type: Bug


Attachments (Terms of Use)
YahooQuote.zip (10.42 KB, application/x-zip)
2011-01-14 18:12 UTC, John Doyle
no flags Details
StockQuote-ds.xml (481 bytes, text/xml)
2011-01-14 18:12 UTC, John Doyle
no flags Details


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SOA-2780 0 None Closed Teiid is attempting to push a string concat down. 2012-02-10 22:02:53 UTC
Red Hat Issue Tracker TEIID-1438 0 None Closed Teiid is attempting to push a string concat down. 2012-02-10 22:02:56 UTC

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


Note You need to log in before you can comment on or make changes to this bug.