Thomas Fox created TORQUE-262:
---------------------------------
Summary: onUpdate="restrict" and onDelete="restrict" cause sql
syntay error in MSSQL
Key: TORQUE-262
URL: https://issues.apache.org/jira/browse/TORQUE-262
Project: Torque
Issue Type: Bug
Components: Templates
Affects Versions: 4.0-beta1
Reporter: Thomas Fox
Priority: Minor
Fix For: 4.0
RESTRICT is unknown as foreign key action for MSSQL.
Semantically, restrict means that an error should be thrown by the database if
the foreign key is invalid.
This corresponds to the MSSQL action NO ACTION.
Thus, on delete="restrict" should be rendered in MSSQL's SQL as ON DELETE NO
ACTION.
Likewiese for onUpdate.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
