[
https://issues.apache.org/jira/browse/DERBY-6571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14007478#comment-14007478
]
Dag H. Wanvik commented on DERBY-6571:
--------------------------------------
Thanks, Kim! Comments:
- rrefsqljconstrchar.html
> The deferrability or checking time of a constraint cannot be altered.
The checking time can be changed by using SET CONSTRAINTS. It is the *default*
checking time that cannot be
altered. So maybe if we say "the ConstraintCheckTime" cannot be altered, we'd
be safe?
It is the *default* check time since at transaction end (commit or rollback)
the constraint mode reverts to ConstraintCheckTime.
- rrefsqljsetconstr.html
> The SET CONSTRAINTS statement allows you to set the constraint characteristic
> for one or more constraints either to DEFERRED or to IMMEDIATE.
This is slightly wrong (we changed the design). It should read: "The SET
CONSTRAINTS statement allows you to set the constraint mode for one or more
constraints either to DEFERRED or to IMMEDIATE." (i.e. "mode" instead of
"characteristics")
Last item, the change from "deferred" to "deferrable" (better use that always
and also specify "constraint mode deferred" or "constraint mode immediate"
depending on the case), as you already suggested.
Btw, did you include the material on XA and deferrable constraints anywhere?
> Document deferrable constraints
> -------------------------------
>
> Key: DERBY-6571
> URL: https://issues.apache.org/jira/browse/DERBY-6571
> Project: Derby
> Issue Type: Sub-task
> Components: Documentation
> Reporter: Dag H. Wanvik
> Assignee: Kim Haase
> Fix For: 10.11.0.0
>
> Attachments: DERBY-6571-2.diff, DERBY-6571-2.stat, DERBY-6571-2.zip,
> DERBY-6571-3.diff, DERBY-6571-3.stat, DERBY-6571-3.zip, DERBY-6571.diff,
> DERBY-6571.stat, DERBY-6571.zip
>
>
> The contents of functional specification attached to DERBY-532 should be
> included in the documentation.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
