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 16:26:17 GMT

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

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

I think it's fine to take that part out of CREATE TRIGGER statement. What is says now, is
correct at least for DROP TABLE. But not for DROP COLUMN. (Haven't checked other DROP statements.)
And the way it describes it is not how we would want the DROP operations to behave. So once
DERBY-2041 is fixed, we could add correct information to the CREATE TRIGGER topic. That correct
information would look like the text you initially proposed for the WHEN clause.

Or we could simply not mention it at all in CREATE TRIGGER, even after the bug is fixed, since
the behaviour then should be as documented in the various DROP statements. I think the main
reason why it is currently mentioned in CREATE TRIGGER, is that DROP statements currently
don't work as documented on dependent triggers. Once the behaviour is consistent for all dependent
objects, we might not need a special case for triggers in the docs.

And yes, +1 to keeping MODE DB2SQL in the syntax description, and to leaving it out of the
examples (for simplicity and for portability).

> 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-2.diff, DERBY-6390-2.zip, 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