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

Support use of the WHEN clause in CREATE TRIGGER statements

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.11.1.1
    • Component/s: SQL
    • Urgency:
      Low

      Description

      Support use of the WHEN clause in CREATE TRIGGER statements. The clause is described in the SQL standard (2003) in chapter "11.39 <trigger definition>" under "<triggered action>".

      There are traces in the code that suggests some work has been done on this earlier. If anyone knows something about this, please add a comment to this issue.

        Attachments

        1. derby-534-01-a-syntax.diff
          20 kB
          Knut Anders Hatlen
        2. derby-534-02-a-refactor.diff
          5 kB
          Knut Anders Hatlen
        3. derby-534-03-a-npe-testcase.diff
          2 kB
          Knut Anders Hatlen
        4. derby-534-04-a-referencing.diff
          71 kB
          Knut Anders Hatlen
        5. derby-534-05-a-generated-cols.diff
          8 kB
          Knut Anders Hatlen
        6. derby-534-06-a-temptables.diff
          3 kB
          Knut Anders Hatlen
        7. derby-534-07-a-more-restrictions.diff
          14 kB
          Knut Anders Hatlen
        8. derby-534-08-a-test-invalidation.diff
          3 kB
          Knut Anders Hatlen
        9. derby-534-09-a-drop-column-deps.diff
          16 kB
          Knut Anders Hatlen
        10. derby-534-09-b-drop-column-deps.diff
          16 kB
          Knut Anders Hatlen
        11. derby-534-10-a-get-sps.diff
          11 kB
          Knut Anders Hatlen
        12. derby-534-11-a-more-tests.diff
          9 kB
          Knut Anders Hatlen
        13. derby-534-12-a-subquery-npe.diff
          5 kB
          Knut Anders Hatlen
        14. derby-534-13-a-dblook.diff
          26 kB
          Knut Anders Hatlen
        15. derby-534-14-a-remove-formatable-upgrade.diff
          12 kB
          Knut Anders Hatlen
        16. derby-534-15-a-more-tests.diff
          8 kB
          Knut Anders Hatlen
        17. parser.diff
          3 kB
          Knut Anders Hatlen
        18. WhenClause.html
          9 kB
          Knut Anders Hatlen
        19. WhenClause.html
          8 kB
          Knut Anders Hatlen
        20. WhenClause.html
          7 kB
          Knut Anders Hatlen
        21. WhenClause.html
          6 kB
          Knut Anders Hatlen
        22. WhenClause.html
          4 kB
          Knut Anders Hatlen

          Issue Links

            Activity

              People

              • Assignee:
                knutanders Knut Anders Hatlen
                Reporter:
                kristwaa Kristian Waagan
              • Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: