Bug 780344 (SOA-2752)

Summary: Teiid should take care of salesforce query limits by itself
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Wanja Pernath <wpernath>
Component: EDSAssignee: Steven Hawkins <shawkins>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.1.0.ER6   
Target Milestone: ---   
Target Release: 5.1.0.ER7   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-2752
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Teiid 7.1.1 on EAP 5.1 with CXF
Last Closed: 2011-01-10 16:51:53 UTC Type: Feature Request
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Wanja Pernath 2011-01-06 21:33:01 UTC
project_key: SOA

Salesforce has a query string limit of 10.000 chars. When Teiid is calculating and executing a query like this:

SELECT Opportunity where AccountId in (a,b,c,d,e,f,g,h,i)

It could extend the 10.000 chars limit of Salesforce. Right now teiid just stops with an Exception. 


Expected behavior is to have teiid splitting up the condition into correct portions and to execute the above query n times to circumvent the limit:

SELECT Opportunity where AccountId in (a, b, c);
SELECT Opportunity where AccountId in (d, e, f);
SELECT Opportunity where AccountId in (g, h, i);

Comment 1 Van Halbert 2011-01-06 21:33:02 UTC
Link: Added: This issue Cloned from TEIID-1412


Comment 2 Van Halbert 2011-01-06 21:33:56 UTC
Security: Added: Public