[OASIS Issue Tracker] Commented: (ODATA-173) Remove OnDelete element

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

    [ http://tools.oasis-open.org/issues/browse/ODATA-173?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=32071#action_32071 ] 

Ralf Handl commented on ODATA-173:
----------------------------------

There actually is s subtle difference between ON DELETE RESTRICT and ON DELETE NO ACTION, see http://www.dbforums.com/db2/1004451-delete-restrict-delete-no-action-clarification.html: 

Table T1 is a parent of table T3; delete rule as noted below.
Table T2 is a parent of table T3; delete rule CASCADE.

CREATE VIEW V1 AS SELECT * FROM T1 UNION ALL SELECT * FROM T2

DELETE FROM V1

If you do a DELETE that causes a CASCADE and a RESTRICT/NO ACTION to be fired...
 • In the case of RESTRICT it will fail if there are rows in the child table.
 • In the case of NO ACTION it will fail if there are rows that the CASCADE can't take care of in the child table.

My guess is that this distinction is too subtle to put it into OData.

> Remove OnDelete element
> -----------------------
>
>                 Key: ODATA-173
>                 URL: http://tools.oasis-open.org/issues/browse/ODATA-173
>             Project: OASIS Open Data Protocol (OData) TC
>          Issue Type: Improvement
>          Components: OData CSDL v1.0
>    Affects Versions: WD01
>            Reporter: Ralf Handl
>            Priority: Minor
>             Fix For: WD01
>
>
> The OnDelete element allows the server telling the client which action it will take on the current entity when a "leading" entity is deleted. Allowed action values are "Cascade" and "None".
> This list of actions is incomplete and not really useful for the client; using deltas is a better way to keep a local copy of data in sync with the server.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira