db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yip Ng (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1953) Make FOR EACH clause and MODE DB2SQL in CREATE TRIGGER statement optional
Date Wed, 11 Oct 2006 16:35:36 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1953?page=comments#action_12441491 ] 
Yip Ng commented on DERBY-1953:

Originally, I had MODE DB2SQL to be independent but there is a testcase in db2Compatibility.sql
that expects failure when the MODE DB2SQL is specified without the FOR EACH part.  That was
why I retain the failure with
the current syntax.  But after going through the most recent DB2 documentation, it appears
that MODE DB2SQL can be optional and independent as well.  So I am going to make the correction
and change to what Bernt suggested.  The syntax is now:

<triggered action> ::=
     [ MODE DB2SQL ]
     <triggered SQL statement>

Need to rerun derbyall.  =)

> Make FOR EACH clause and MODE DB2SQL in CREATE TRIGGER statement optional
> -------------------------------------------------------------------------
>                 Key: DERBY-1953
>                 URL: http://issues.apache.org/jira/browse/DERBY-1953
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions:
>         Environment: Any
>            Reporter: Yip Ng
>         Assigned To: Yip Ng
>            Priority: Minor
>         Attachments: derby1953-trunk-diff01.txt, derby1953-trunk-diff02.txt, derby1953-trunk-stat01.txt,
> According to SQL:2003 standard, section 11.39 <trigger definition>, under Syntax
Rules item 8:
> If neither FOR EACH ROW nor FOR EACH STATEMENT is specified, then FOR EACH STATEMENT
is implicit.

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