Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-569

SQLXML type is imported as object

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 7.1.1
    • 7.1
    • Import/Export
    • None

    Description

      I imported the metadata for the INVOKE function from the weather example VDB. When I used the function in a transformation (see below), there was a validation error. Steve Hawkins noted the type of the result procedure parameter was "object" and should be "SQLXML". (Turns out that "SQLXML" is "XMLLiteral" in current Designer parlance. Perhaps that should be changed... Ask Steve H.)

      After several attempts to validate the SQL, it finally validated. (And another Jira is on the way.)

      SELECT
      t.*
      FROM
      (EXEC Wx_Teiid.invoke(binding = null, action = 'GET', request = null, endpoint = QUERYSTRING('', '38.99,-77.02 39.70,-104.80 47.6,-122.30' AS listLatLon, 'time-series' AS product, '2004-01-01T00:00:00' AS "begin", '2013-04-20T00:00:00' AS "end", 'maxt' AS maxt, 'mint' AS mint))) AS w, XMLTABLE('/dwml/data/location' PASSING result COLUMNS location_key string, lattitude string PATH 'point/@latitude', longitude string PATH 'point/@longitude') AS t

      Attachments

        Issue Links

          Activity

            People

              rhn-engineering-shawkins Steven Hawkins
              pnittel_jira Paul Nittel (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: