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.

        Activity

        There are no comments yet on this issue.

          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:

              Development