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] Created: (DERBY-3220) <transition table or variable list> (ReferencingClause) in CREATE TRIGGER statement not SQL compliant
Date Wed, 21 Nov 2007 12:59:43 GMT
<transition table or variable list> (ReferencingClause) in CREATE TRIGGER statement not
SQL compliant
-----------------------------------------------------------------------------------------------------

                 Key: DERBY-3220
                 URL: https://issues.apache.org/jira/browse/DERBY-3220
             Project: Derby
          Issue Type: Bug
          Components: SQL
            Reporter: Bernt M. Johnsen
            Priority: Minor


Derby implements the following syntax:

REFERENCING
{
{ OLD | NEW } [ AS ] correlation-Name [ { OLD | NEW } [ AS ] correlation-Name ] | 
{ OLD_TABLE | NEW_TABLE } [ AS ] Identifier [ { OLD_TABLE | NEW_TABLE }
[AS] Identifier ] 
}

The SQL standard specifies:

<trigger definition> ::=
CREATE TRIGGER <trigger name> <trigger action time> <trigger event>
ON <table name> [ REFERENCING <transition table or variable list> ]
<triggered action>
.......
<transition table or variable> ::=
OLD [ ROW ] [ AS ] <old transition variable name>
| NEW [ ROW ] [ AS ] <new transition variable name>
| OLD TABLE [ AS ] <old transition table name>
| NEW TABLE [ AS ] <new transition table name>




-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message