Uploaded image for project: 'SonarPLSQL'
  1. SonarPLSQL
  2. SONARPLSQL-730

DeleteOrUpdateWithoutWhereCheck should not raise issues on "ON DELETE" clauses

    XMLWordPrintable

    Details

    • Type: False-Positive
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.5
    • Component/s: Rules
    • Labels:
      None

      Description

      The implementation of RSPEC-1590 ("DELETE" and "UPDATE" statements should contain "WHERE" clauses) should not raise issues on ON DELETE clauses. That happens currently when some statements cannot be parsed correctly, but that creates issues which are obviously false positives, for example:

        ALTER TABLE t1
            ADD CONSTRAINT cons1 FOREIGN KEY (col1)
            REFERENCES t2 (col1)
            ON DELETE CASCADE ENABLE;
      

        Attachments

          Activity

            People

            Assignee:
            quentin.jaquier Quentin Jaquier
            Reporter:
            pierre-yves.nicolas Pierre-Yves Nicolas
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Due:
              Created:
              Updated:
              Resolved: