Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-1412

Teiid should take care of salesforce query limits by itself

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Done
    • Major
    • 7.1.1, 7.3
    • 7.1.1, 7.2, 7.3
    • Salesforce Connector
    • None

    Description

      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);

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            wpernath_jira Wanja Pernath (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: