[
https://issues.apache.org/jira/browse/DERBY-3220?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12544789
]
thomanie edited comment on DERBY-3220 at 11/22/07 4:23 AM:
-----------------------------------------------------------------
Smart move to change the existing tests for the NEW TABLE and OLD TABLE syntax,
but keeping the NEW_TABLE and OLD_TABLE in DB2 compliant mode :)
Both DERBY-3220-2.diff and doc patch DERBY-3220-doc-2.diff looks good.
Running suitesAll now, but don't expect any problems due to this change.
was (Author: thomanie):
Smart move to change the existing tests for the NEW TABLE and OLD TABLE
syntax, but keeping the NEW_TABLE and OLD_TABLE in DB2 compliant mode :)
Small fix needed to DERBY-3220-2.diff:
- java/engine/org/apache/derby/impl/sql/compile/CreateTriggerNode.java but
touches one line, but no code change.
Doc path DERBY-3220-doc-2.diff looks good.
Running suitesAll now, but don't expect any problems due to this change.
> <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
> Assignee: Bernt M. Johnsen
> Priority: Minor
> Attachments: DERBY-3220-2.diff, DERBY-3220-doc-2.diff,
> DERBY-3220-doc.diff, DERBY-3220.diff
>
>
> 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.
