Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-3948

Don't allow references to generated columns in the NEW transition variables of triggered actions of BEFORE triggers

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.5.1.1
    • Fix Version/s: 10.5.1.1
    • Component/s: SQL
    • Labels:
      None

      Description

      Thanks to Dag for finding this restriction in the SQL Standard, part 2, section 11.39, SR 12 c) I see this provision:

      12) If BEFORE is specified, then:
      :
      c) The <triggered action> shall not contain a <field reference> that
      references a field in the new transition variable corresponding to a
      generated column of T.

        Attachments

        1. derby-3948-01-aa-beforeTriggers.diff
          13 kB
          Richard N. Hillegas

          Issue Links

            Activity

              People

              • Assignee:
                rhillegas Richard N. Hillegas
                Reporter:
                rhillegas Richard N. Hillegas
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: