db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Fox (JIRA)" <j...@apache.org>
Subject [jira] [Created] (TORQUE-262) onUpdate="restrict" and onDelete="restrict" cause sql syntay error in MSSQL
Date Sun, 27 Jan 2013 21:41:12 GMT
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: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message