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

Teiid is attempting to push a string concat down.

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 7.1.1
    • 7.1.1
    • Query Engine
    • None
    • Hide

      Deploy the attached VDB and DS.

      Show
      Deploy the attached VDB and DS.
    • Workaround Exists
    • Hide

      Dived the SQL up as shown in Quote and GetQuote.

      Show
      Dived the SQL up as shown in Quote and GetQuote.

      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.

            Unassigned Unassigned
            rhn-engineering-jdoyle John Doyle
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: