Foreign keys accept the ON DELETE SET DEFAULT clause but do not enforce it
--------------------------------------------------------------------------
Key: DERBY-3968
URL: https://issues.apache.org/jira/browse/DERBY-3968
Project: Derby
Issue Type: Bug
Components: SQL
Affects Versions: 10.4.2.0, 10.5.0.0
Reporter: Rick Hillegas
The Derby Reference Guide does not document that you can declare a foreign key
with ON DELETE SET DEFAULT. However, Derby accepts this syntax. There are no
tests for this clause and it does not seem to work. A simple solution would be
to forbid this syntax. I will attach a test cast showing the problem.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
