Derby
  1. Derby
  2. DERBY-534

Support use of the WHEN clause in CREATE TRIGGER statements

    Details

    • Type: Improvement Improvement
    • Status: Resolved
    • Priority: Minor 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.

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

        Issue Links

          Activity

          Mamta A. Satoor made changes -
          Link This issue is related to DERBY-6783 [ DERBY-6783 ]
          Knut Anders Hatlen made changes -
          Status In Progress [ 3 ] Resolved [ 5 ]
          Fix Version/s 10.11.0.0 [ 12324243 ]
          Resolution Fixed [ 1 ]
          Knut Anders Hatlen made changes -
          Attachment derby-534-15-a-more-tests.diff [ 12613142 ]
          Knut Anders Hatlen made changes -
          Knut Anders Hatlen made changes -
          Attachment WhenClause.html [ 12609844 ]
          Knut Anders Hatlen made changes -
          Link This issue incorporates DERBY-6390 [ DERBY-6390 ]
          Knut Anders Hatlen made changes -
          Attachment derby-534-13-a-dblook.diff [ 12609649 ]
          Knut Anders Hatlen made changes -
          Attachment derby-534-12-a-subquery-npe.diff [ 12608497 ]
          Knut Anders Hatlen made changes -
          Attachment derby-534-11-a-more-tests.diff [ 12607997 ]
          Knut Anders Hatlen made changes -
          Attachment derby-534-10-a-get-sps.diff [ 12607824 ]
          Knut Anders Hatlen made changes -
          Attachment derby-534-09-b-drop-column-deps.diff [ 12607774 ]
          Knut Anders Hatlen made changes -
          Attachment derby-534-09-a-drop-column-deps.diff [ 12607560 ]
          Knut Anders Hatlen made changes -
          Link This issue is related to DERBY-2041 [ DERBY-2041 ]
          Knut Anders Hatlen made changes -
          Attachment derby-534-08-a-test-invalidation.diff [ 12606777 ]
          Knut Anders Hatlen made changes -
          Attachment derby-534-07-a-more-restrictions.diff [ 12606099 ]
          Attachment WhenClause.html [ 12606100 ]
          Knut Anders Hatlen made changes -
          Attachment derby-534-06-a-temptables.diff [ 12606068 ]
          Knut Anders Hatlen made changes -
          Link This issue is related to DERBY-6357 [ DERBY-6357 ]
          Knut Anders Hatlen made changes -
          Attachment derby-534-05-a-generated-cols.diff [ 12605458 ]
          Knut Anders Hatlen made changes -
          Attachment WhenClause.html [ 12605418 ]
          Knut Anders Hatlen made changes -
          Attachment derby-534-04-a-referencing.diff [ 12605281 ]
          Knut Anders Hatlen made changes -
          Attachment derby-534-03-a-npe-testcase.diff [ 12604762 ]
          Knut Anders Hatlen made changes -
          Attachment derby-534-02-a-refactor.diff [ 12604004 ]
          Knut Anders Hatlen made changes -
          Link This issue is related to DERBY-6348 [ DERBY-6348 ]
          Knut Anders Hatlen made changes -
          Issue & fix info Patch Available [ 10102 ]
          Knut Anders Hatlen made changes -
          Issue & fix info Patch Available [ 10102 ]
          Knut Anders Hatlen made changes -
          Attachment derby-534-01-a-syntax.diff [ 12603351 ]
          Knut Anders Hatlen made changes -
          Attachment WhenClause.html [ 12603000 ]
          Knut Anders Hatlen made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Knut Anders Hatlen made changes -
          Assignee Knut Anders Hatlen [ knutanders ]
          Knut Anders Hatlen made changes -
          Attachment parser.diff [ 12602349 ]
          Knut Anders Hatlen made changes -
          Attachment WhenClause.html [ 12602340 ]
          Gavin made changes -
          Workflow jira [ 12323745 ] Default workflow, editable Closed status [ 12799464 ]
          Mamta A. Satoor made changes -
          Labels derby_triage10_11
          Urgency Low [ 10053 ]
          Dag H. Wanvik made changes -
          Field Original Value New Value
          Issue Type New Feature [ 2 ] Improvement [ 4 ]
          Kristian Waagan created issue -

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development