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

    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.
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  phantomjinx Paul Richardson
                  Reporter:
                  blafond Barry LaFond
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: