Bug 780344 (SOA-2752) - Teiid should take care of salesforce query limits by itself
Summary: Teiid should take care of salesforce query limits by itself
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-2752
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.ER7
Assignee: Steven Hawkins
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-01-06 21:33 UTC by Wanja Pernath
Modified: 2011-01-10 16:51 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
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


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SOA-2752 0 None None None Never

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



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