False positive with schema name: Add a condition (plsql:S5141)

[Peter0 (Peter L.)]

This code

SELECT d.dummy
  INTO x
  FROM dual d
  JOIN sys.dual ON ( dual.dummy = d.dummy )
 WHERE d.dummy = 'X';

is flagged with

Add a condition for table ‘SYS.DUAL’ or remove this table from the SQL query.sonarlint(plsql:S5141)

There is a condition though, the schema (sys) is just not repeated in the join condition.

Language: Oracle PL/SQL
SonarQube 9.9.1

[gregory.paidis]

Hey,

I can confirm that this is a false positive.
I made a reproducer and created an issue in our dedicated backlog.

Thanks a lot for raising this!