[TORQUE-262] onUpdate="restrict" and onDelete="restrict" cause sql syntax error in MSSQL

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 4.0-beta1
• Fix Version/s: 4.0
• Component/s: Templates
• Assignee: Thomas Fox
• Reporter: Thomas Fox
• Created: 27/Jan/13 21:40
• Updated: 03/Mar/13 20:39
• Resolved: 27/Jan/13 21:49

Description

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.