-
Bug
-
Resolution: Won't Do
-
Major
-
None
-
8.3
-
None
-
None
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" ... ).