Torque
  1. Torque
  2. TORQUE-262

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

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor 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:
            Thomas Fox
            Reporter:
            Thomas Fox
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development