Uploaded image for project: 'Torque'
  1. Torque
  2. TORQUE-262

onUpdate="restrict" and onDelete="restrict" cause sql syntax error in MSSQL

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 4.0-beta1
    • Fix Version/s: 4.0
    • Component/s: Templates
    • Labels:
      None

      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.

        Attachments

          Activity

            People

            • Assignee:
              tfischer Thomas Fox
              Reporter:
              tfischer Thomas Fox
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: