Lucie Fabrikova created TEIIDDES-1954: ----------------------------------------- Summary: Syntactic error in INSERT SQL of relational view table which supports update Key: TEIIDDES-1954 URL: https://issues.jboss.org/browse/TEIIDDES-1954 Project: Teiid Designer Issue Type: Bug Affects Versions: 8.3 Environment: teiid designer 8.3.0.beta3, JBDS 7.1.0CR1, JBTools 4.1.3.Beta5, DV6 ER4 Reporter: Lucie Fabrikova Attachments: TwoSources.zip I have relational view model with table "UpdateParts", which has Supports Update option checked. The INSERT sql: FOR EACH ROW BEGIN ATOMIC INSERT INTO PartsOne.SUPPLIER_PARTS (SUPPLIER_ID, PART_ID, QUANTITY, SHIPPER_ID) VALUES ("INPUT".SUPPLIER_ID, "INPUT".PART_ID, "INPUT".QUANTITY, "INPUT".SHIPPER_ID); INSERT INTO PartsTwo.SHIP_VIA (SHIPPER_ID, SHIPPER_NAME) VALUES ("INPUT".SHIPPER_ID, "INPUT".SHIPPER_NAME); DECLARE integer VARIABLES.ROWS_UPDATED; VARIABLES.ROWS_UPDATED = VARIABLES.ROWCOUNT; END Generates ERROR: TEIID31119 Symbol "INPUT".SUPPLIER_ID is specified with an unknown group context Additionaly, an error from DELETE sql tab is showed under this error message (ERROR: TEIID31100 Parsing error: Encountered "; IF([*]HAS[*] CRITERIA ON" at line 4, column 12. Was expecting: "char" | "cast" | "convert" | "any" | "array_agg" | "case" | "exists" | "false" | "hour" | "insert" ... ). -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira