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

    Details

    • Type: Enhancement
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 12.3
    • Fix Version/s: 12.3
    • Component/s: Query Engine
    • Labels:
      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

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                cjohn001 Christoph John
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: