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

S3641 should not crash on redundant parentheses

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 3.4.1
    • Fix Version/s: 3.5
    • Component/s: Rules
    • Labels:
      None

      Description

      The implementation of RSPEC-3641 (Nullable subqueries should not be used in "NOT IN" conditions) should not crash when NOT IN uses a subquery with redundant parentheses. Example:

      SELECT c1 FROM t1
      WHERE c1 NOT IN ((SELECT c2 FROM t2));
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              amelie.renard Amélie Renard
              Reporter:
              pierre-yves.nicolas Pierre-Yves Nicolas
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Due:
                Created:
                Updated:
                Resolved: