PL/SQL scan does not detect error when code contains "is json" instruction

SebG · February 21, 2025, 1:21pm

Versions: Developer Edition v2025.1 (102418) [ACTIVE] Standard Experience
SonarQube deployed: zip
Problem was detected in VS code IDE with sonarlint and when project is scaned by SonarQube server.

Hello,
When the PL/SQL code contains a test to check if a clob variable is a json format the sonarqube does not detect anymore issues in code

To reproduce:
Dummy Code having 2 issues:

declare
   l_clob clob;
   l_dummy integer;
begin
   return;
   if l_clob is not null then
      null;
   end if;
end;
/

Result:

[{
	"resource": "pkg_dummy.sql",
	"owner": "sonarlint",
	"code": "plsql:S1481",
	"severity": 4,
	"message": "Remove the unused local variable "l_dummy".",
	"source": "sonarqube",
	"startLineNumber": 3,
	"startColumn": 4,
	"endLineNumber": 3,
	"endColumn": 11
},{
	"resource": "pkg_dummy.sql",
	"owner": "sonarlint",
	"code": "plsql:DeadCodeCheck",
	"severity": 4,
	"message": "Refactor this piece of code to not have any dead code after "return". [+1 location]",
	"source": "sonarqube",
	"startLineNumber": 6,
	"startColumn": 4,
	"endLineNumber": 8,
	"endColumn": 11
}]

Same code with additional test to check if l_clob is a json format

declare
   l_clob clob;
   l_dummy integer;
begin
   -- Add below if statement breaking sonarqube scan
   if l_clob is json then
      null;
   end if;
   return;
   if l_clob is not null then
      null;
   end if;
end;
/

No more issue reported by Sonarlint in VS Code.

Complementary information:

Statement “if variable is json then” compiles and works well
Same when replacing if by a case

thanks in advance for your help…

sebastien.marichal · February 24, 2025, 10:50am

Hello @SebG,

It seems that our analyzer is having a parsing error related to the is json part of the snippet.
Would you be able to confirm that it is the same on your side?
You should be able to see the following warnings in your analysis logs:

10:42:30.563 WARN  
10:42:30.563 WARN  Unable to fully parse: /usr/src/snippet.sql
10:42:30.563 WARN  Parse error starting from line 1
10:42:30.563 WARN
10:42:30.573 WARN
10:42:30.573 WARN  Unable to fully parse: /usr/src/snippet.sql
10:42:30.573 WARN  Parse error starting from line 4
10:42:30.573 WARN

I am not familiar with this syntax, would you be able to point me to the documentation about this syntax?
It would help a lot to resolve the parsing error.

Thank you,

SebG · February 24, 2025, 1:34pm

Hello @sebastien.marichal ,

I did not find the warning lines in analysis log.
Here is what I had:

[Debug - 14:22:55.402] [sonarlint : sonarlint-analysis-engine] Language of file "file:///v:/test/test.sql" is set to "PLSQL"
[Debug - 14:22:55.402] [sonarlint : sonarlint-analysis-engine] Module file event for [uri=file:///v:/test/test.sql] has been ignored because it's not a Python file.
[Info - 14:22:55.402] [sonarlint : sonarlint-analysis-engine] Module file event for MODIFIED for file [uri=file:///v:/test/test.sql] has been ignored because it's not a Kubernetes file.
[Debug - 14:22:55.402] [sonarlint : sonarlint-analysis-engine] Processing file event v:/test/test.sql with event MODIFIED
[Debug - 14:22:55.402] [sonarlint : sonarlint-file-exclusions] Computing file exclusion for uri 'file:///v:/test/test.sql'
[Debug - 14:22:55.404] [sonarlint : sonarlint-file-exclusions] File exclusion for uri 'file:///v:/test/test.sql' is false
[Debug - 14:22:55.405] [sonarlint : SonarLint Analysis Executor] isReadyForAnalysis(connectionId: https-sonarqube-inst-com, sonarProjectKey: VSC, plugins: true, analyzer config: true, findings: true) => true
[Debug - 14:22:55.408] [sonarlint : SonarLint Analysis Executor]   * kubernetes: 21 active rules
[Debug - 14:22:55.409] [sonarlint : SonarLint Analysis Executor]   * cpp: 450 active rules
[Debug - 14:22:55.410] [sonarlint : SonarLint Analysis Executor] Rule cpp:S5527 is enabled on the server, but not available in SonarLint
[Debug - 14:22:55.411] [sonarlint : SonarLint Analysis Executor] Rule cpp:S4830 is enabled on the server, but not available in SonarLint
[Debug - 14:22:55.411] [sonarlint : SonarLint Analysis Executor]   * css: 24 active rules
[Debug - 14:22:55.411] [sonarlint : SonarLint Analysis Executor]   * c: 210 active rules
[Debug - 14:22:55.412] [sonarlint : SonarLint Analysis Executor] Rule c:S4830 is enabled on the server, but not available in SonarLint
[Debug - 14:22:55.413] [sonarlint : SonarLint Analysis Executor] Rule c:S5527 is enabled on the server, but not available in SonarLint
[Debug - 14:22:55.414] [sonarlint : SonarLint Server RPC request executor] GET 200 https://sonarqube.inst.com/api/system/status | response time=12ms
[Debug - 14:22:55.414] [sonarlint : SonarLint Analysis Executor]   * go: 25 active rules
[Debug - 14:22:55.414] [sonarlint : SonarLint Server RPC request executor] Downloaded server infos in 12ms
[Debug - 14:22:55.414] [sonarlint : SonarLint Analysis Executor] Rule go:S1313 is enabled on the server, but not available in SonarLint
[Debug - 14:22:55.414] [sonarlint : SonarLint Analysis Executor] Rule go:S2068 is enabled on the server, but not available in SonarLint
[Debug - 14:22:55.414] [sonarlint : SonarLint Analysis Executor] Rule go:ParsingError is enabled on the server, but not available in SonarLint
[Debug - 14:22:55.414] [sonarlint : SonarLint Analysis Executor]   * js: 135 active rules
[Debug - 14:22:55.415] [sonarlint : SonarLint Analysis Executor] Rule common-js:DuplicatedBlocks is enabled on the server, but not available in SonarLint
[Debug - 14:22:55.419] [sonarlint : SonarLint Analysis Executor]   * py: 144 active rules
[Debug - 14:22:55.419] [sonarlint : SonarLint Analysis Executor] Rule pythonsecurity:S2091 is enabled on the server, but not available in SonarLint
...
[Debug - 14:22:55.421] [sonarlint : SonarLint Analysis Executor] Rule pythonsecurity:S5145 is enabled on the server, but not available in SonarLint
[Debug - 14:22:55.422] [sonarlint : SonarLint Analysis Executor]   * tsql: 59 active rules
[Debug - 14:22:55.422] [sonarlint : SonarLint Analysis Executor]   * secrets: 121 active rules
[Debug - 14:22:55.422] [sonarlint : SonarLint Analysis Executor]   * ansible: 16 active rules
[Debug - 14:22:55.423] [sonarlint : SonarLint Analysis Executor]   * docker: 40 active rules
[Debug - 14:22:55.425] [sonarlint : SonarLint Analysis Executor]   * plsql: 133 active rules
[Debug - 14:22:55.425] [sonarlint : SonarLint Analysis Executor]   * cs: 363 active rules
[Debug - 14:22:55.425] [sonarlint : SonarLint Analysis Executor] Rule roslyn.sonaranalyzer.security.cs:S6639 is enabled on the server, but not available in SonarLint
[Debug - 14:22:55.425] [sonarlint : SonarLint Analysis Executor] Rule roslyn.sonaranalyzer.security.cs:S7044 is enabled on the server, but not available in SonarLint
ebug - 14:22:55.428] [sonarlint : SonarLint Analysis Executor] Rule roslyn.sonaranalyzer.security.cs:S5135 is enabled on the server, but not available in SonarLint
[Debug - 14:22:55.428] [sonarlint : SonarLint Analysis Executor]   * java: 548 active rules
[Debug - 14:22:55.428] [sonarlint : SonarLint Analysis Executor] Rule javasecurity:S7044 is enabled on the server, but not available in SonarLint
...
[Debug - 14:22:55.433] [sonarlint : SonarLint Analysis Executor] Rule javasecurity:S6096 is enabled on the server, but not available in SonarLint
[Debug - 14:22:55.433] [sonarlint : SonarLint Analysis Executor]   * web: 49 active rules
[Debug - 14:22:55.433] [sonarlint : SonarLint Analysis Executor]   * xml: 23 active rules
[Debug - 14:22:55.434] [sonarlint : SonarLint Analysis Executor]   * json: 0 active rules
[Debug - 14:22:55.434] [sonarlint : SonarLint Analysis Executor]   * php: 196 active rules
[Debug - 14:22:55.434] [sonarlint : SonarLint Analysis Executor] Rule phpsecurity:S2083 is enabled on the server, but not available in SonarLint
...
[Debug - 14:22:55.436] [sonarlint : SonarLint Analysis Executor] Rule phpsecurity:S7044 is enabled on the server, but not available in SonarLint
[Debug - 14:22:55.437] [sonarlint : SonarLint Analysis Executor]   * terraform: 48 active rules
[Debug - 14:22:55.442] [sonarlint : SonarLint Analysis Executor]   * azureresourcemanager: 31 active rules
[Debug - 14:22:55.443] [sonarlint : SonarLint Analysis Executor]   * cloudformation: 26 active rules
[Debug - 14:22:55.446] [sonarlint : SonarLint Analysis Executor]   * ts: 113 active rules
[Debug - 14:22:55.446] [sonarlint : SonarLint Analysis Executor] Rule parameter 'credentialWords' for rule 'typescript:S2068' does not exist in embedded analyzer, ignoring.
[Debug - 14:22:55.446] [sonarlint : SonarLint Analysis Executor] Rule typescript:S2814 is enabled on the server, but not available in SonarLint
[Debug - 14:22:55.446] [sonarlint : SonarLint Analysis Executor]   * yaml: 0 active rules
[Info - 14:22:55.453] [sonarlint : SonarLint Analysis Executor] Git Repository not found for v:\test. The path v:\test is not in a Git repository
[Info - 14:22:55.454] [sonarlint : SonarLint Analysis Executor] Triggering analysis with configuration: [
  baseDir: v:\test
  extraProperties: {sonar.updatecenter.cache.ttl=3600000, sonaranalyzer-cs.nuget.packageVersion=10.4.0.108396, sonaranalyzer.security.cs.pluginVersion=10.11.0.34915, sonar.auth.bitbucket.allowUsersToSignUp=true, sonar.cs.ignoreHeaderComments=true, sonar.issue.ignore.multicriteria=1,2,3,4,5,6,7,8,9, sonar.c.file.suffixes=.c,.h, sonar.typescript.file.suffixes=.ts,.tsx,.cts,.mts, sonar.auth.github.enabled=false, sonar.python.coverage.reportPaths=.reports/coverage.xml, sonar.issue.ignore.multicriteria.2.resourceKey=RBAT*, sonar.text.activate=true, sonaranalyzer-vbnet.nuget.packageVersion=10.4.0.108396, provisioning.gitlab.enabled=false, sonar.go.file.suffixes=.go, sonar.issue.ignore.multicriteria.1.resourceKey=*RPKG*, sonar.issue.ignore.multicriteria.4.resourceKey=*AS_ZIP.SQL, sonar.cs.analyzeRazorCode=true, sonar.auth.saml.applicationId=sonarqube, sonar.issue.ignore.multicriteria.3.resourceKey=*as_zip.sql, sonar.issue.ignore.multicriteria.7.resourceKey=*pkg_role.sql, sonar.python.xunit.skipDetails=false, sonar.ipynb.file.suffixes=ipynb, sonar.issue.ignore.multicriteria.6.resourceKey=*pkg_role.sql, sonar.dbcleaner.weeksBeforeKeepingOnlyAnalysesWithVersion=4, sonar.plsql.jdbc.driver.class=oracle.jdbc.OracleDriver, sonar.qualitygate.ignoreSmallChanges=true, sonar.issue.ignore.multicriteria.5.resourceKey=*pkg_role.sql, sonar.cpd.exclusions=*T*PKG*,*t*pkg*, sonar.auth.saml.signature.enabled=false, sonar.autodetect.ai.code=true, sonar.go.exclusions=**/vendor/**, sonar.php.exclusions=**/vendor/**, sonar.issue.ignore.allfile=1, sonar.js.internal.bundlePath=c:\Users\seg\.vscode\extensions\sonarsource.sonarlint-vscode-4.16.0-win32-x64\eslint-bridge, sonar.terraform.file.suffixes=.tf, sonar.forceAuthentication=false, sonar.issue.ignore.multicriteria.8.resourceKey=*LPKG*, sonar.notifications.delay=60, sonar.cpp.file.suffixes=.cc,.cpp,.cxx,.c++,.hh,.hpp,.hxx,.h++,.ipp,.ixx,.mxx,.cppm,.ccm,.cxxm,.c++m, sonar.swift.file.suffixes=.swift, sonar.vbnet.roslyn.ignoreIssues=false, sonar.plsql.ignoreHeaderComments=false, sonar.flex.file.suffixes=as, sonar.issue.ignore.multicriteria.9.resourceKey=*LPKG*, sonar.multi-quality-mode.enabled=false, sonar.lf.logoUrl=https://sonarqube.inst.com/images/inst_logo.png, sonaranalyzer.security.cs.nuget.packageVersion=10.11.0.34915, sonar.filesize.limit=20, sonar.auth.gitlab.groupsSync=false, sonar.auth.github.apiUrl=https://api.github.com/, sonar.ruby.file.suffixes=.rb, sonaranalyzer-cs.ruleNamespace=SonarAnalyzer.Enterprise.CSharp, sonar.auth.github.allowUsersToSignUp=true, sonar.issue.ignore.multicriteria.4.ruleKey=plsql:*, sonar.cs.analyzeGeneratedCode=false, sonar.azureresourcemanager.file.identifier=https://schema.management.azure.com/schemas/,http://schema.management.azure.com/schemas/, sonar.python.xunit.reportPath=.reports/pytest-results.xml, sonar.java.jvmframeworkconfig.file.patterns=**/src/main/resources/**/*app*.properties,**/src/main/resources/**/*app*.yaml,**/src/main/resources/**/*app*.yml, sonar.builtInQualityProfiles.disableNotificationOnUpdate=false, sonar.javascript.globals=angular,goog,google,OpenLayers,d3,dojo,dojox,dijit,Backbone,moment,casper,_,sap, sonar.dbcleaner.hoursBeforeKeepingOnlyOneSnapshotByDay=24, sonar.yaml.file.suffixes=.yaml,.yml, sonar.dbcleaner.daysBeforeDeletingInactiveBranchesAndPRs=30, sonar.auth.bitbucket.enabled=false, sonar.terraform.activate=true, sonar.css.file.suffixes=.css,.less,.scss,.sass, sonar.cpd.abap.minimumTokens=100, sonar.docker.file.patterns=Dockerfile,*.dockerfile, sonar.auth.github.webUrl=https://github.com/, sonar.dbcleaner.branchesToKeepWhenInactive=master,develop,trunk,branch-.*,release-.*, sonar.html.file.suffixes=.html,.xhtml,.cshtml,.vbhtml,.aspx,.ascx,.rhtml,.erb,.shtm,.shtml,.cmp,.twig, sonaranalyzer-vbnet.nuget.packageId=SonarAnalyzer.Enterprise.VisualBasic, sonar.php.frameworkDetection=true, sonar.auth.gitlab.enabled=false, sonar.issue.ignore.multicriteria.8.ruleKey=plsql:JoinConditionNumberCheck, sonar.cpd.cross_project=false, sonar.cs.analyzer.dotnet.pluginVersion=10.4.0.108396, sonaranalyzer-vbnet.pluginVersion=10.4.0.108396, sonar.vbnet.ignoreHeaderComments=true, sonar.cfamily.compile-commands=, sonaranalyzer.security.cs.analyzerId=SonarAnalyzer.Security, sonaranalyzer.security.cs.nuget.packageId=SonarAnalyzer.Security, sonar.python.flake8.reportPaths=.reports/flake8-report.txt, sonar.auth.github.groupsSync=false, sonar.dbcleaner.weeksBeforeKeepingOnlyOneSnapshotByWeek=4, sonar.vbnet.analyzer.dotnet.pluginKey=vbnetenterprise, sonaranalyzer-vbnet.analyzerId=SonarAnalyzer.Enterprise.VisualBasic, sonar.scala.file.suffixes=.scala, sonar.issue.ignore.multicriteria.5.ruleKey=plsql:PlSql.FunctionAndProcedureNaming, sonar.cs.roslyn.ignoreIssues=false, sonar.cloudformation.activate=true, sonaranalyzer-cs.pluginKey=csharpenterprise, sonar.kubernetes.activate=true, sonar.issue.ignore.multicriteria.1.ruleKey=plsql:JoinConditionNumberCheck, sonar.java.ignoreUnnamedModuleForSplitPackage=False, sonar.vbnet.analyzer.dotnet.staticResourceName=SonarAnalyzer-vbnetenterprise-10.4.0.108396.zip, sonar.json.file.suffixes=.json, sonaranalyzer.security.cs.pluginKey=securitycsharpfrontend, sonaranalyzer-vbnet.ruleNamespace=SonarAnalyzer.Enterprise.VisualBasic, sonar.cloudformation.file.identifier=AWSTemplateFormatVersion, sonar.auth.saml.providerName=SAML, provisioning.github.project.visibility.enabled=true, sonar.dbcleaner.daysBeforeDeletingAnticipatedTransitions=30, sonar.javascript.ignoreHeaderComments=true, sonar.dbcleaner.daysBeforeDeletingClosedIssues=30, sonar.java.enablePreview=False, sonar.dbcleaner.weeksBeforeKeepingOnlyOneSnapshotByMonth=2, sonar.lf.gravatarServerUrl=https://secure.gravatar.com/avatar/{EMAIL_MD5}.jpg?s={SIZE}&d=identicon, sonar.core.serverBaseURL=https://sonarqube.inst.com/, sonar.objc.file.suffixes=.m, sonar.issue.ignore.multicriteria.9.ruleKey=plsql:PlSql.FunctionAndProcedureExcessiveParameters, sonar.text.inclusions=**/*.sh,**/*.bash,**/*.zsh,**/*.ksh,**/*.ps1,**/*.properties,**/*.conf,**/*.pem,**/*.config,.env,.aws/config, sonar.ruby.coverage.reportPaths=coverage/.resultset.json, sonar.coverage.exclusions=**/*.sql,**/*.SQL,**/*.Sql,tests/**,setup.py, sonar.issue.ignore.multicriteria.6.ruleKey=plsql:PreferExecuteImmediateToDbmsSqlCheck, sonar.qualityProfiles.allowDisableInheritedRules=false, sonaranalyzer-cs.staticResourceName=SonarAnalyzer-csharpenterprise-10.4.0.108396.zip, sonar.notifications.runningDelayBeforeReportingStatus=600, sonar.auth.gitlab.allowUsersToSignUp=true, sonar.issue.ignore.multicriteria.2.ruleKey=plsql:DbmsOutputPutLineCallCheck, sonar.projectCreation.mainBranchName=master, sonar.jsp.file.suffixes=.jsp,.jspf,.jspx, sonar.cs.analyzer.dotnet.staticResourceName=SonarAnalyzer-csharpenterprise-10.4.0.108396.zip, sonar.javascript.maxFileSize=1000, sonaranalyzer-cs.nuget.packageId=SonarAnalyzer.Enterprise.CSharp, sonar.javascript.environments=amd,applescript,atomtest,browser,commonjs,embertest,greasemonkey,jasmine,jest,jquery,meteor,mocha,mongo,nashorn,node,phantomjs,prototypejs,protractor,qunit,serviceworker,shared-node-browser,shelljs,webextensions,worker, sonar.authenticator.downcase=false, sonar.scm.disabled=true, sonar.ruby.exclusions=**/vendor/**, sonar.dart.file.suffixes=.dart, sonar.ansible.activate=true, sonar.auth.saml.enabled=false, sonar.vbnet.file.suffixes=.vb, sonaranalyzer-cs.analyzerId=SonarAnalyzer.Enterprise.CSharp, sonar.issue.ignore.allfile.1.fileRegexp=/^create.*tpkg/gmi, sonar.core.id=69DC34BE-18d3aeff518715b, sonar.cs.analyzer.dotnet.pluginKey=csharpenterprise, sonar.cfamily.generateComputedConfig=false, sonar.abap.file.suffixes=.abap,.ab4,.flow,.asprog, sonar.cfamily.ignoreHeaderComments=true, sonar.technicalDebt.ratingGrid=0.05,0.1,0.2,0.5, sonar.vbnet.analyzer.dotnet.pluginVersion=10.4.0.108396, sonar.technicalDebt.developmentCost=30, sonar.lf.enableGravatar=true, sonar.validateWebhooks=true, sonar.docker.activate=true, sonar.python.file.suffixes=py, sonaranalyzer-cs.pluginVersion=10.4.0.108396, sonaranalyzer.security.cs.staticResourceName=SonarAnalyzer.Security-10.11.0.34915.zip, sonar.cs.file.suffixes=cs, sonar.developerAggregatedInfo.disabled=false, sonar.plsql.file.suffixes=sql,pks,pkb, sonaranalyzer.security.cs.ruleNamespace=SonarAnalyzer.Security, sonar.plugins.downloadOnlyRequired=true, sonar.azureresourcemanager.file.suffixes=.bicep, sonar.javascript.file.suffixes=.js,.jsx,.cjs,.mjs,.vue, sonar.cpd.abap.minimumLines=20, sonar.issue.ignore.multicriteria.7.ruleKey=plsql:DbmsOutputPutLineCallCheck, sonar.allowPermissionManagementForProjectAdmins=true, sonar.text.inclusions.activate=true, sonaranalyzer-vbnet.staticResourceName=SonarAnalyzer-vbnetenterprise-10.4.0.108396.zip, sonar.vbnet.analyzeGeneratedCode=false, sonar.java.file.suffixes=.java,.jav, sonar.python.pylint.reportPaths=.reports/pylint-report.txt, sonar.kotlin.file.suffixes=.kt,.kts, sonar.plugins.risk.consent=ACCEPTED, sonar.php.file.suffixes=php,php3,php4,php5,phtml,inc, sonar.auth.gitlab.url=https://gitlab.com, sonar.scanner.skipNodeProvisioning=false, sonar.xml.file.suffixes=.xml,.xsd,.xsl,.config, sonar.dbcleaner.weeksBeforeDeletingAllSnapshots=12, sonaranalyzer-vbnet.pluginKey=vbnetenterprise, sonar.azureresourcemanager.activate=true, sonar.java.jvmframeworkconfig.activate=true, sonar.updatecenter.url=https://downloads.sonarsource.com/sonarqube/update/update-center.properties, sonar.tsql.file.suffixes=.tsql, sonar.issue.ignore.multicriteria.3.ruleKey=plsql:*, sonar.core.startTime=2025-02-24T10:47:29+0100}
  activeRules: [21 kubernetes, 448 cpp, 24 css, 132 python, 208 c, 22 go, 210 ipython, 59 tsql, 121 secrets, 134 javascript, 16 ansible, 40 docker, 133 plsql, 513 java, 49 Web, 23 xml, 337 csharpsquid, 178 php, 48 terraform, 6 javabugs, 31 azureresourcemanager, 112 typescript, 26 cloudformation]
  inputFiles: [
    file:///v:/test/test.sql (UTF-8) [plsql]
  ]
]

[Info - 14:22:55.455] [sonarlint : SonarLint Analysis Executor] Git Repository not found for file:///v:/test. The path v:\test is not in a Git repository
[Debug - 14:22:55.461] [sonarlint : sonarlint-analysis-engine] Start analysis
[Info - 14:22:55.463] [sonarlint : sonarlint-analysis-engine] Index files
[Debug - 14:22:55.463] [sonarlint : sonarlint-analysis-engine] Language of file "file:///v:/test/test.sql" is set to "PLSQL"
[Info - 14:22:55.463] [sonarlint : Report about progress of file indexation] 1 file indexed
[Debug - 14:22:55.470] [sonarlint : sonarlint-analysis-engine] Instantiating SonarLintIRProvider for Java.
[Debug - 14:22:55.470] [sonarlint : sonarlint-analysis-engine] Instantiating SonarLintIRProvider for Python.
[Debug - 14:22:55.507] [sonarlint : sonarlint-analysis-engine] Added 112 checks for language='ts', repository='typescript'
[Debug - 14:22:55.507] [sonarlint : sonarlint-analysis-engine] Added 134 checks for language='js', repository='javascript'
[Debug - 14:22:55.508] [sonarlint : sonarlint-analysis-engine] No registered JsAnalysisConsumer.
[Debug - 14:22:55.510] [sonarlint : sonarlint-analysis-engine] Registered check: [ClassCastCheck (javabugs:S6320), ExceptionReachabilityCheck (javabugs:S6416), InfiniteRecursionCheck (javabugs:S2190), UnsupportedMethodCheck (javabugs:S6322), CollectionModifiedDuringIterationCheck (javabugs:S6417), JavaIndexErrorCheck (javabugs:S6466)]
[Debug - 14:22:55.510] [sonarlint : sonarlint-analysis-engine] Registered check: []
[Debug - 14:22:55.510] [sonarlint : sonarlint-analysis-engine] Registered check: [MinMaxRangeCheck (java:S3065), RedundantAssignmentsCheck (java:S4165), XmlValidatedSignatureCheck (java:S6377), DenialOfServiceXMLCheck (java:S6376), ConditionalUnreachableCodeCheck (java:S2583), AllowXMLInclusionCheck (java:S6373), UnclosedResourcesCheck (java:S2095), NonNullSetToNullCheck (java:S2637), InvariantReturnCheck (java:S3516), MapComputeIfAbsentOrPresentCheck (java:S3824), StreamConsumedCheck (java:S3959), StreamNotConsumedCheck (java:S3958), DivisionByZeroCheck (java:S3518), NullDereferenceCheck (java:S2259), OptionalGetBeforeIsPresentCheck (java:S3655), BooleanGratuitousExpressionsCheck (java:S2589), XxeProcessingCheck (java:S2755), ObjectOutputStreamCheck (java:S2689), ParameterNullnessCheck (java:S4449), NoWayOutLoopCheck (java:S2189), LocksNotUnlockedCheck (java:S2222)]
[Debug - 14:22:55.518] [sonarlint : sonarlint-analysis-engine] Registered check: [AbsOnNegativeCheck (java:S2676), AccessibilityChangeCheck (java:S3011), AccessibilityChangeOnRecordsCheck (java:S6216), AllBranchesAreIdenticalCheck (java:S3923), AnchorPrecedenceCheck (java:S5850), AndroidBiometricAuthWithoutCryptoCheck (java:S6293), AndroidBroadcastingCheck (java:S5320), AndroidExternalStorageCheck (java:S5324), AndroidMobileDatabaseEncryptionKeysCheck (java:S6301), AndroidNonAuthenticatedUsersCheck (java:S6288), AndroidUnencryptedDatabaseCheck (java:S6291), AndroidUnencryptedFilesCheck (java:S6300), AnonymousClassShouldBeLambdaCheck (java:S1604), ArrayCopyLoopCheck (java:S3012), ArrayDesignatorAfterTypeCheck (java:S1195), ArrayDesignatorOnVariableCheck (java:S1197), ArrayForVarArgCheck (java:S3878), ArrayHashCodeAndToStringCheck (java:S2116), ArraysAsListOfPrimitiveToStreamCheck (java:S3631), AssertOnBooleanVariableCheck (java:S3346), AssertionsInProductionCodeCheck (java:S5960), AssertsOnParametersOfPublicMethodCheck (java:S4274), AssignmentInSubExpressionCheck (java:S1121), AsyncMethodsCalledViaThisCheck (java:S6809), AsyncMethodsOnConfigurationClassCheck (java:S6817), AsyncMethodsReturnTypeCheck (java:S6810), AuthorizationsStrongDecisionsCheck (java:S5808), AutowiredOnConstructorWhenMultipleConstructorsCheck (java:S6829), AutowiredOnMultipleConstructorsCheck (java:S6818), AvoidQualifierOnBeanMethodsCheck (java:S6831), AwsConsumerBuilderUsageCheck (java:S6244), AwsCredentialsShouldBeSetExplicitlyCheck (java:S6242), AwsLambdaSyncCallCheck (java:S6246), AwsLongTermAccessKeysCheck (java:S6263), AwsRegionSetterCheck (java:S6262), AwsRegionShouldBeSetExplicitlyCheck (java:S6241), AwsReusableResourcesInitializedOnceCheck (java:S6243), BadClassNameCheck (java:S101), BadConstantNameCheck (java:S115), BadFieldNameCheck (java:S116), BadFieldNameStaticNonFinalCheck (java:S3008), BadInterfaceNameCheck (java:S114), BadLocalVariableNameCheck (java:S117), BadMethodNameCheck (java:S100), BadPackageNameCheck (java:S120), BadTypeParameterNameCheck (java:S119), BatchSQLStatementsCheck (java:S6912), BigDecimalDoubleConstructorCheck (java:S2111), BlockingOperationsInVirtualThreadsCheck (java:S6881), BooleanInversionCheck (java:S1940), BooleanLiteralCheck (java:S1125), BooleanMethodReturnCheck (java:S2447), BoxedBooleanExpressionsCheck (java:S5411), BrainMethodCheck (java:S6541), CORSCheck (java:S5122), CallOuterPrivateMethodCheck (java:S3398), CallSuperMethodFromInnerClassCheck (java:S2388), CallToDeprecatedCodeMarkedForRemovalCheck (java:S5738), CallToDeprecatedMethodCheck (java:S1874), CanonEqFlagInRegexCheck (java:S5854), CaseInsensitiveComparisonCheck (java:S1157), CastArithmeticOperandCheck (java:S2184), CatchIllegalMonitorStateExceptionCheck (java:S2235), CatchOfThrowableOrErrorCheck (java:S1181), CatchRethrowingCheck (java:S2737), ChangeMethodContractCheck (java:S2638), ChildClassShadowFieldCheck (java:S2387), CipherBlockChainingCheck (java:S3329), ClassComparedByNameCheck (java:S1872), ClassImportCouplingCheck (java:S6539), ClassNamedLikeExceptionCheck (java:S2166), ClassVariableVisibilityCheck (java:S1104), ClassWithOnlyStaticMethodsInstantiationCheck (java:S2440), ClearTextProtocolCheck (java:S5332), CloneMethodCallsSuperCloneCheck (java:S1182), CloneOverrideCheck (java:S2975), CloneableImplementingCloneCheck (java:S2157), CognitiveComplexityMethodCheck (java:S3776), CollapsibleIfCandidateCheck (java:S1066), CollectionCallingItselfCheck (java:S2114), CollectionConstructorReferenceCheck (java:S5329), CollectionImplementationReferencedCheck (java:S1319), CollectionInappropriateCallsCheck (java:S2175), CollectionIsEmptyCheck (java:S1155), CollectionSizeAndArrayLengthCheck (java:S3981), CollectionsEmptyConstantsCheck (java:S1596), CollectorsToListCheck (java:S6204), CombineCatchCheck (java:S2147), CommentedOutCodeLineCheck (java:S125), CompareStringsBoxedTypesWithEqualsCheck (java:S4973), CompareToNotOverloadedCheck (java:S4351), CompareToResultTestCheck (java:S2200), CompareToReturnValueCheck (java:S2167), ConcatenationWithStringValueOfCheck (java:S1153), ConditionalOnNewLineCheck (java:S3972), ConfigurationBeanNamesCheck (java:S6862), ConfusingOverloadCheck (java:S2177), ConfusingVarargCheck (java:S5669), ConstantMathCheck (java:S2185), ConstantMethodCheck (java:S3400), ConstantsShouldBeStaticFinalCheck (java:S1170), ControlCharacterInLiteralCheck (java:S2479), ControllerWithRestControllerReplacementCheck (java:S6833), ControllerWithSessionAttributesCheck (java:S3753), CookieHttpOnlyCheck (java:S3330), CounterModeIVShouldNotBeReusedCheck (java:S6432), CryptographicKeySizeCheck (java:S4426), CustomCryptographicAlgorithmCheck (java:S2257), CustomSerializationMethodCheck (java:S2061), DanglingElseStatementsCheck (java:S5261), DataHashingCheck (java:S4790), DateFormatWeekYearCheck (java:S3986), DateTimeFormatterMismatchCheck (java:S5917), DateUtilsTruncateCheck (java:S2718), DeadStoreCheck (java:S1854), DebugFeatureEnabledCheck (java:S4507), DefaultPackageCheck (java:S1220), DeprecatedArgumentsCheck (java:S6355), DeprecatedTagPresenceCheck (java:S1133), DepthOfInheritanceTreeCheck (java:S110), DiamondOperatorCheck (java:S2293), DirectBeanMethodInvocationWithoutProxyCheck (java:S6838), DisableAutoEscapingCheck (java:S5247), DisallowedThreadGroupCheck (java:S3014), DisclosingTechnologyFingerprintsCheck (java:S5689), DoubleBraceInitializationCheck (java:S3599), DoubleCheckedLockingAssignmentCheck (java:S3064), DoubleCheckedLockingCheck (java:S2168), DoublePrefixOperatorCheck (java:S2761), DuplicateConditionIfElseIfCheck (java:S1862), DuplicatesInCharacterClassCheck (java:S5869), EmptyBlockCheck (java:S108), EmptyClassCheck (java:S2094), EmptyDatabasePasswordCheck (java:S2115), EmptyLineRegexCheck (java:S5846), EmptyMethodsCheck (java:S1186), EmptyRegexGroupCheck (java:S6331), EmptyStatementUsageCheck (java:S1116), EmptyStringRepetitionCheck (java:S5842), EncryptionAlgorithmCheck (java:S5542), EnumMapCheck (java:S1640), EnumMutableFieldCheck (java:S3066), EqualsArgumentTypeCheck (java:S2097), EqualsNotOverriddenInSubclassCheck (java:S2160), EqualsNotOverriddenWithCompareToCheck (java:S1210), EqualsOnAtomicClassCheck (java:S2204), EqualsOverriddenWithHashCodeCheck (java:S1206), EqualsParametersMarkedNonNullCheck (java:S4454), EscapeSequenceControlCharacterCheck (java:S6070), ExceptionsShouldBeImmutableCheck (java:S1165), ExcessiveContentRequestCheck (java:S5693), ExternalizableClassConstructorCheck (java:S2060), FieldDependencyInjectionCheck (java:S6813), FieldNameMatchingTypeNameCheck (java:S1700), FilePermissionsCheck (java:S2612), FixmeTagPresenceCheck (java:S1134), ForLoopCounterChangedCheck (java:S127), ForLoopFalseConditionCheck (java:S2252), ForLoopIncrementAndUpdateCheck (java:S1994), ForLoopIncrementSignCheck (java:S2251), ForLoopUsedAsWhileLoopCheck (java:S1264), ForLoopVariableTypeCheck (java:S4838), GarbageCollectorCalledCheck (java:S1215), GetRequestedSessionIdCheck (java:S2254), GettersSettersOnRightFieldCheck (java:S4275), GraphemeClustersInClassesCheck (java:S5868), HardCodedCredentialsShouldNotBeUsedCheck (java:S6437), HardCodedPasswordCheck (java:S2068), HardCodedSecretCheck (java:S6418), HardcodedIpCheck (java:S1313), HardcodedURICheck (java:S1075), HasNextCallingNextCheck (java:S1849), HiddenFieldCheck (java:S1117), IdenticalCasesInSwitchCheck (java:S1871), IdenticalOperandOnBinaryExpressionCheck (java:S1764), IgnoredOperationStatusCheck (java:S899), IgnoredReturnValueCheck (java:S2201), IgnoredStreamReturnValueCheck (java:S2674), ImmediateReverseBoxingCheck (java:S2153), ImmediatelyReturnedVariableCheck (java:S1488), ImplementsEnumerationCheck (java:S1150), ImpossibleBackReferenceCheck (java:S6001), ImpossibleBoundariesCheck (java:S5996), InappropriateRegexpCheck (java:S2639), IndentationAfterConditionalCheck (java:S3973), IndexOfWithPositiveNumberCheck (java:S2692), InnerClassOfNonSerializableCheck (java:S2066), InputStreamOverrideReadCheck (java:S4929), InputStreamReadCheck (java:S4517), InsecureCreateTempFileCheck (java:S5445), InstanceOfPatternMatchingCheck (java:S6201), InstanceofUsedOnExceptionCheck (java:S1193), IntegerToHexStringCheck (java:S4425), InterfaceAsConstantContainerCheck (java:S1214), InterfaceOrSuperclassShadowingCheck (java:S2176), InterruptedExceptionCheck (java:S2142), InvalidDateValuesCheck (java:S2110), InvalidRegexCheck (java:S5856), IsInstanceMethodCheck (java:S6202), IterableIteratorCheck (java:S4348), IteratorNextExceptionCheck (java:S2272), JWTWithStrongCipherCheck (java:S5659), JacksonDeserializationCheck (java:S4544), JdbcDriverExplicitLoadingCheck (java:S4925), KeySetInsteadOfEntrySetCheck (java:S2864), KeywordAsIdentifierCheck (java:S1190), KnownCapacityHashBasedCollectionCheck (java:S6485), LDAPAuthenticatedConnectionCheck (java:S4433), LDAPDeserializationCheck (java:S4434), LabelsShouldNotBeUsedCheck (java:S1119), LambdaOptionalParenthesisCheck (java:S1611), LambdaSingleExpressionCheck (java:S1602), LazyArgEvaluationCheck (java:S2629), LoggedRethrownExceptionsCheck (java:S2139), LoggerClassCheck (java:S3416), LongBitsToDoubleOnIntCheck (java:S2127), LoopExecutingAtMostOnceCheck (java:S1751), MathClampMethodsCheck (java:S6885), MathClampRangeCheck (java:S6913), MembersDifferOnlyByCapitalizationCheck (java:S1845), MethodIdenticalImplementationsCheck (java:S4144), MethodNameSameAsClassCheck (java:S1223), MethodNamedEqualsCheck (java:S1201), MethodNamedHashcodeOrEqualCheck (java:S1221), MethodOnlyCallsSuperCheck (java:S1185), MethodParametersOrderCheck (java:S2234), MismatchPackageDirectoryCheck (java:S1598), MissingDeprecatedCheck (java:S1123), MissingOverridesInRecordWithArrayComponentCheck (java:S6218), MissingPathVariableAnnotationCheck (java:S6856), ModelAttributeNamingConventionForSpELCheck (java:S6806), ModifiersOrderCheck (java:S1124), MultilineBlocksCurlyBracesCheck (java:S2681), MultipleWhitespaceCheck (java:S6326), NestedBlocksCheck (java:S1199), NestedEnumStaticCheck (java:S2786), NestedTernaryOperatorsCheck (java:S3358), NestedTryCatchCheck (java:S1141), NioFileDeleteCheck (java:S4042), NonSerializableWriteCheck (java:S2118), NonShortCircuitLogicCheck (java:S2178), NonSingletonAutowiredInSingletonCheck (java:S6832), NonStaticClassInitializerCheck (java:S1171), NotifyCheck (java:S2446), NullCheckWithInstanceofCheck (java:S4201), NullReturnedOnComputeIfPresentOrAbsentCheck (java:S6104), NullShouldNotBeUsedWithOptionalCheck (java:S2789), NullableInjectedFieldsHaveDefaultValueCheck (java:S6816), OSCommandsPathCheck (java:S4036), ObjectCreatedOnlyToCallGetClassCheck (java:S2133), ObjectFinalizeCheck (java:S1111), ObjectFinalizeOverloadedCheck (java:S1175), ObjectFinalizeOverriddenCheck (java:S1113), ObjectFinalizeOverriddenNotPublicCheck (java:S1174), OmitPermittedTypesCheck (java:S6217), OneDeclarationPerLineCheck (java:S1659), OpenSAML2AuthenticationBypassCheck (java:S5679), OptionalRestParametersShouldBeObjectsCheck (java:S6814), OutputStreamOverrideWriteCheck (java:S4349), OverrideAnnotationCheck (java:S1161), OverwrittenKeyCheck (java:S4143), ParameterReassignedToCheck (java:S1226), PasswordEncoderCheck (java:S5344), PatternMatchUsingIfCheck (java:S6880), PersistentEntityUsedAsRequestParameterCheck (java:S4684), PopulateBeansCheck (java:S4512), PossessiveQuantifierContinuationCheck (java:S5994), PredictableSeedCheck (java:S4347), PreferStreamAnyMatchCheck (java:S4034), PreparedStatementAndResultSetCheck (java:S2695), PreparedStatementLoopInvariantCheck (java:S6909), PrimitiveWrappersInTernaryOperatorCheck (java:S2154), PrimitivesMarkedNullableCheck (java:S4682), PrintfFailCheck (java:S2275), PrintfMisuseCheck (java:S3457), PrivateFieldUsedLocallyCheck (java:S1450), PrivateReadResolveCheck (java:S2062), PseudoRandomCheck (java:S2245), PublicConstructorInAbstractClassCheck (java:S5993), PublicStaticFieldShouldBeFinalCheck (java:S1444), PublicStaticMutableMembersCheck (java:S2386), PubliclyWritableDirectoriesCheck (java:S5443), QueryOnlyRequiredFieldsCheck (java:S6905), RandomFloatToIntCheck (java:S2140), RawByteBitwiseOperationsCheck (java:S3034), RawExceptionCheck (java:S112), RawTypeCheck (java:S3740), ReadObjectSynchronizedCheck (java:S2675), ReceivingIntentsCheck (java:S5322), RecordInsteadOfClassCheck (java:S6206), RecordPatternInsteadOfFieldAccessCheck (java:S6878), RecordSerializationIgnoredMembersCheck (java:S6209), RedosCheck (java:S5852), RedundantAbstractMethodCheck (java:S3038), RedundantCloseCheck (java:S4087), RedundantJumpCheck (java:S3626), RedundantRecordMethodsCheck (java:S6207), RedundantRegexAlternativesCheck (java:S5855), RedundantThrowsDeclarationCheck (java:S1130), RedundantTypeCastCheck (java:S1905), ReflectionOnNonRuntimeAnnotationCheck (java:S2109), RegexComplexityCheck (java:S5843), RegexLookaheadCheck (java:S6002), RegexStackOverflowCheck (java:S5998), ReleaseSensorsCheck (java:S6889), ReluctantQuantifierCheck (java:S5857), ReluctantQuantifierWithEmptyContinuationCheck (java:S6019), RepeatAnnotationCheck (java:S1710), ReplaceGuavaWithJavaCheck (java:S4738), ReplaceLambdaByMethodRefCheck (java:S1612), RequestMappingMethodPublicCheck (java:S3751), RestrictedIdentifiersUsageCheck (java:S6213), ResultSetIsLastCheck (java:S2232), ReturnEmptyArrayNotNullCheck (java:S1168), ReturnInFinallyCheck (java:S1143), ReturnOfBooleanExpressionsCheck (java:S1126), ReuseRandomCheck (java:S2119), ReverseSequencedCollectionCheck (java:S6877), ReversedMethodSequencedCollectionCheck (java:S6876), RunFinalizersCheck (java:S2151), SQLInjectionCheck (java:S2077), ScheduledThreadPoolExecutorZeroCheck (java:S2122), SecureCookieCheck (java:S2092), SelfAssignementCheck (java:S1656), SerialVersionUidInRecordCheck (java:S6219), SerializableFieldInSerializableClassCheck (java:S1948), SerializableObjectInSessionCheck (java:S2441), SerializableSuperConstructorCheck (java:S2055), ServerCertificatesCheck (java:S4830), ServletInstanceFieldCheck (java:S2226), ServletMethodsExceptionsThrownCheck (java:S1989), SeveralBreakOrContinuePerLoopCheck (java:S135), ShiftOnIntOrLongCheck (java:S2183), SillyEqualsCheck (java:S2159), SillyStringOperationsCheck (java:S2121), SimpleStringLiteralForSingleLineStringsCheck (java:S5663), SingleCharCharacterClassCheck (java:S6397), SingleCharacterAlternationCheck (java:S6035), SingleIfInsteadOfPatternMatchGuardCheck (java:S6916), SingletonUsageCheck (java:S6548), SpecializedFunctionalInterfacesCheck (java:S4276), SpelExpressionCheck (java:S6857), SpringAntMatcherOrderCheck (java:S4601), SpringBeanNamingConventionCheck (java:S6830), SpringComposedRequestMappingCheck (java:S4488), SpringConfigurationWithAutowiredFieldsCheck (java:S3305), SpringIncompatibleTransactionalCheck (java:S2229), SpringRequestMappingMethodCheck (java:S3752), SpringScanDefaultPackageCheck (java:S4602), SpringSecurityDisableCSRFCheck (java:S4502), SpringSessionFixationCheck (java:S5876), StandardCharsetsConstantsCheck (java:S4719), StaticFieldUpateCheck (java:S2696), StaticFieldUpdateInConstructorCheck (java:S3010), StaticMemberAccessCheck (java:S3252), StaticMembersAccessCheck (java:S2209), StaticMultithreadedUnsafeFieldsCheck (java:S2885), StatusCodesOnResponseCheck (java:S6863), StreamPeekCheck (java:S3864), StringBufferAndBuilderWithCharCheck (java:S1317), StringCallsBeyondBoundsCheck (java:S3039), StringConcatToTextBlockCheck (java:S6126), StringConcatenationInLoopCheck (java:S1643), StringIndexOfRangesCheck (java:S6915), StringIsEmptyCheck (java:S7158), StringLiteralDuplicatedCheck (java:S1192), StringOffsetMethodsCheck (java:S4635), StringPrimitiveConstructorCheck (java:S2129), StringReplaceCheck (java:S5361), StringToPrimitiveConversionCheck (java:S2130), StringToStringCheck (java:S1858), StrongCipherAlgorithmCheck (java:S5547), SubClassStaticReferenceCheck (java:S2390), SunPackagesUsedCheck (java:S1191), SuperfluousCurlyBraceCheck (java:S6396), SuperfluousResponseBodyAnnotationCheck (java:S6837), SuspiciousListRemoveCheck (java:S5413), SwitchAtLeastThreeCasesCheck (java:S1301), SwitchCaseWithoutBreakCheck (java:S128), SwitchCasesShouldBeCommaSeparatedCheck (java:S6208), SwitchDefaultLastCaseCheck (java:S4524), SwitchLastCaseIsDefaultCheck (java:S131), SwitchRedundantKeywordCheck (java:S6205), SwitchWithLabelsCheck (java:S1219), SwitchWithTooManyCasesCheck (java:S1479), SyncGetterAndSetterCheck (java:S2886), SynchronizationOnGetClassCheck (java:S3067), SynchronizationOnStringOrBoxedCheck (java:S1860), SynchronizedClassUsageCheck (java:S1149), SynchronizedFieldAssignmentCheck (java:S2445), SynchronizedLockCheck (java:S2442), SynchronizedOverrideCheck (java:S3551), SystemOutOrErrUsageCheck (java:S106), TextBlockTabsAndSpacesCheck (java:S5664), TextBlocksInComplexExpressionsCheck (java:S6203), ThreadAsRunnableArgumentCheck (java:S2438), ThreadLocalCleanupCheck (java:S5164), ThreadLocalWithInitialCheck (java:S4065), ThreadOverridesRunCheck (java:S2134), ThreadRunCheck (java:S1217), ThreadSleepCheck (java:S2276), ThreadWaitCallCheck (java:S2236), ThrowsFromFinallyCheck (java:S1163), ToArrayCheck (java:S3020), ToStringReturningNullCheck (java:S2225), ToStringUsingBoxingCheck (java:S1158), TodoTagPresenceCheck (java:S1135), TooManyParametersCheck (java:S107), TransactionalMethodVisibilityCheck (java:S2230), TransientFieldInNonSerializableCheck (java:S2065), TryWithResourcesCheck (java:S2093), TwoLocksWaitCheck (java:S3046), TypeParametersShadowingCheck (java:S4977), TypeUpperBoundNotFinalCheck (java:S4968), URLHashCodeAndEqualsCheck (java:S2112), UnicodeCaseCheck (java:S5866), UnnecessaryBitOperationCheck (java:S2437), UnnecessaryEscapeSequencesInTextBlockCheck (java:S5665), UnpredictableSaltCheck (java:S2053), UnquantifiedNonCapturingGroupCheck (java:S6395), UnreachableCatchCheck (java:S4970), UnusedGroupNamesCheck (java:S5860), UnusedLabelCheck (java:S1065), UnusedLocalVariableCheck (java:S1481), UnusedMethodParameterCheck (java:S1172), UnusedPrivateClassCheck (java:S3985), UnusedPrivateFieldCheck (java:S1068), UnusedPrivateMethodCheck (java:S1144), UnusedReturnedDataCheck (java:S2677), UnusedThrowableCheck (java:S3984), UnusedTypeParameterCheck (java:S2326), UselessImportCheck (java:S1128), UselessIncrementCheck (java:S2123), UselessPackageInfoCheck (java:S4032), UselessParenthesesCheck (java:S1110), UserEnumerationCheck (java:S5804), UtilityClassWithPublicConstructorCheck (java:S1118), ValueAnnotationShouldInjectPropertyOrSpELCheck (java:S6804), ValueBasedObjectUsedForLockCheck (java:S3436), VerboseRegexCheck (java:S6353), VerifiedServerHostnamesCheck (java:S5527), VirtualThreadNotSynchronizedCheck (java:S6906), VirtualThreadUnsupportedMethodsCheck (java:S6901), VisibleForTestingUsageCheck (java:S5803), VolatileNonPrimitiveFieldCheck (java:S3077), VolatileVariablesOperationsCheck (java:S3078), WaitInSynchronizeCheck (java:S2273), WaitInWhileLoopCheck (java:S2274), WaitOnConditionCheck (java:S1844), WeakSSLContextCheck (java:S4423), WebViewJavaScriptSupportCheck (java:S6362), WebViewsFileAccessCheck (java:S6363), WildcardReturnParameterTypeCheck (java:S1452), WriteObjectTheOnlySynchronizedMethodCheck (java:S3042), WrongAssignmentOperatorCheck (java:S2757), XxeActiveMQCheck (java:S5301), ZipEntryCheck (java:S5042)]
[Debug - 14:22:55.518] [sonarlint : sonarlint-analysis-engine] Registered check: [ArrayDesignatorOnVariableCheck (java:S1197), AssertJApplyConfigurationCheck (java:S5831), AssertJAssertionsInConsumerCheck (java:S6103), AssertJChainSimplificationCheck (java:S5838), AssertJConsecutiveAssertionCheck (java:S5853), AssertJContextBeforeAssertionCheck (java:S5833), AssertJTestForEmptinessCheck (java:S5841), AssertThatThrownByAloneCheck (java:S5958), AssertTrueInsteadOfDedicatedAssertCheck (java:S5785), AssertionArgumentOrderCheck (java:S3415), AssertionCompareToSelfCheck (java:S5863), AssertionInThreadRunCheck (java:S2186), AssertionInTryCatchCheck (java:S5779), AssertionTypesCheck (java:S5845), AssertionsCompletenessCheck (java:S2970), AssertionsInTestsCheck (java:S2699), BadConstantNameCheck (java:S115), BadFieldNameCheck (java:S116), BadFieldNameStaticNonFinalCheck (java:S3008), BadInterfaceNameCheck (java:S114), BadLocalVariableNameCheck (java:S117), BadTestClassNameCheck (java:S3577), BadTypeParameterNameCheck (java:S119), BooleanInversionCheck (java:S1940), CallSuperInTestCaseCheck (java:S2188), CallToDeprecatedCodeMarkedForRemovalCheck (java:S5738), CallToDeprecatedMethodCheck (java:S1874), ClassComparedByNameCheck (java:S1872), CollapsibleIfCandidateCheck (java:S1066), CollectorsToListCheck (java:S6204), CombineCatchCheck (java:S2147), CommentedOutCodeLineCheck (java:S125), ConstantMathCheck (java:S2185), DeadStoreCheck (java:S1854), DefaultPackageCheck (java:S1220), DoubleCheckedLockingCheck (java:S2168), DuplicateConditionIfElseIfCheck (java:S1862), EmptyBlockCheck (java:S108), EmptyMethodsCheck (java:S1186), EmptyStatementUsageCheck (java:S1116), EnumMapCheck (java:S1640), ExpectedExceptionCheck (java:S5776), FixmeTagPresenceCheck (java:S1134), ForLoopIncrementAndUpdateCheck (java:S1994), HasNextCallingNextCheck (java:S1849), HiddenFieldCheck (java:S1117), IdenticalCasesInSwitchCheck (java:S1871), IgnoredTestsCheck (java:S1607), ImmediateReverseBoxingCheck (java:S2153), ImmediatelyReturnedVariableCheck (java:S1488), JUnit45MethodAnnotationCheck (java:S5826), JUnit5DefaultPackageClassAndMethodCheck (java:S5786), JUnit5SilentlyIgnoreClassAndMethodCheck (java:S5810), JUnitCompatibleAnnotationsCheck (java:S5967), JunitNestedAnnotationCheck (java:S5790), LambdaOptionalParenthesisCheck (java:S1611), LoopExecutingAtMostOnceCheck (java:S1751), MethodIdenticalImplementationsCheck (java:S4144), MethodNameSameAsClassCheck (java:S1223), MismatchPackageDirectoryCheck (java:S1598), MockingAllMethodsCheck (java:S5969), MockitoEqSimplificationCheck (java:S6068), ModifiersOrderCheck (java:S1124), NoTestInTestClassCheck (java:S2187), NonShortCircuitLogicCheck (java:S2178), ObjectCreatedOnlyToCallGetClassCheck (java:S2133), OneExpectedCheckedExceptionCheck (java:S5783), OneExpectedRuntimeExceptionCheck (java:S5778), OverrideAnnotationCheck (java:S1161), ParameterizedTestCheck (java:S5976), PrimitiveWrappersInTernaryOperatorCheck (java:S2154), PrintfMisuseCheck (java:S3457), RandomFloatToIntCheck (java:S2140), RedundantThrowsDeclarationCheck (java:S1130), RepeatAnnotationCheck (java:S1710), ReplaceGuavaWithJavaCheck (java:S4738), ReplaceLambdaByMethodRefCheck (java:S1612), RestrictedIdentifiersUsageCheck (java:S6213), SelfAssignementCheck (java:S1656), ShiftOnIntOrLongCheck (java:S2183), StringConcatToTextBlockCheck (java:S6126), StringConcatenationInLoopCheck (java:S1643), StringIsEmptyCheck (java:S7158), StringToPrimitiveConversionCheck (java:S2130), StringToStringCheck (java:S1858), SwitchCaseWithoutBreakCheck (java:S128), SwitchCasesShouldBeCommaSeparatedCheck (java:S6208), SwitchLastCaseIsDefaultCheck (java:S131), TestAnnotationWithExpectedExceptionCheck (java:S5777), TestsStabilityCheck (java:S5973), ThreadSleepInTestsCheck (java:S2925), TodoTagPresenceCheck (java:S1135), TooManyAssertionsCheck (java:S5961), TryWithResourcesCheck (java:S2093), UnusedLocalVariableCheck (java:S1481), UnusedMethodParameterCheck (java:S1172), UnusedPrivateFieldCheck (java:S1068), UnusedPrivateMethodCheck (java:S1144), UnusedTestRuleCheck (java:S2924), UselessImportCheck (java:S1128), UselessParenthesesCheck (java:S1110)]
[Debug - 14:22:55.521] [sonarlint : sonarlint-analysis-engine] 'JavaSensor' skipped because there are no related files in the current project
[Debug - 14:22:55.521] [sonarlint : sonarlint-analysis-engine] 'Python Sensor' skipped because there are no related files in the current project
[Debug - 14:22:55.521] [sonarlint : sonarlint-analysis-engine] 'IPython Notebooks Sensor' skipped because there are no related files in the current project
[Debug - 14:22:55.521] [sonarlint : sonarlint-analysis-engine] 'Code Quality and Security for Go' skipped because there are no related files in the current project
[Debug - 14:22:55.521] [sonarlint : sonarlint-analysis-engine] 'IaC Ansible Sensor' skipped because there are no related files in the current project
[Debug - 14:22:55.521] [sonarlint : sonarlint-analysis-engine] 'IaC Terraform Sensor' skipped because there are no related files in the current project
[Debug - 14:22:55.521] [sonarlint : sonarlint-analysis-engine] 'IaC CloudFormation Sensor' skipped because there are no related files in the current project
[Debug - 14:22:55.521] [sonarlint : sonarlint-analysis-engine] 'IaC Kubernetes Sensor' skipped because there are no related files in the current project
[Debug - 14:22:55.521] [sonarlint : sonarlint-analysis-engine] 'IaC AzureResourceManager Sensor' skipped because there are no related files in the current project
[Debug - 14:22:55.521] [sonarlint : sonarlint-analysis-engine] Execute Sensor: Java Config Sensor
[Info - 14:22:55.522] [sonarlint : Progress of the Java analysis] 0 source files to be analyzed
[Info - 14:22:55.522] [sonarlint : Progress of the Java analysis] 0/0 source files have been analyzed
[Debug - 14:22:55.522] [sonarlint : sonarlint-analysis-engine] 'T-SQL Sensor' skipped because there are no related files in the current project
[Debug - 14:22:55.522] [sonarlint : sonarlint-analysis-engine] 'JavaScript/TypeScript analysis' skipped because there are no related files in the current project
[Debug - 14:22:55.522] [sonarlint : sonarlint-analysis-engine] 'JavaScript inside YAML analysis' skipped because there are no related files in the current project
[Debug - 14:22:55.522] [sonarlint : sonarlint-analysis-engine] 'JavaScript inside HTML analysis' skipped because there are no related files in the current project
[Debug - 14:22:55.522] [sonarlint : sonarlint-analysis-engine] Execute Sensor: CSS Rules
[Info - 14:22:55.522] [sonarlint : sonarlint-analysis-engine] No CSS, PHP, HTML or VueJS files are found in the project. CSS analysis is skipped.
[Debug - 14:22:55.522] [sonarlint : sonarlint-analysis-engine] Execute Sensor: PL/SQL Sensor
[Debug - 14:22:55.522] [sonarlint : sonarlint-analysis-engine] Setting filesystem encoding: UTF-8
[Info - 14:22:55.525] [sonarlint : sonarlint-analysis-engine] 1 source files to be analyzed
[Info - 14:22:55.526] [sonarlint : Report about progress of PL/SQL analyzer] 1/1 source files have been analyzed
[Debug - 14:22:55.526] [sonarlint : sonarlint-analysis-engine] Execute Sensor: HTML
[Debug - 14:22:55.526] [sonarlint : sonarlint-analysis-engine] 'XML Sensor' skipped because there are no related files in the current project
[Debug - 14:22:55.526] [sonarlint : sonarlint-analysis-engine] 'PHP sensor' skipped because there are no related files in the current project
[Debug - 14:22:55.526] [sonarlint : sonarlint-analysis-engine] 'Analyzer for "php.ini" files' skipped because there are no related files in the current project
[Debug - 14:22:55.527] [sonarlint : sonarlint-analysis-engine] 'OmniSharp' skipped because there are no related files in the current project
[Debug - 14:22:55.527] [sonarlint : sonarlint-analysis-engine] Execute Sensor: IaC Docker Sensor
[Info - 14:22:55.529] [sonarlint : Progress of the Docker analysis] 0 source files to be analyzed
[Info - 14:22:55.529] [sonarlint : Progress of the Docker analysis] 0/0 source files have been analyzed
[Debug - 14:22:55.529] [sonarlint : sonarlint-analysis-engine] 'CFamily' skipped because there are no related files in the current project
[Debug - 14:22:55.529] [sonarlint : sonarlint-analysis-engine] Execute Sensor: javabugs
[Debug - 14:22:55.529] [sonarlint : sonarlint-analysis-engine] Execute Sensor: pythonbugs
[Debug - 14:22:55.529] [sonarlint : sonarlint-analysis-engine] Execute Sensor: DeveloperTextAndSecretsSensor
[Info - 14:22:55.529] [sonarlint : sonarlint-analysis-engine] Available processors: 24
[Info - 14:22:55.529] [sonarlint : sonarlint-analysis-engine] Using 24 threads for analysis.
[Info - 14:22:55.547] [sonarlint : sonarlint-analysis-engine] Analyzing all except non binary files
[Info - 14:22:55.548] [sonarlint : Progress of the text and secrets analysis] 1 source file to be analyzed
[Info - 14:22:55.555] [sonarlint : Progress of the text and secrets analysis] 1/1 source file has been analyzed
[Info - 14:22:55.556] [sonarlint : sonarlint-analysis-engine] Analysis detected 0 issues and 0 Security Hotspots in 151ms
[Debug - 14:22:56.107] [sonarlint : sonarlint-analysis-engine] Language of file "file:///v:/test/test.sql" is set to "PLSQL"
[Debug - 14:22:56.107] [sonarlint : sonarlint-analysis-engine] Module file event for [uri=file:///v:/test/test.sql] has been ignored because it's not a Python file.
[Info - 14:22:56.107] [sonarlint : sonarlint-analysis-engine] Module file event for MODIFIED for file [uri=file:///v:/test/test.sql] has been ignored because it's not a Kubernetes file.
[Debug - 14:22:56.107] [sonarlint : sonarlint-analysis-engine] Processing file event v:/test/test.sql with event MODIFIED
[Debug - 14:22:56.107] [sonarlint : sonarlint-file-exclusions] Computing file exclusion for uri 'file:///v:/test/test.sql'
[Debug - 14:22:56.109] [sonarlint : sonarlint-file-exclusions] File exclusion for uri 'file:///v:/test/test.sql' is false
[Debug - 14:22:56.109] [sonarlint : SonarLint Analysis Executor] isReadyForAnalysis(connectionId: https-sonarqube-inst-com, sonarProjectKey: VSC, plugins: true, analyzer config: true, findings: true) => true
[Debug - 14:22:56.111] [sonarlint : SonarLint Analysis Executor]   * kubernetes: 21 active rules
[Debug - 14:22:56.113] [sonarlint : SonarLint Analysis Executor]   * cpp: 450 active rules
[Debug - 14:22:56.114] [sonarlint : SonarLint Analysis Executor] Rule cpp:S5527 is enabled on the server, but not available in SonarLint
[Debug - 14:22:56.115] [sonarlint : SonarLint Analysis Executor] Rule cpp:S4830 is enabled on the server, but not available in SonarLint
[Debug - 14:22:56.115] [sonarlint : SonarLint Analysis Executor]   * css: 24 active rules
[Debug - 14:22:56.115] [sonarlint : SonarLint Analysis Executor]   * c: 210 active rules
[Debug - 14:22:56.116] [sonarlint : SonarLint Analysis Executor] Rule c:S4830 is enabled on the server, but not available in SonarLint
[Debug - 14:22:56.117] [sonarlint : SonarLint Analysis Executor] Rule c:S5527 is enabled on the server, but not available in SonarLint
[Debug - 14:22:56.118] [sonarlint : SonarLint Analysis Executor]   * go: 25 active rules
[Debug - 14:22:56.118] [sonarlint : SonarLint Analysis Executor] Rule go:S1313 is enabled on the server, but not available in SonarLint
[Debug - 14:22:56.118] [sonarlint : SonarLint Analysis Executor] Rule go:S2068 is enabled on the server, but not available in SonarLint
[Debug - 14:22:56.118] [sonarlint : SonarLint Analysis Executor] Rule go:ParsingError is enabled on the server, but not available in SonarLint
[Debug - 14:22:56.118] [sonarlint : SonarLint Analysis Executor]   * js: 135 active rules
[Debug - 14:22:56.118] [sonarlint : SonarLint Analysis Executor] Rule common-js:DuplicatedBlocks is enabled on the server, but not available in SonarLint
[Debug - 14:22:56.119] [sonarlint : SonarLint Analysis Executor]   * py: 144 active rules
[Debug - 14:22:56.119] [sonarlint : SonarLint Analysis Executor] Rule pythonsecurity:S2091 is enabled on the server, but not available in SonarLint
...
[Debug - 14:22:56.121] [sonarlint : SonarLint Analysis Executor] Rule pythonsecurity:S5145 is enabled on the server, but not available in SonarLint
[Debug - 14:22:56.122] [sonarlint : SonarLint Analysis Executor]   * tsql: 59 active rules
[Debug - 14:22:56.122] [sonarlint : SonarLint Analysis Executor]   * secrets: 121 active rules
[Debug - 14:22:56.122] [sonarlint : SonarLint Analysis Executor]   * ansible: 16 active rules
[Debug - 14:22:56.123] [sonarlint : SonarLint Analysis Executor]   * docker: 40 active rules
[Debug - 14:22:56.125] [sonarlint : SonarLint Analysis Executor]   * plsql: 133 active rules
[Debug - 14:22:56.125] [sonarlint : SonarLint Analysis Executor]   * cs: 363 active rules
[Debug - 14:22:56.125] [sonarlint : SonarLint Analysis Executor] Rule roslyn.sonaranalyzer.security.cs:S6639 is enabled on the server, but not available in SonarLint
...
[Debug - 14:22:56.130] [sonarlint : SonarLint Analysis Executor] Rule roslyn.sonaranalyzer.security.cs:S5135 is enabled on the server, but not available in SonarLint
[Debug - 14:22:56.130] [sonarlint : SonarLint Analysis Executor]   * java: 548 active rules
[Debug - 14:22:56.130] [sonarlint : SonarLint Analysis Executor] Rule javasecurity:S7044 is enabled on the server, but not available in SonarLint
...
[Debug - 14:22:56.142] [sonarlint : SonarLint Analysis Executor] Rule javasecurity:S6096 is enabled on the server, but not available in SonarLint
[Debug - 14:22:56.142] [sonarlint : SonarLint Analysis Executor]   * web: 49 active rules
[Debug - 14:22:56.143] [sonarlint : SonarLint Analysis Executor]   * xml: 23 active rules
[Debug - 14:22:56.145] [sonarlint : SonarLint Analysis Executor]   * json: 0 active rules
[Debug - 14:22:56.145] [sonarlint : SonarLint Analysis Executor]   * php: 196 active rules
[Debug - 14:22:56.145] [sonarlint : SonarLint Analysis Executor] Rule phpsecurity:S2083 is enabled on the server, but not available in SonarLint
...
[Debug - 14:22:56.147] [sonarlint : SonarLint Analysis Executor] Rule phpsecurity:S7044 is enabled on the server, but not available in SonarLint
[Debug - 14:22:56.148] [sonarlint : SonarLint Analysis Executor]   * terraform: 48 active rules
[Debug - 14:22:56.153] [sonarlint : SonarLint Analysis Executor]   * azureresourcemanager: 31 active rules
[Debug - 14:22:56.155] [sonarlint : SonarLint Analysis Executor]   * cloudformation: 26 active rules
[Debug - 14:22:56.157] [sonarlint : SonarLint Analysis Executor]   * ts: 113 active rules
[Debug - 14:22:56.158] [sonarlint : SonarLint Analysis Executor] Rule parameter 'credentialWords' for rule 'typescript:S2068' does not exist in embedded analyzer, ignoring.
[Debug - 14:22:56.158] [sonarlint : SonarLint Analysis Executor] Rule typescript:S2814 is enabled on the server, but not available in SonarLint
[Debug - 14:22:56.158] [sonarlint : SonarLint Analysis Executor]   * yaml: 0 active rules
[Info - 14:22:56.160] [sonarlint : SonarLint Analysis Executor] Git Repository not found for v:\test. The path v:\test is not in a Git repository
[Info - 14:22:56.161] [sonarlint : SonarLint Analysis Executor] Triggering analysis with configuration: [
  baseDir: v:\test
  extraProperties: {sonar.updatecenter.cache.ttl=3600000, sonaranalyzer-cs.nuget.packageVersion=10.4.0.108396, sonaranalyzer.security.cs.pluginVersion=10.11.0.34915, sonar.auth.bitbucket.allowUsersToSignUp=true, sonar.cs.ignoreHeaderComments=true, sonar.issue.ignore.multicriteria=1,2,3,4,5,6,7,8,9, sonar.c.file.suffixes=.c,.h, sonar.typescript.file.suffixes=.ts,.tsx,.cts,.mts, sonar.auth.github.enabled=false, sonar.python.coverage.reportPaths=.reports/coverage.xml, sonar.issue.ignore.multicriteria.2.resourceKey=RBAT*, sonar.text.activate=true, sonaranalyzer-vbnet.nuget.packageVersion=10.4.0.108396, provisioning.gitlab.enabled=false, sonar.go.file.suffixes=.go, sonar.issue.ignore.multicriteria.1.resourceKey=*RPKG*, sonar.issue.ignore.multicriteria.4.resourceKey=*AS_ZIP.SQL, sonar.cs.analyzeRazorCode=true, sonar.auth.saml.applicationId=sonarqube, sonar.issue.ignore.multicriteria.3.resourceKey=*as_zip.sql, sonar.issue.ignore.multicriteria.7.resourceKey=*pkg_role.sql, sonar.python.xunit.skipDetails=false, sonar.ipynb.file.suffixes=ipynb, sonar.issue.ignore.multicriteria.6.resourceKey=*pkg_role.sql, sonar.dbcleaner.weeksBeforeKeepingOnlyAnalysesWithVersion=4, sonar.plsql.jdbc.driver.class=oracle.jdbc.OracleDriver, sonar.qualitygate.ignoreSmallChanges=true, sonar.issue.ignore.multicriteria.5.resourceKey=*pkg_role.sql, sonar.cpd.exclusions=*T*PKG*,*t*pkg*, sonar.auth.saml.signature.enabled=false, sonar.autodetect.ai.code=true, sonar.go.exclusions=**/vendor/**, sonar.php.exclusions=**/vendor/**, sonar.issue.ignore.allfile=1, sonar.js.internal.bundlePath=c:\Users\seg\.vscode\extensions\sonarsource.sonarlint-vscode-4.16.0-win32-x64\eslint-bridge, sonar.terraform.file.suffixes=.tf, sonar.forceAuthentication=false, sonar.issue.ignore.multicriteria.8.resourceKey=*LPKG*, sonar.notifications.delay=60, sonar.cpp.file.suffixes=.cc,.cpp,.cxx,.c++,.hh,.hpp,.hxx,.h++,.ipp,.ixx,.mxx,.cppm,.ccm,.cxxm,.c++m, sonar.swift.file.suffixes=.swift, sonar.vbnet.roslyn.ignoreIssues=false, sonar.plsql.ignoreHeaderComments=false, sonar.flex.file.suffixes=as, sonar.issue.ignore.multicriteria.9.resourceKey=*LPKG*, sonar.multi-quality-mode.enabled=false, sonar.lf.logoUrl=https://sonarqube.inst.com/images/inst_logo.png, sonaranalyzer.security.cs.nuget.packageVersion=10.11.0.34915, sonar.filesize.limit=20, sonar.auth.gitlab.groupsSync=false, sonar.auth.github.apiUrl=https://api.github.com/, sonar.ruby.file.suffixes=.rb, sonaranalyzer-cs.ruleNamespace=SonarAnalyzer.Enterprise.CSharp, sonar.auth.github.allowUsersToSignUp=true, sonar.issue.ignore.multicriteria.4.ruleKey=plsql:*, sonar.cs.analyzeGeneratedCode=false, sonar.azureresourcemanager.file.identifier=https://schema.management.azure.com/schemas/,http://schema.management.azure.com/schemas/, sonar.python.xunit.reportPath=.reports/pytest-results.xml, sonar.java.jvmframeworkconfig.file.patterns=**/src/main/resources/**/*app*.properties,**/src/main/resources/**/*app*.yaml,**/src/main/resources/**/*app*.yml, sonar.builtInQualityProfiles.disableNotificationOnUpdate=false, sonar.javascript.globals=angular,goog,google,OpenLayers,d3,dojo,dojox,dijit,Backbone,moment,casper,_,sap, sonar.dbcleaner.hoursBeforeKeepingOnlyOneSnapshotByDay=24, sonar.yaml.file.suffixes=.yaml,.yml, sonar.dbcleaner.daysBeforeDeletingInactiveBranchesAndPRs=30, sonar.auth.bitbucket.enabled=false, sonar.terraform.activate=true, sonar.css.file.suffixes=.css,.less,.scss,.sass, sonar.cpd.abap.minimumTokens=100, sonar.docker.file.patterns=Dockerfile,*.dockerfile, sonar.auth.github.webUrl=https://github.com/, sonar.dbcleaner.branchesToKeepWhenInactive=master,develop,trunk,branch-.*,release-.*, sonar.html.file.suffixes=.html,.xhtml,.cshtml,.vbhtml,.aspx,.ascx,.rhtml,.erb,.shtm,.shtml,.cmp,.twig, sonaranalyzer-vbnet.nuget.packageId=SonarAnalyzer.Enterprise.VisualBasic, sonar.php.frameworkDetection=true, sonar.auth.gitlab.enabled=false, sonar.issue.ignore.multicriteria.8.ruleKey=plsql:JoinConditionNumberCheck, sonar.cpd.cross_project=false, sonar.cs.analyzer.dotnet.pluginVersion=10.4.0.108396, sonaranalyzer-vbnet.pluginVersion=10.4.0.108396, sonar.vbnet.ignoreHeaderComments=true, sonar.cfamily.compile-commands=, sonaranalyzer.security.cs.analyzerId=SonarAnalyzer.Security, sonaranalyzer.security.cs.nuget.packageId=SonarAnalyzer.Security, sonar.python.flake8.reportPaths=.reports/flake8-report.txt, sonar.auth.github.groupsSync=false, sonar.dbcleaner.weeksBeforeKeepingOnlyOneSnapshotByWeek=4, sonar.vbnet.analyzer.dotnet.pluginKey=vbnetenterprise, sonaranalyzer-vbnet.analyzerId=SonarAnalyzer.Enterprise.VisualBasic, sonar.scala.file.suffixes=.scala, sonar.issue.ignore.multicriteria.5.ruleKey=plsql:PlSql.FunctionAndProcedureNaming, sonar.cs.roslyn.ignoreIssues=false, sonar.cloudformation.activate=true, sonaranalyzer-cs.pluginKey=csharpenterprise, sonar.kubernetes.activate=true, sonar.issue.ignore.multicriteria.1.ruleKey=plsql:JoinConditionNumberCheck, sonar.java.ignoreUnnamedModuleForSplitPackage=False, sonar.vbnet.analyzer.dotnet.staticResourceName=SonarAnalyzer-vbnetenterprise-10.4.0.108396.zip, sonar.json.file.suffixes=.json, sonaranalyzer.security.cs.pluginKey=securitycsharpfrontend, sonaranalyzer-vbnet.ruleNamespace=SonarAnalyzer.Enterprise.VisualBasic, sonar.cloudformation.file.identifier=AWSTemplateFormatVersion, sonar.auth.saml.providerName=SAML, provisioning.github.project.visibility.enabled=true, sonar.dbcleaner.daysBeforeDeletingAnticipatedTransitions=30, sonar.javascript.ignoreHeaderComments=true, sonar.dbcleaner.daysBeforeDeletingClosedIssues=30, sonar.java.enablePreview=False, sonar.dbcleaner.weeksBeforeKeepingOnlyOneSnapshotByMonth=2, sonar.lf.gravatarServerUrl=https://secure.gravatar.com/avatar/{EMAIL_MD5}.jpg?s={SIZE}&d=identicon, sonar.core.serverBaseURL=https://sonarqube.inst.com/, sonar.objc.file.suffixes=.m, sonar.issue.ignore.multicriteria.9.ruleKey=plsql:PlSql.FunctionAndProcedureExcessiveParameters, sonar.text.inclusions=**/*.sh,**/*.bash,**/*.zsh,**/*.ksh,**/*.ps1,**/*.properties,**/*.conf,**/*.pem,**/*.config,.env,.aws/config, sonar.ruby.coverage.reportPaths=coverage/.resultset.json, sonar.coverage.exclusions=**/*.sql,**/*.SQL,**/*.Sql,tests/**,setup.py, sonar.issue.ignore.multicriteria.6.ruleKey=plsql:PreferExecuteImmediateToDbmsSqlCheck, sonar.qualityProfiles.allowDisableInheritedRules=false, sonaranalyzer-cs.staticResourceName=SonarAnalyzer-csharpenterprise-10.4.0.108396.zip, sonar.notifications.runningDelayBeforeReportingStatus=600, sonar.auth.gitlab.allowUsersToSignUp=true, sonar.issue.ignore.multicriteria.2.ruleKey=plsql:DbmsOutputPutLineCallCheck, sonar.projectCreation.mainBranchName=master, sonar.jsp.file.suffixes=.jsp,.jspf,.jspx, sonar.cs.analyzer.dotnet.staticResourceName=SonarAnalyzer-csharpenterprise-10.4.0.108396.zip, sonar.javascript.maxFileSize=1000, sonaranalyzer-cs.nuget.packageId=SonarAnalyzer.Enterprise.CSharp, sonar.javascript.environments=amd,applescript,atomtest,browser,commonjs,embertest,greasemonkey,jasmine,jest,jquery,meteor,mocha,mongo,nashorn,node,phantomjs,prototypejs,protractor,qunit,serviceworker,shared-node-browser,shelljs,webextensions,worker, sonar.authenticator.downcase=false, sonar.scm.disabled=true, sonar.ruby.exclusions=**/vendor/**, sonar.dart.file.suffixes=.dart, sonar.ansible.activate=true, sonar.auth.saml.enabled=false, sonar.vbnet.file.suffixes=.vb, sonaranalyzer-cs.analyzerId=SonarAnalyzer.Enterprise.CSharp, sonar.issue.ignore.allfile.1.fileRegexp=/^create.*tpkg/gmi, sonar.core.id=69DC34BE-18d3aeff518715b, sonar.cs.analyzer.dotnet.pluginKey=csharpenterprise, sonar.cfamily.generateComputedConfig=false, sonar.abap.file.suffixes=.abap,.ab4,.flow,.asprog, sonar.cfamily.ignoreHeaderComments=true, sonar.technicalDebt.ratingGrid=0.05,0.1,0.2,0.5, sonar.vbnet.analyzer.dotnet.pluginVersion=10.4.0.108396, sonar.technicalDebt.developmentCost=30, sonar.lf.enableGravatar=true, sonar.validateWebhooks=true, sonar.docker.activate=true, sonar.python.file.suffixes=py, sonaranalyzer-cs.pluginVersion=10.4.0.108396, sonaranalyzer.security.cs.staticResourceName=SonarAnalyzer.Security-10.11.0.34915.zip, sonar.cs.file.suffixes=cs, sonar.developerAggregatedInfo.disabled=false, sonar.plsql.file.suffixes=sql,pks,pkb, sonaranalyzer.security.cs.ruleNamespace=SonarAnalyzer.Security, sonar.plugins.downloadOnlyRequired=true, sonar.azureresourcemanager.file.suffixes=.bicep, sonar.javascript.file.suffixes=.js,.jsx,.cjs,.mjs,.vue, sonar.cpd.abap.minimumLines=20, sonar.issue.ignore.multicriteria.7.ruleKey=plsql:DbmsOutputPutLineCallCheck, sonar.allowPermissionManagementForProjectAdmins=true, sonar.text.inclusions.activate=true, sonaranalyzer-vbnet.staticResourceName=SonarAnalyzer-vbnetenterprise-10.4.0.108396.zip, sonar.vbnet.analyzeGeneratedCode=false, sonar.java.file.suffixes=.java,.jav, sonar.python.pylint.reportPaths=.reports/pylint-report.txt, sonar.kotlin.file.suffixes=.kt,.kts, sonar.plugins.risk.consent=ACCEPTED, sonar.php.file.suffixes=php,php3,php4,php5,phtml,inc, sonar.auth.gitlab.url=https://gitlab.com, sonar.scanner.skipNodeProvisioning=false, sonar.xml.file.suffixes=.xml,.xsd,.xsl,.config, sonar.dbcleaner.weeksBeforeDeletingAllSnapshots=12, sonaranalyzer-vbnet.pluginKey=vbnetenterprise, sonar.azureresourcemanager.activate=true, sonar.java.jvmframeworkconfig.activate=true, sonar.updatecenter.url=https://downloads.sonarsource.com/sonarqube/update/update-center.properties, sonar.tsql.file.suffixes=.tsql, sonar.issue.ignore.multicriteria.3.ruleKey=plsql:*, sonar.core.startTime=2025-02-24T10:47:29+0100}
  activeRules: [21 kubernetes, 448 cpp, 24 css, 132 python, 208 c, 22 go, 210 ipython, 59 tsql, 121 secrets, 134 javascript, 16 ansible, 40 docker, 133 plsql, 513 java, 49 Web, 23 xml, 337 csharpsquid, 178 php, 48 terraform, 6 javabugs, 31 azureresourcemanager, 112 typescript, 26 cloudformation]
  inputFiles: [
    file:///v:/test/test.sql (UTF-8) [plsql]
  ]
]

[Info - 14:22:56.161] [sonarlint : SonarLint Analysis Executor] Git Repository not found for file:///v:/test. The path v:\test is not in a Git repository
[Debug - 14:22:56.168] [sonarlint : sonarlint-analysis-engine] Start analysis
[Info - 14:22:56.169] [sonarlint : sonarlint-analysis-engine] Index files
[Debug - 14:22:56.169] [sonarlint : sonarlint-analysis-engine] Language of file "file:///v:/test/test.sql" is set to "PLSQL"
[Info - 14:22:56.169] [sonarlint : Report about progress of file indexation] 1 file indexed
[Debug - 14:22:56.174] [sonarlint : sonarlint-analysis-engine] Instantiating SonarLintIRProvider for Java.
[Debug - 14:22:56.174] [sonarlint : sonarlint-analysis-engine] Instantiating SonarLintIRProvider for Python.
[Debug - 14:22:56.201] [sonarlint : sonarlint-analysis-engine] Added 112 checks for language='ts', repository='typescript'
[Debug - 14:22:56.201] [sonarlint : sonarlint-analysis-engine] Added 134 checks for language='js', repository='javascript'
[Debug - 14:22:56.202] [sonarlint : sonarlint-analysis-engine] No registered JsAnalysisConsumer.
[Debug - 14:22:56.204] [sonarlint : sonarlint-analysis-engine] Registered check: [ClassCastCheck (javabugs:S6320), ExceptionReachabilityCheck (javabugs:S6416), InfiniteRecursionCheck (javabugs:S2190), UnsupportedMethodCheck (javabugs:S6322), CollectionModifiedDuringIterationCheck (javabugs:S6417), JavaIndexErrorCheck (javabugs:S6466)]
[Debug - 14:22:56.204] [sonarlint : sonarlint-analysis-engine] Registered check: []
[Debug - 14:22:56.204] [sonarlint : sonarlint-analysis-engine] Registered check: [MinMaxRangeCheck (java:S3065), RedundantAssignmentsCheck (java:S4165), XmlValidatedSignatureCheck (java:S6377), DenialOfServiceXMLCheck (java:S6376), ConditionalUnreachableCodeCheck (java:S2583), AllowXMLInclusionCheck (java:S6373), UnclosedResourcesCheck (java:S2095), NonNullSetToNullCheck (java:S2637), InvariantReturnCheck (java:S3516), MapComputeIfAbsentOrPresentCheck (java:S3824), StreamConsumedCheck (java:S3959), StreamNotConsumedCheck (java:S3958), DivisionByZeroCheck (java:S3518), NullDereferenceCheck (java:S2259), OptionalGetBeforeIsPresentCheck (java:S3655), BooleanGratuitousExpressionsCheck (java:S2589), XxeProcessingCheck (java:S2755), ObjectOutputStreamCheck (java:S2689), ParameterNullnessCheck (java:S4449), NoWayOutLoopCheck (java:S2189), LocksNotUnlockedCheck (java:S2222)]
[Debug - 14:22:56.214] [sonarlint : sonarlint-analysis-engine] Registered check: [AbsOnNegativeCheck (java:S2676), AccessibilityChangeCheck (java:S3011), AccessibilityChangeOnRecordsCheck (java:S6216), AllBranchesAreIdenticalCheck (java:S3923), AnchorPrecedenceCheck (java:S5850), AndroidBiometricAuthWithoutCryptoCheck (java:S6293), AndroidBroadcastingCheck (java:S5320), AndroidExternalStorageCheck (java:S5324), AndroidMobileDatabaseEncryptionKeysCheck (java:S6301), AndroidNonAuthenticatedUsersCheck (java:S6288), AndroidUnencryptedDatabaseCheck (java:S6291), AndroidUnencryptedFilesCheck (java:S6300), AnonymousClassShouldBeLambdaCheck (java:S1604), ArrayCopyLoopCheck (java:S3012), ArrayDesignatorAfterTypeCheck (java:S1195), ArrayDesignatorOnVariableCheck (java:S1197), ArrayForVarArgCheck (java:S3878), ArrayHashCodeAndToStringCheck (java:S2116), ArraysAsListOfPrimitiveToStreamCheck (java:S3631), AssertOnBooleanVariableCheck (java:S3346), AssertionsInProductionCodeCheck (java:S5960), AssertsOnParametersOfPublicMethodCheck (java:S4274), AssignmentInSubExpressionCheck (java:S1121), AsyncMethodsCalledViaThisCheck (java:S6809), AsyncMethodsOnConfigurationClassCheck (java:S6817), AsyncMethodsReturnTypeCheck (java:S6810), AuthorizationsStrongDecisionsCheck (java:S5808), AutowiredOnConstructorWhenMultipleConstructorsCheck (java:S6829), AutowiredOnMultipleConstructorsCheck (java:S6818), AvoidQualifierOnBeanMethodsCheck (java:S6831), AwsConsumerBuilderUsageCheck (java:S6244), AwsCredentialsShouldBeSetExplicitlyCheck (java:S6242), AwsLambdaSyncCallCheck (java:S6246), AwsLongTermAccessKeysCheck (java:S6263), AwsRegionSetterCheck (java:S6262), AwsRegionShouldBeSetExplicitlyCheck (java:S6241), AwsReusableResourcesInitializedOnceCheck (java:S6243), BadClassNameCheck (java:S101), BadConstantNameCheck (java:S115), BadFieldNameCheck (java:S116), BadFieldNameStaticNonFinalCheck (java:S3008), BadInterfaceNameCheck (java:S114), BadLocalVariableNameCheck (java:S117), BadMethodNameCheck (java:S100), BadPackageNameCheck (java:S120), BadTypeParameterNameCheck (java:S119), BatchSQLStatementsCheck (java:S6912), BigDecimalDoubleConstructorCheck (java:S2111), BlockingOperationsInVirtualThreadsCheck (java:S6881), BooleanInversionCheck (java:S1940), BooleanLiteralCheck (java:S1125), BooleanMethodReturnCheck (java:S2447), BoxedBooleanExpressionsCheck (java:S5411), BrainMethodCheck (java:S6541), CORSCheck (java:S5122), CallOuterPrivateMethodCheck (java:S3398), CallSuperMethodFromInnerClassCheck (java:S2388), CallToDeprecatedCodeMarkedForRemovalCheck (java:S5738), CallToDeprecatedMethodCheck (java:S1874), CanonEqFlagInRegexCheck (java:S5854), CaseInsensitiveComparisonCheck (java:S1157), CastArithmeticOperandCheck (java:S2184), CatchIllegalMonitorStateExceptionCheck (java:S2235), CatchOfThrowableOrErrorCheck (java:S1181), CatchRethrowingCheck (java:S2737), ChangeMethodContractCheck (java:S2638), ChildClassShadowFieldCheck (java:S2387), CipherBlockChainingCheck (java:S3329), ClassComparedByNameCheck (java:S1872), ClassImportCouplingCheck (java:S6539), ClassNamedLikeExceptionCheck (java:S2166), ClassVariableVisibilityCheck (java:S1104), ClassWithOnlyStaticMethodsInstantiationCheck (java:S2440), ClearTextProtocolCheck (java:S5332), CloneMethodCallsSuperCloneCheck (java:S1182), CloneOverrideCheck (java:S2975), CloneableImplementingCloneCheck (java:S2157), CognitiveComplexityMethodCheck (java:S3776), CollapsibleIfCandidateCheck (java:S1066), CollectionCallingItselfCheck (java:S2114), CollectionConstructorReferenceCheck (java:S5329), CollectionImplementationReferencedCheck (java:S1319), CollectionInappropriateCallsCheck (java:S2175), CollectionIsEmptyCheck (java:S1155), CollectionSizeAndArrayLengthCheck (java:S3981), CollectionsEmptyConstantsCheck (java:S1596), CollectorsToListCheck (java:S6204), CombineCatchCheck (java:S2147), CommentedOutCodeLineCheck (java:S125), CompareStringsBoxedTypesWithEqualsCheck (java:S4973), CompareToNotOverloadedCheck (java:S4351), CompareToResultTestCheck (java:S2200), CompareToReturnValueCheck (java:S2167), ConcatenationWithStringValueOfCheck (java:S1153), ConditionalOnNewLineCheck (java:S3972), ConfigurationBeanNamesCheck (java:S6862), ConfusingOverloadCheck (java:S2177), ConfusingVarargCheck (java:S5669), ConstantMathCheck (java:S2185), ConstantMethodCheck (java:S3400), ConstantsShouldBeStaticFinalCheck (java:S1170), ControlCharacterInLiteralCheck (java:S2479), ControllerWithRestControllerReplacementCheck (java:S6833), ControllerWithSessionAttributesCheck (java:S3753), CookieHttpOnlyCheck (java:S3330), CounterModeIVShouldNotBeReusedCheck (java:S6432), CryptographicKeySizeCheck (java:S4426), CustomCryptographicAlgorithmCheck (java:S2257), CustomSerializationMethodCheck (java:S2061), DanglingElseStatementsCheck (java:S5261), DataHashingCheck (java:S4790), DateFormatWeekYearCheck (java:S3986), DateTimeFormatterMismatchCheck (java:S5917), DateUtilsTruncateCheck (java:S2718), DeadStoreCheck (java:S1854), DebugFeatureEnabledCheck (java:S4507), DefaultPackageCheck (java:S1220), DeprecatedArgumentsCheck (java:S6355), DeprecatedTagPresenceCheck (java:S1133), DepthOfInheritanceTreeCheck (java:S110), DiamondOperatorCheck (java:S2293), DirectBeanMethodInvocationWithoutProxyCheck (java:S6838), DisableAutoEscapingCheck (java:S5247), DisallowedThreadGroupCheck (java:S3014), DisclosingTechnologyFingerprintsCheck (java:S5689), DoubleBraceInitializationCheck (java:S3599), DoubleCheckedLockingAssignmentCheck (java:S3064), DoubleCheckedLockingCheck (java:S2168), DoublePrefixOperatorCheck (java:S2761), DuplicateConditionIfElseIfCheck (java:S1862), DuplicatesInCharacterClassCheck (java:S5869), EmptyBlockCheck (java:S108), EmptyClassCheck (java:S2094), EmptyDatabasePasswordCheck (java:S2115), EmptyLineRegexCheck (java:S5846), EmptyMethodsCheck (java:S1186), EmptyRegexGroupCheck (java:S6331), EmptyStatementUsageCheck (java:S1116), EmptyStringRepetitionCheck (java:S5842), EncryptionAlgorithmCheck (java:S5542), EnumMapCheck (java:S1640), EnumMutableFieldCheck (java:S3066), EqualsArgumentTypeCheck (java:S2097), EqualsNotOverriddenInSubclassCheck (java:S2160), EqualsNotOverriddenWithCompareToCheck (java:S1210), EqualsOnAtomicClassCheck (java:S2204), EqualsOverriddenWithHashCodeCheck (java:S1206), EqualsParametersMarkedNonNullCheck (java:S4454), EscapeSequenceControlCharacterCheck (java:S6070), ExceptionsShouldBeImmutableCheck (java:S1165), ExcessiveContentRequestCheck (java:S5693), ExternalizableClassConstructorCheck (java:S2060), FieldDependencyInjectionCheck (java:S6813), FieldNameMatchingTypeNameCheck (java:S1700), FilePermissionsCheck (java:S2612), FixmeTagPresenceCheck (java:S1134), ForLoopCounterChangedCheck (java:S127), ForLoopFalseConditionCheck (java:S2252), ForLoopIncrementAndUpdateCheck (java:S1994), ForLoopIncrementSignCheck (java:S2251), ForLoopUsedAsWhileLoopCheck (java:S1264), ForLoopVariableTypeCheck (java:S4838), GarbageCollectorCalledCheck (java:S1215), GetRequestedSessionIdCheck (java:S2254), GettersSettersOnRightFieldCheck (java:S4275), GraphemeClustersInClassesCheck (java:S5868), HardCodedCredentialsShouldNotBeUsedCheck (java:S6437), HardCodedPasswordCheck (java:S2068), HardCodedSecretCheck (java:S6418), HardcodedIpCheck (java:S1313), HardcodedURICheck (java:S1075), HasNextCallingNextCheck (java:S1849), HiddenFieldCheck (java:S1117), IdenticalCasesInSwitchCheck (java:S1871), IdenticalOperandOnBinaryExpressionCheck (java:S1764), IgnoredOperationStatusCheck (java:S899), IgnoredReturnValueCheck (java:S2201), IgnoredStreamReturnValueCheck (java:S2674), ImmediateReverseBoxingCheck (java:S2153), ImmediatelyReturnedVariableCheck (java:S1488), ImplementsEnumerationCheck (java:S1150), ImpossibleBackReferenceCheck (java:S6001), ImpossibleBoundariesCheck (java:S5996), InappropriateRegexpCheck (java:S2639), IndentationAfterConditionalCheck (java:S3973), IndexOfWithPositiveNumberCheck (java:S2692), InnerClassOfNonSerializableCheck (java:S2066), InputStreamOverrideReadCheck (java:S4929), InputStreamReadCheck (java:S4517), InsecureCreateTempFileCheck (java:S5445), InstanceOfPatternMatchingCheck (java:S6201), InstanceofUsedOnExceptionCheck (java:S1193), IntegerToHexStringCheck (java:S4425), InterfaceAsConstantContainerCheck (java:S1214), InterfaceOrSuperclassShadowingCheck (java:S2176), InterruptedExceptionCheck (java:S2142), InvalidDateValuesCheck (java:S2110), InvalidRegexCheck (java:S5856), IsInstanceMethodCheck (java:S6202), IterableIteratorCheck (java:S4348), IteratorNextExceptionCheck (java:S2272), JWTWithStrongCipherCheck (java:S5659), JacksonDeserializationCheck (java:S4544), JdbcDriverExplicitLoadingCheck (java:S4925), KeySetInsteadOfEntrySetCheck (java:S2864), KeywordAsIdentifierCheck (java:S1190), KnownCapacityHashBasedCollectionCheck (java:S6485), LDAPAuthenticatedConnectionCheck (java:S4433), LDAPDeserializationCheck (java:S4434), LabelsShouldNotBeUsedCheck (java:S1119), LambdaOptionalParenthesisCheck (java:S1611), LambdaSingleExpressionCheck (java:S1602), LazyArgEvaluationCheck (java:S2629), LoggedRethrownExceptionsCheck (java:S2139), LoggerClassCheck (java:S3416), LongBitsToDoubleOnIntCheck (java:S2127), LoopExecutingAtMostOnceCheck (java:S1751), MathClampMethodsCheck (java:S6885), MathClampRangeCheck (java:S6913), MembersDifferOnlyByCapitalizationCheck (java:S1845), MethodIdenticalImplementationsCheck (java:S4144), MethodNameSameAsClassCheck (java:S1223), MethodNamedEqualsCheck (java:S1201), MethodNamedHashcodeOrEqualCheck (java:S1221), MethodOnlyCallsSuperCheck (java:S1185), MethodParametersOrderCheck (java:S2234), MismatchPackageDirectoryCheck (java:S1598), MissingDeprecatedCheck (java:S1123), MissingOverridesInRecordWithArrayComponentCheck (java:S6218), MissingPathVariableAnnotationCheck (java:S6856), ModelAttributeNamingConventionForSpELCheck (java:S6806), ModifiersOrderCheck (java:S1124), MultilineBlocksCurlyBracesCheck (java:S2681), MultipleWhitespaceCheck (java:S6326), NestedBlocksCheck (java:S1199), NestedEnumStaticCheck (java:S2786), NestedTernaryOperatorsCheck (java:S3358), NestedTryCatchCheck (java:S1141), NioFileDeleteCheck (java:S4042), NonSerializableWriteCheck (java:S2118), NonShortCircuitLogicCheck (java:S2178), NonSingletonAutowiredInSingletonCheck (java:S6832), NonStaticClassInitializerCheck (java:S1171), NotifyCheck (java:S2446), NullCheckWithInstanceofCheck (java:S4201), NullReturnedOnComputeIfPresentOrAbsentCheck (java:S6104), NullShouldNotBeUsedWithOptionalCheck (java:S2789), NullableInjectedFieldsHaveDefaultValueCheck (java:S6816), OSCommandsPathCheck (java:S4036), ObjectCreatedOnlyToCallGetClassCheck (java:S2133), ObjectFinalizeCheck (java:S1111), ObjectFinalizeOverloadedCheck (java:S1175), ObjectFinalizeOverriddenCheck (java:S1113), ObjectFinalizeOverriddenNotPublicCheck (java:S1174), OmitPermittedTypesCheck (java:S6217), OneDeclarationPerLineCheck (java:S1659), OpenSAML2AuthenticationBypassCheck (java:S5679), OptionalRestParametersShouldBeObjectsCheck (java:S6814), OutputStreamOverrideWriteCheck (java:S4349), OverrideAnnotationCheck (java:S1161), OverwrittenKeyCheck (java:S4143), ParameterReassignedToCheck (java:S1226), PasswordEncoderCheck (java:S5344), PatternMatchUsingIfCheck (java:S6880), PersistentEntityUsedAsRequestParameterCheck (java:S4684), PopulateBeansCheck (java:S4512), PossessiveQuantifierContinuationCheck (java:S5994), PredictableSeedCheck (java:S4347), PreferStreamAnyMatchCheck (java:S4034), PreparedStatementAndResultSetCheck (java:S2695), PreparedStatementLoopInvariantCheck (java:S6909), PrimitiveWrappersInTernaryOperatorCheck (java:S2154), PrimitivesMarkedNullableCheck (java:S4682), PrintfFailCheck (java:S2275), PrintfMisuseCheck (java:S3457), PrivateFieldUsedLocallyCheck (java:S1450), PrivateReadResolveCheck (java:S2062), PseudoRandomCheck (java:S2245), PublicConstructorInAbstractClassCheck (java:S5993), PublicStaticFieldShouldBeFinalCheck (java:S1444), PublicStaticMutableMembersCheck (java:S2386), PubliclyWritableDirectoriesCheck (java:S5443), QueryOnlyRequiredFieldsCheck (java:S6905), RandomFloatToIntCheck (java:S2140), RawByteBitwiseOperationsCheck (java:S3034), RawExceptionCheck (java:S112), RawTypeCheck (java:S3740), ReadObjectSynchronizedCheck (java:S2675), ReceivingIntentsCheck (java:S5322), RecordInsteadOfClassCheck (java:S6206), RecordPatternInsteadOfFieldAccessCheck (java:S6878), RecordSerializationIgnoredMembersCheck (java:S6209), RedosCheck (java:S5852), RedundantAbstractMethodCheck (java:S3038), RedundantCloseCheck (java:S4087), RedundantJumpCheck (java:S3626), RedundantRecordMethodsCheck (java:S6207), RedundantRegexAlternativesCheck (java:S5855), RedundantThrowsDeclarationCheck (java:S1130), RedundantTypeCastCheck (java:S1905), ReflectionOnNonRuntimeAnnotationCheck (java:S2109), RegexComplexityCheck (java:S5843), RegexLookaheadCheck (java:S6002), RegexStackOverflowCheck (java:S5998), ReleaseSensorsCheck (java:S6889), ReluctantQuantifierCheck (java:S5857), ReluctantQuantifierWithEmptyContinuationCheck (java:S6019), RepeatAnnotationCheck (java:S1710), ReplaceGuavaWithJavaCheck (java:S4738), ReplaceLambdaByMethodRefCheck (java:S1612), RequestMappingMethodPublicCheck (java:S3751), RestrictedIdentifiersUsageCheck (java:S6213), ResultSetIsLastCheck (java:S2232), ReturnEmptyArrayNotNullCheck (java:S1168), ReturnInFinallyCheck (java:S1143), ReturnOfBooleanExpressionsCheck (java:S1126), ReuseRandomCheck (java:S2119), ReverseSequencedCollectionCheck (java:S6877), ReversedMethodSequencedCollectionCheck (java:S6876), RunFinalizersCheck (java:S2151), SQLInjectionCheck (java:S2077), ScheduledThreadPoolExecutorZeroCheck (java:S2122), SecureCookieCheck (java:S2092), SelfAssignementCheck (java:S1656), SerialVersionUidInRecordCheck (java:S6219), SerializableFieldInSerializableClassCheck (java:S1948), SerializableObjectInSessionCheck (java:S2441), SerializableSuperConstructorCheck (java:S2055), ServerCertificatesCheck (java:S4830), ServletInstanceFieldCheck (java:S2226), ServletMethodsExceptionsThrownCheck (java:S1989), SeveralBreakOrContinuePerLoopCheck (java:S135), ShiftOnIntOrLongCheck (java:S2183), SillyEqualsCheck (java:S2159), SillyStringOperationsCheck (java:S2121), SimpleStringLiteralForSingleLineStringsCheck (java:S5663), SingleCharCharacterClassCheck (java:S6397), SingleCharacterAlternationCheck (java:S6035), SingleIfInsteadOfPatternMatchGuardCheck (java:S6916), SingletonUsageCheck (java:S6548), SpecializedFunctionalInterfacesCheck (java:S4276), SpelExpressionCheck (java:S6857), SpringAntMatcherOrderCheck (java:S4601), SpringBeanNamingConventionCheck (java:S6830), SpringComposedRequestMappingCheck (java:S4488), SpringConfigurationWithAutowiredFieldsCheck (java:S3305), SpringIncompatibleTransactionalCheck (java:S2229), SpringRequestMappingMethodCheck (java:S3752), SpringScanDefaultPackageCheck (java:S4602), SpringSecurityDisableCSRFCheck (java:S4502), SpringSessionFixationCheck (java:S5876), StandardCharsetsConstantsCheck (java:S4719), StaticFieldUpateCheck (java:S2696), StaticFieldUpdateInConstructorCheck (java:S3010), StaticMemberAccessCheck (java:S3252), StaticMembersAccessCheck (java:S2209), StaticMultithreadedUnsafeFieldsCheck (java:S2885), StatusCodesOnResponseCheck (java:S6863), StreamPeekCheck (java:S3864), StringBufferAndBuilderWithCharCheck (java:S1317), StringCallsBeyondBoundsCheck (java:S3039), StringConcatToTextBlockCheck (java:S6126), StringConcatenationInLoopCheck (java:S1643), StringIndexOfRangesCheck (java:S6915), StringIsEmptyCheck (java:S7158), StringLiteralDuplicatedCheck (java:S1192), StringOffsetMethodsCheck (java:S4635), StringPrimitiveConstructorCheck (java:S2129), StringReplaceCheck (java:S5361), StringToPrimitiveConversionCheck (java:S2130), StringToStringCheck (java:S1858), StrongCipherAlgorithmCheck (java:S5547), SubClassStaticReferenceCheck (java:S2390), SunPackagesUsedCheck (java:S1191), SuperfluousCurlyBraceCheck (java:S6396), SuperfluousResponseBodyAnnotationCheck (java:S6837), SuspiciousListRemoveCheck (java:S5413), SwitchAtLeastThreeCasesCheck (java:S1301), SwitchCaseWithoutBreakCheck (java:S128), SwitchCasesShouldBeCommaSeparatedCheck (java:S6208), SwitchDefaultLastCaseCheck (java:S4524), SwitchLastCaseIsDefaultCheck (java:S131), SwitchRedundantKeywordCheck (java:S6205), SwitchWithLabelsCheck (java:S1219), SwitchWithTooManyCasesCheck (java:S1479), SyncGetterAndSetterCheck (java:S2886), SynchronizationOnGetClassCheck (java:S3067), SynchronizationOnStringOrBoxedCheck (java:S1860), SynchronizedClassUsageCheck (java:S1149), SynchronizedFieldAssignmentCheck (java:S2445), SynchronizedLockCheck (java:S2442), SynchronizedOverrideCheck (java:S3551), SystemOutOrErrUsageCheck (java:S106), TextBlockTabsAndSpacesCheck (java:S5664), TextBlocksInComplexExpressionsCheck (java:S6203), ThreadAsRunnableArgumentCheck (java:S2438), ThreadLocalCleanupCheck (java:S5164), ThreadLocalWithInitialCheck (java:S4065), ThreadOverridesRunCheck (java:S2134), ThreadRunCheck (java:S1217), ThreadSleepCheck (java:S2276), ThreadWaitCallCheck (java:S2236), ThrowsFromFinallyCheck (java:S1163), ToArrayCheck (java:S3020), ToStringReturningNullCheck (java:S2225), ToStringUsingBoxingCheck (java:S1158), TodoTagPresenceCheck (java:S1135), TooManyParametersCheck (java:S107), TransactionalMethodVisibilityCheck (java:S2230), TransientFieldInNonSerializableCheck (java:S2065), TryWithResourcesCheck (java:S2093), TwoLocksWaitCheck (java:S3046), TypeParametersShadowingCheck (java:S4977), TypeUpperBoundNotFinalCheck (java:S4968), URLHashCodeAndEqualsCheck (java:S2112), UnicodeCaseCheck (java:S5866), UnnecessaryBitOperationCheck (java:S2437), UnnecessaryEscapeSequencesInTextBlockCheck (java:S5665), UnpredictableSaltCheck (java:S2053), UnquantifiedNonCapturingGroupCheck (java:S6395), UnreachableCatchCheck (java:S4970), UnusedGroupNamesCheck (java:S5860), UnusedLabelCheck (java:S1065), UnusedLocalVariableCheck (java:S1481), UnusedMethodParameterCheck (java:S1172), UnusedPrivateClassCheck (java:S3985), UnusedPrivateFieldCheck (java:S1068), UnusedPrivateMethodCheck (java:S1144), UnusedReturnedDataCheck (java:S2677), UnusedThrowableCheck (java:S3984), UnusedTypeParameterCheck (java:S2326), UselessImportCheck (java:S1128), UselessIncrementCheck (java:S2123), UselessPackageInfoCheck (java:S4032), UselessParenthesesCheck (java:S1110), UserEnumerationCheck (java:S5804), UtilityClassWithPublicConstructorCheck (java:S1118), ValueAnnotationShouldInjectPropertyOrSpELCheck (java:S6804), ValueBasedObjectUsedForLockCheck (java:S3436), VerboseRegexCheck (java:S6353), VerifiedServerHostnamesCheck (java:S5527), VirtualThreadNotSynchronizedCheck (java:S6906), VirtualThreadUnsupportedMethodsCheck (java:S6901), VisibleForTestingUsageCheck (java:S5803), VolatileNonPrimitiveFieldCheck (java:S3077), VolatileVariablesOperationsCheck (java:S3078), WaitInSynchronizeCheck (java:S2273), WaitInWhileLoopCheck (java:S2274), WaitOnConditionCheck (java:S1844), WeakSSLContextCheck (java:S4423), WebViewJavaScriptSupportCheck (java:S6362), WebViewsFileAccessCheck (java:S6363), WildcardReturnParameterTypeCheck (java:S1452), WriteObjectTheOnlySynchronizedMethodCheck (java:S3042), WrongAssignmentOperatorCheck (java:S2757), XxeActiveMQCheck (java:S5301), ZipEntryCheck (java:S5042)]
[Debug - 14:22:56.214] [sonarlint : sonarlint-analysis-engine] Registered check: [ArrayDesignatorOnVariableCheck (java:S1197), AssertJApplyConfigurationCheck (java:S5831), AssertJAssertionsInConsumerCheck (java:S6103), AssertJChainSimplificationCheck (java:S5838), AssertJConsecutiveAssertionCheck (java:S5853), AssertJContextBeforeAssertionCheck (java:S5833), AssertJTestForEmptinessCheck (java:S5841), AssertThatThrownByAloneCheck (java:S5958), AssertTrueInsteadOfDedicatedAssertCheck (java:S5785), AssertionArgumentOrderCheck (java:S3415), AssertionCompareToSelfCheck (java:S5863), AssertionInThreadRunCheck (java:S2186), AssertionInTryCatchCheck (java:S5779), AssertionTypesCheck (java:S5845), AssertionsCompletenessCheck (java:S2970), AssertionsInTestsCheck (java:S2699), BadConstantNameCheck (java:S115), BadFieldNameCheck (java:S116), BadFieldNameStaticNonFinalCheck (java:S3008), BadInterfaceNameCheck (java:S114), BadLocalVariableNameCheck (java:S117), BadTestClassNameCheck (java:S3577), BadTypeParameterNameCheck (java:S119), BooleanInversionCheck (java:S1940), CallSuperInTestCaseCheck (java:S2188), CallToDeprecatedCodeMarkedForRemovalCheck (java:S5738), CallToDeprecatedMethodCheck (java:S1874), ClassComparedByNameCheck (java:S1872), CollapsibleIfCandidateCheck (java:S1066), CollectorsToListCheck (java:S6204), CombineCatchCheck (java:S2147), CommentedOutCodeLineCheck (java:S125), ConstantMathCheck (java:S2185), DeadStoreCheck (java:S1854), DefaultPackageCheck (java:S1220), DoubleCheckedLockingCheck (java:S2168), DuplicateConditionIfElseIfCheck (java:S1862), EmptyBlockCheck (java:S108), EmptyMethodsCheck (java:S1186), EmptyStatementUsageCheck (java:S1116), EnumMapCheck (java:S1640), ExpectedExceptionCheck (java:S5776), FixmeTagPresenceCheck (java:S1134), ForLoopIncrementAndUpdateCheck (java:S1994), HasNextCallingNextCheck (java:S1849), HiddenFieldCheck (java:S1117), IdenticalCasesInSwitchCheck (java:S1871), IgnoredTestsCheck (java:S1607), ImmediateReverseBoxingCheck (java:S2153), ImmediatelyReturnedVariableCheck (java:S1488), JUnit45MethodAnnotationCheck (java:S5826), JUnit5DefaultPackageClassAndMethodCheck (java:S5786), JUnit5SilentlyIgnoreClassAndMethodCheck (java:S5810), JUnitCompatibleAnnotationsCheck (java:S5967), JunitNestedAnnotationCheck (java:S5790), LambdaOptionalParenthesisCheck (java:S1611), LoopExecutingAtMostOnceCheck (java:S1751), MethodIdenticalImplementationsCheck (java:S4144), MethodNameSameAsClassCheck (java:S1223), MismatchPackageDirectoryCheck (java:S1598), MockingAllMethodsCheck (java:S5969), MockitoEqSimplificationCheck (java:S6068), ModifiersOrderCheck (java:S1124), NoTestInTestClassCheck (java:S2187), NonShortCircuitLogicCheck (java:S2178), ObjectCreatedOnlyToCallGetClassCheck (java:S2133), OneExpectedCheckedExceptionCheck (java:S5783), OneExpectedRuntimeExceptionCheck (java:S5778), OverrideAnnotationCheck (java:S1161), ParameterizedTestCheck (java:S5976), PrimitiveWrappersInTernaryOperatorCheck (java:S2154), PrintfMisuseCheck (java:S3457), RandomFloatToIntCheck (java:S2140), RedundantThrowsDeclarationCheck (java:S1130), RepeatAnnotationCheck (java:S1710), ReplaceGuavaWithJavaCheck (java:S4738), ReplaceLambdaByMethodRefCheck (java:S1612), RestrictedIdentifiersUsageCheck (java:S6213), SelfAssignementCheck (java:S1656), ShiftOnIntOrLongCheck (java:S2183), StringConcatToTextBlockCheck (java:S6126), StringConcatenationInLoopCheck (java:S1643), StringIsEmptyCheck (java:S7158), StringToPrimitiveConversionCheck (java:S2130), StringToStringCheck (java:S1858), SwitchCaseWithoutBreakCheck (java:S128), SwitchCasesShouldBeCommaSeparatedCheck (java:S6208), SwitchLastCaseIsDefaultCheck (java:S131), TestAnnotationWithExpectedExceptionCheck (java:S5777), TestsStabilityCheck (java:S5973), ThreadSleepInTestsCheck (java:S2925), TodoTagPresenceCheck (java:S1135), TooManyAssertionsCheck (java:S5961), TryWithResourcesCheck (java:S2093), UnusedLocalVariableCheck (java:S1481), UnusedMethodParameterCheck (java:S1172), UnusedPrivateFieldCheck (java:S1068), UnusedPrivateMethodCheck (java:S1144), UnusedTestRuleCheck (java:S2924), UselessImportCheck (java:S1128), UselessParenthesesCheck (java:S1110)]
[Debug - 14:22:56.217] [sonarlint : sonarlint-analysis-engine] 'JavaSensor' skipped because there are no related files in the current project
[Debug - 14:22:56.217] [sonarlint : sonarlint-analysis-engine] 'Python Sensor' skipped because there are no related files in the current project
[Debug - 14:22:56.217] [sonarlint : sonarlint-analysis-engine] 'IPython Notebooks Sensor' skipped because there are no related files in the current project
[Debug - 14:22:56.217] [sonarlint : sonarlint-analysis-engine] 'Code Quality and Security for Go' skipped because there are no related files in the current project
[Debug - 14:22:56.217] [sonarlint : sonarlint-analysis-engine] 'IaC Ansible Sensor' skipped because there are no related files in the current project
[Debug - 14:22:56.217] [sonarlint : sonarlint-analysis-engine] 'IaC Terraform Sensor' skipped because there are no related files in the current project
[Debug - 14:22:56.217] [sonarlint : sonarlint-analysis-engine] 'IaC CloudFormation Sensor' skipped because there are no related files in the current project
[Debug - 14:22:56.217] [sonarlint : sonarlint-analysis-engine] 'IaC Kubernetes Sensor' skipped because there are no related files in the current project
[Debug - 14:22:56.217] [sonarlint : sonarlint-analysis-engine] 'IaC AzureResourceManager Sensor' skipped because there are no related files in the current project
[Debug - 14:22:56.217] [sonarlint : sonarlint-analysis-engine] Execute Sensor: Java Config Sensor
[Info - 14:22:56.217] [sonarlint : Progress of the Java analysis] 0 source files to be analyzed
[Info - 14:22:56.217] [sonarlint : Progress of the Java analysis] 0/0 source files have been analyzed
[Debug - 14:22:56.217] [sonarlint : sonarlint-analysis-engine] 'T-SQL Sensor' skipped because there are no related files in the current project
[Debug - 14:22:56.217] [sonarlint : sonarlint-analysis-engine] 'JavaScript/TypeScript analysis' skipped because there are no related files in the current project
[Debug - 14:22:56.217] [sonarlint : sonarlint-analysis-engine] 'JavaScript inside YAML analysis' skipped because there are no related files in the current project
[Debug - 14:22:56.217] [sonarlint : sonarlint-analysis-engine] 'JavaScript inside HTML analysis' skipped because there are no related files in the current project
[Debug - 14:22:56.217] [sonarlint : sonarlint-analysis-engine] Execute Sensor: CSS Rules
[Info - 14:22:56.217] [sonarlint : sonarlint-analysis-engine] No CSS, PHP, HTML or VueJS files are found in the project. CSS analysis is skipped.
[Debug - 14:22:56.217] [sonarlint : sonarlint-analysis-engine] Execute Sensor: PL/SQL Sensor
[Debug - 14:22:56.217] [sonarlint : sonarlint-analysis-engine] Setting filesystem encoding: UTF-8
[Info - 14:22:56.221] [sonarlint : sonarlint-analysis-engine] 1 source files to be analyzed
[Info - 14:22:56.222] [sonarlint : Report about progress of PL/SQL analyzer] 1/1 source files have been analyzed
[Debug - 14:22:56.222] [sonarlint : sonarlint-analysis-engine] Execute Sensor: HTML
[Debug - 14:22:56.222] [sonarlint : sonarlint-analysis-engine] 'XML Sensor' skipped because there are no related files in the current project
[Debug - 14:22:56.222] [sonarlint : sonarlint-analysis-engine] 'PHP sensor' skipped because there are no related files in the current project
[Debug - 14:22:56.222] [sonarlint : sonarlint-analysis-engine] 'Analyzer for "php.ini" files' skipped because there are no related files in the current project
[Debug - 14:22:56.222] [sonarlint : sonarlint-analysis-engine] 'OmniSharp' skipped because there are no related files in the current project
[Debug - 14:22:56.222] [sonarlint : sonarlint-analysis-engine] Execute Sensor: IaC Docker Sensor
[Info - 14:22:56.224] [sonarlint : Progress of the Docker analysis] 0 source files to be analyzed
[Info - 14:22:56.224] [sonarlint : Progress of the Docker analysis] 0/0 source files have been analyzed
[Debug - 14:22:56.224] [sonarlint : sonarlint-analysis-engine] 'CFamily' skipped because there are no related files in the current project
[Debug - 14:22:56.224] [sonarlint : sonarlint-analysis-engine] Execute Sensor: javabugs
[Debug - 14:22:56.224] [sonarlint : sonarlint-analysis-engine] Execute Sensor: pythonbugs
[Debug - 14:22:56.224] [sonarlint : sonarlint-analysis-engine] Execute Sensor: DeveloperTextAndSecretsSensor
[Info - 14:22:56.224] [sonarlint : sonarlint-analysis-engine] Available processors: 24
[Info - 14:22:56.224] [sonarlint : sonarlint-analysis-engine] Using 24 threads for analysis.
[Info - 14:22:56.250] [sonarlint : sonarlint-analysis-engine] Analyzing all except non binary files
[Info - 14:22:56.251] [sonarlint : Progress of the text and secrets analysis] 1 source file to be analyzed
[Info - 14:22:56.259] [sonarlint : Progress of the text and secrets analysis] 1/1 source file has been analyzed
[Info - 14:22:56.259] [sonarlint : sonarlint-analysis-engine] Analysis detected 0 issues and 0 Security Hotspots in 150ms
[Debug - 14:23:07.706] [sonarlint : Smart Notifications Polling] GET 200 https://sonarqube.inst.com/api/system/status | response time=7ms
[Debug - 14:23:07.706] [sonarlint : Smart Notifications Polling] Downloaded server infos in 7ms

Syntax is SQL syntax described here:

It was added in PL/SQL during version Oracle database 12c, the 4th bullet point in below doc:

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/newft/new-features.html#GUID-9B4D323C-079F-488A-A675-81B9730C4CE3

Thanks

sebastien.marichal · February 24, 2025, 1:43pm

Thank you for your feedback.

I misread you initial post, I thought you were doing an analysis with the scanner-cli.
I am not sure if this warning is showing up in SonarLint.

In any case, the parsing error should be fix in order to support the SQL/JSON Conditions.
I have created a ticket in our backlog to tackle it in the future.

Thank you for the links, it will be really helpful during the implementation!

Have a great day!

SebG · February 24, 2025, 2:08pm

I hope you noted that initially it was a SQL/JSON condition that was extended to a PLSQL/JSON condition.

So this is not only required for SQL code but it is also required for PLSQL code.

I don’t know if you make a distinction between SQL and PLSQL during scan, so I prefer to make this precision

Thanks and have a great day.