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

        Thomas Fox created issue -
        Thomas Fox made changes -
        Field Original Value New Value
        Summary onUpdate="restrict" and onDelete="restrict" cause sql syntay error in MSSQL onUpdate="restrict" and onDelete="restrict" cause sql syntax error in MSSQL
        Thomas Fox made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Assignee Thomas Fox [ tfischer ]
        Resolution Fixed [ 1 ]
        Thomas Fox made changes -
        Status Resolved [ 5 ] Closed [ 6 ]

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development