Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5794

GENERATED_KEY function in an input trigger results in validation error if used in presence of a compound primary key which consists of a mix of auto-increment and non-auto-increment variables

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Done
    • Icon: Major Major
    • 12.3
    • 12.3
    • Query Engine
    • None

      The issue refers to
      https://issues.jboss.org/browse/TEIID-5782 where if was found, that
      the GENERATED_KEY function does result in an validation error

      validation error: TEIID31119 Symbol key.fkProduct is specified with an unknown group context

      in an INSERT trigger when the view on which the insert is called has a compound primary key which consists of a mix of AUTO_INCREMENT and non-AUTO_INCREMENT variables.
      A code example can be found in the following comment

      https://issues.jboss.org/browse/TEIID-5782?focusedCommentId=13759345&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-13759345

              rhn-engineering-shawkins Steven Hawkins
              cjohn001 Christoph John (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: