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

Details

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

    Description

      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

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: