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

Web Service Operation SQL valid in 8.3.2 but invalid in 8.5

    XMLWordPrintable

Details

    Description

      Compared creating WS from source and view models in 8.3.2 vs 8.5.

      See attached project set

      1) Created WS from ProductsOracle source and WS operations validated fine in 8.3.2 and 8.5 Designer
      2) Created WS from PRoductsViews view model and WS operations contained an error.

      Differences in the SQL for 8.5 vs 8.3.2 relate to the removing the CREATE VIRTUAL PROCEDURE in the SQL.

      8.3.2 SQL

      CREATE VIRTUAL PROCEDURE
BEGIN
	DECLARE string VARIABLES.IN_exampleVar;
	VARIABLES.IN_exampleVar = xPathValue(null, '//*[local-name()="exampleName"]');
	SELECT * FROM PRoductViews_Output_View.PRoductInfo_OutputView;
END

      Same operation validated in 8.5 but results in validation error:

      BEGIN
	DECLARE string VARIABLES.IN_exampleVar;
	VARIABLES.IN_exampleVar = xPathValue(null, '//*[local-name()="exampleName"]');
	SELECT * FROM PRoductViews_Output_View.PRoductInfo_OutputView;
END

      ERROR

      ERROR: TEIID30070 The function 'xPathValue(null, '//*[local-name()="exampleName"]')' is a valid function form, but the arguments do not match a known type signature and cannot be converted using implicit type conversions.

      Attachments

        Issue Links

          is blocked by

          Bug - A problem that impairs or prevents the functions of the product. TEIIDDES-2120 unable to reference same name .xsd when saving .vdb

          • Blocker - To be worked above all other priorities. This term is chosen when the severity of the issue is very high, has no workaround, or the effort for the change is comparatively low. Issues that may be very publicly visible and could generate significant media attention may also drive a higher priority.
          • Closed

          Activity

            People

              parichar@redhat.com Paul Richardson
              blafond Barry LaFond
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: