Consider the query: select * from Some_Table where some_column not in (select nullable_column from Other_Table) If the subquery has a column with null in there, this where always evaluates in either false or null, so the whole query never returns a result. For the technical reason why, see (for e…

SQL query that uses not in with a subquery

Rules and Languages New rules / language support

Alexandre_Gigleux (Alexandre Gigleux) August 29, 2018, 3:05pm 2

Hello Matty,

Thanks for suggesting this rule. I agree with you and I created this specification: https://jira.sonarsource.com/browse/RSPEC-3641 and the related implementation tickets for T-SQL and PL/SQL:

https://jira.sonarsource.com/browse/SONARTSQL-140
https://jira.sonarsource.com/browse/SONARPLSQL-702

Regards

2 Likes

Topic		Replies	Views
T-SQL Plugin - rule for EXISTS / NOT EXISTS New rules / language support tsql	1	1144	August 29, 2018
plsql:S3651 False positive for left JOINs Report False-positive / False-negative... plsql	1	275	February 16, 2024
New SQL Rule - nonSargable queries - performance New rules / language support tsql	0	580	December 23, 2021
Extend Rule RSPEC-1590 New rules / language support plsql , tsql	2	868	February 6, 2019
Rule plsql:S131 concerns only PL/SQL code not SQL but hit in the both cases New rules / language support plsql	10	1489	January 18, 2021

SQL query that uses not in with a subquery

Related topics