db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen (JIRA)" <j...@apache.org>
Subject [jira] Assigned: (DERBY-1770) Make "mode db2sql" an optional phrase in the "create trigger" statement
Date Thu, 09 Nov 2006 09:02:38 GMT
     [ http://issues.apache.org/jira/browse/DERBY-1770?page=all ]

Bernt M. Johnsen reassigned DERBY-1770:

    Assignee: Yip Ng  (was: Bernt M. Johnsen)

Since this will be fixed by DERBY-1953 and Yip is assigned to that one.

> Make "mode db2sql" an optional phrase in the "create trigger" statement
> -----------------------------------------------------------------------
>                 Key: DERBY-1770
>                 URL: http://issues.apache.org/jira/browse/DERBY-1770
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions:
>            Reporter: Rick Hillegas
>         Assigned To: Yip Ng
> In order to declare a trigger, you have to include the phrase "mode db2sql". This phrase
in non-ANSI--it does not turn up in the CREATE TRIGGER production from the ANSI spec, volume
2, section 11.39. It does turn up in the DB2 reference manual with the following explanation:
"This clause is used to specify the mode of triggers. This is the only valid mode currently
> This phrase should be made optional. This will strike a happy balance between our goals
of supporting the ANSI syntax while still maintaining compatibility with previous versions
of Derby.

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message