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] [Resolved] (TORQUE-262) onUpdate="restrict" and onDelete="restrict" cause sql syntax error in MSSQL
Date Sun, 27 Jan 2013 21:51:12 GMT

     [ https://issues.apache.org/jira/browse/TORQUE-262?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Thomas Fox resolved TORQUE-262.
-------------------------------

    Resolution: Fixed
      Assignee: Thomas Fox
    
> onUpdate="restrict" and  onDelete="restrict" cause sql syntax 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
>            Assignee: 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