Long lines rule and multi line text

plsql

(Ivo Bazant) #1

Rule “FORMAT - Avoid long lines” (plsql:LineLength) reports an issue when multi line string is used.
E.g.

sqlText := 'SELECT name, surname
   FROM party_schema.party_table
   WHERE valid=''Y''
     AND department_id = ' || to_char(department_id, '999990');

Sonar Qube version: 5.6.3


(Pierre-Yves Nicolas) #2

Hi,

We fixed this issue as part of SonarPLSQL 2.9: SONARPLSQL-538
I suppose that you’re using an old version of SonarPLSQL: you specified the version for SonarQube but not for SonarPLSQL.

Pierre-Yves


(Ivo Bazant) #3

Hi Pierre-Yves,

thanks, we have SonarPLSQL 2.8 so problem will be solved after upgrade.