Operations Editor does not correctly wrap user-entered SQL with CREATE... and END --------------------------------------------------------------------------------- Key: TEIIDDES-329 URL: https://issues.jboss.org/browse/TEIIDDES-329 Project: Teiid Designer Issue Type: Bug Affects Versions: 7.1.1 Environment: fedora 10, Designer build 3257 Reporter: Paul Nittel Assignee: Ted Jones Fix For: 7.4 I ran across this while running the E2E Updateable Web Service Test Script. After creating the Web Service interface and initial steps of creating the InsertProduct operation, I pasted in the SQL. When I validated the SQL, the Designer wrapped it, beginning with the CREATE, and ending with END. Unfortunately, the terminating END is placed immedately after the END in the pasted in text. The validation then fails when it reaches the new word, "ENDEND". (the user needs to separate the "ENDEND" into "END END" and it will parse correctly. The error message is: The query is not parsable. Parsing error: Encountered "<EOF>" at line 1, column 464. Was expecting: "=" ... The SQL winds up being: CREATE VIRTUAL PROCEDURE BEGIN DECLARE string VARIABLES.IN_ID = xpathvalue(ProductsWebSvc.ProdInterface.DeleteProduct.ProductIdIn, '/*:InstrIdInput/*:ID'); DECLARE integer VARIABLES.delete_count = 0; VARIABLES.DELETE_COUNT = DELETE FROM Updates.UpdateProduct WHERE Updates.UpdateProduct.INSTR_ID = VARIABLES.IN_ID; IF(VARIABLES.DELETE_COUNT = 1) BEGIN SELECT * FROM ProductDoc.goodResultsDocument; END ELSE BEGIN SELECT * FROM ProductDoc.badResultsDocument; ENDEND