[jira] Closed: (DERBY-3121) The description of CONSTRAINT clause in reference manual seems to have error

["Kim Haase (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DERBY-3121?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kim Haase closed DERBY-3121.
----------------------------


Closing, since issue was resolved over a year ago.

> The description of CONSTRAINT clause in reference manual seems to have error
> ----------------------------------------------------------------------------
>
>                 Key: DERBY-3121
>                 URL: https://issues.apache.org/jira/browse/DERBY-3121
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>         Environment: http://db.apache.org/derby/docs/dev/ref/rrefsqlj13590.html
>            Reporter: Tomohito Nakayama
>            Assignee: Kim Haase
>             Fix For: 10.4.1.3
>
>         Attachments: DERBY-3121.diff, rrefsqlj13590.html
>
>
> Reading page of Reference manual for CONSTRAINT clause, I found
> questionable part in "Referential actions".
> http://db.apache.org/derby/docs/dev/ref/rrefsqlj13590.html
> Questionable part is as next.
> ==============
> The update rule applies when a row of either the parent or dependent
> table is updated. The choices are NO ACTION and RESTRICT.
> <snip>
> If the update rule is NO ACTION, Derby checks the dependent tables for
> foreign key constraints /after/ all deletes have been executed but
> /before/ triggers have been executed. If any row in a dependent table
> violates a foreign key constraint, the statement is rejected.
> <snip>
> The delete rule applies when a row of the parent table is deleted and
> that row has dependents in the dependent table of the referential
> constraint. If rows of the dependent table are deleted, the delete
> operation on the parent table is said to be /propagated/ to the
> dependent table. If the dependent table is also a parent table, the
> action specified applies, in turn, to its dependents.
> ==============
> What I'm not sure is next sentence in above.
> ==============
> If the update rule is NO ACTION, Derby checks the dependent tables for
> foreign key constraints */after/ all deletes* have been executed but
> /before/ triggers have been executed. If any row in a dependent table
> violates a foreign key constraint, the statement is rejected.
> ==============
> I'm not sure why is "after all deletes" for "update".
> I think this may be mistake .

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