[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-2207) Web Service Operation SQL valid in 8.3.2 but invalid in 8.5

Web Service Operation SQL valid in 8.3.2 but invalid in 8.5 ----------------------------------------------------------- Key: TEIIDDES-2207 URL: https://issues.jboss.org/browse/TEIIDDES-2207 Project: Teiid Designer Issue Type: Bug Security Level: Public(Everyone can see) Components: Validation, Web Services Support Affects Versions: 8.5 Reporter: Barry LaFond Assignee: Paul Richardson Priority: Critical Fix For: 8.6, 8.5.1 Attachments: testWebService.zip 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 {code} 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 {code} Same operation validated in 8.5 but results in validation error: {code} BEGIN DECLARE string VARIABLES.IN_exampleVar; VARIABLES.IN_exampleVar = xPathValue(null, '//*[local-name()="exampleName"]'); SELECT * FROM PRoductViews_Output_View.PRoductInfo_OutputView; END {code} ERROR {code} 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. {code}