Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-1954

Syntactic error in INSERT SQL of relational view table which supports update

XMLWordPrintable

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

            Unassigned Unassigned
            lfabriko@redhat.com Lucie Krejcirova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: