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

Empty error message in insert procedure transformation

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Minor
    • 9.0, 8.6.1, 9.0.1
    • 8.6
    • Transformations
    • None

    Description

      When creating a virtual insert procedure and omitting a non-nullable column from the insert, the error message is simply

      ERROR: ERROR

      E. g. I have a PUBLISHERS table with three columns, of which PUBLISHER_ID is NOT NULL, the insert procedure is

      FOR EACH ROW
      BEGIN ATOMIC
      	INSERT INTO Books.PUBLISHERS (Books.PUBLISHERS.NAME) VALUES ("NEW".NAME);
      END
      

      The error in previous versions of Designer for the same procedure would be

      ERROR: Element Books.PUBLISHERS.PUBLISHER_ID of books.publishers is neither nullable nor has a default value. A value must be specified in the insert.

      Attachments

        Activity

          People

            blafond Barry LaFond
            asmigala@redhat.com Andrej Smigala
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: