rspec/rules/S3641/plsql/rule.adoc

== Why is this an issue?

A `WHERE` clause condition that uses `NOT IN` with a subquery will have unexpected results if that subquery returns `NULL`. On the other hand `NOT EXISTS` subqueries work reliably under the same conditions.

This rule raises an issue when `NOT IN` is used with a subquery where the selected column is nullable.

include::../../../shared_content/plsql/data_dictionary.adoc[]

include::../how.adoc[]

ifdef::env-github,rspecator-view[]

'''
== Implementation Specification
(visible only on this page)

include::../message.adoc[]

include::../highlighting.adoc[]

'''
== Comments And Links
(visible only on this page)

include::../comments-and-links.adoc[]

endif::env-github,rspecator-view[]
migrate rule descriptions to new education format 2023-05-03 11:06:20 +02:00			`== Why is this an issue?`

SONARPLSQL-805 S3921: Update RSPEC to mention data dictionary (#4544) 2024-11-27 14:11:29 +01:00			A `WHERE` clause condition that uses `NOT IN` with a subquery will have unexpected results if that subquery returns `NULL`. On the other hand `NOT EXISTS` subqueries work reliably under the same conditions.
Force linebreaks 2021-02-02 15:02:10 +01:00
SONARPLSQL-805 S3921: Update RSPEC to mention data dictionary (#4544) 2024-11-27 14:11:29 +01:00			This rule raises an issue when `NOT IN` is used with a subquery where the selected column is nullable.
Add rules 3000-3999 2020-06-30 12:48:39 +02:00
SONARPLSQL-805 S3921: Update RSPEC to mention data dictionary (#4544) 2024-11-27 14:11:29 +01:00			`include::../../../shared_content/plsql/data_dictionary.adoc[]`
Force linebreaks 2021-02-02 15:02:10 +01:00
SONARPLSQL-805 S3921: Update RSPEC to mention data dictionary (#4544) 2024-11-27 14:11:29 +01:00			`include::../how.adoc[]`
Export comments and rspec-to-rspec links from jira 2021-06-02 20:44:38 +02:00
Fix the comment display: rule-id, timestamp, GH visibility, link direction 2021-06-03 09:05:38 +02:00			`ifdef::env-github,rspecator-view[]`
RULEAPI-666: Migrate the "List of parameters", "Highlighting" and "Message" fields from jira RSPEC (#346) 2021-09-20 15:38:42 +02:00
			`'''`
			`== Implementation Specification`
			`(visible only on this page)`

			`include::../message.adoc[]`

			`include::../highlighting.adoc[]`

RULEAPI-576: add a horizontal rule between rule description and comments 2021-06-08 15:52:13 +02:00			`'''`
Export comments and rspec-to-rspec links from jira 2021-06-02 20:44:38 +02:00			`== Comments And Links`
			`(visible only on this page)`

			`include::../comments-and-links.adoc[]`
Make sure that includes are always surrounded by empty lines (#2270) When an include is not surrounded by empty lines, its content is inlined on the same line as the adjacent content. That can lead to broken tags and other display issues. This PR fixes all such includes and introduces a validation step that forbids introducing the same problem again. 2023-06-22 10:38:01 +02:00
Fix the comment display: rule-id, timestamp, GH visibility, link direction 2021-06-03 09:05:38 +02:00			`endif::env-github,rspecator-view[]`