db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6390) Document the WHEN clause in the CREATE TRIGGER statement
Date Fri, 01 Nov 2013 10:29:18 GMT

    [ https://issues.apache.org/jira/browse/DERBY-6390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13811155#comment-13811155
] 

Knut Anders Hatlen commented on DERBY-6390:
-------------------------------------------

Thank you, Kim!

The devguide changes look good to me. Just some minor nits:

- The example of a trigger without a WHEN clause is terminated with a semicolon, whereas the
example with a WHEN clause isn't.

- In the old example (without a WHEN clause) we could probably remove the DB2ism "MODE DB2SQL"
now (it is only needed in 10.2 and earlier).

- It would be good to clarify in the description of the new example that the update of the
FlightAvailability table only happens if the triggering update actually changed the value
of FLIGHTS.FLIGHT_ID. (Maybe that was a silly example I came up with, by the way, since the
same could be achieved just as easily without a WHEN clause by declaring the trigger as AFTER
UPDATE OF flight_id ON flights. But it does show the syntax and what you can put into the
clause, so it's probably good enough.)

> Document the WHEN clause in the CREATE TRIGGER statement
> --------------------------------------------------------
>
>                 Key: DERBY-6390
>                 URL: https://issues.apache.org/jira/browse/DERBY-6390
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions: 10.11.0.0
>            Reporter: Knut Anders Hatlen
>            Assignee: Kim Haase
>         Attachments: DERBY-6390.diff, DERBY-6390.stat, DERBY-6390.zip
>
>
> The documentation should be updated with information about the WHEN clause that was added
to the CREATE TRIGGER statement in DERBY-534. The functional specification attached to that
issue has a list of topics that need updating.



--
This message was sent by Atlassian JIRA
(v6.1#6144)

Mime
View raw message