PSSQL executing using T-SQL sensors #47
Description
Hello, im trying to use your plugin for first time to scan some postgres code, but it fails to parse the .sql files which makes sense to me as I can see it running T-SQL sensor.
INFO Sensor T-SQL Sensor [tsql] (done) | time=294ms
From my understanding my sonar.config settings are fine. I also have SQLCheck installed.
sonar-scanner -D sonar.host.url=https://sonarqube.removed.url/ -D sonar.login=****** -D sonar.password=****** -D sonar.projectKey=vzc.cicd.samples.flyway.postgres -D sonar.projectName=vzc.cicd.samples.flyway.postgres -D sonar.projectVersion=0.0.1 -D sonar.sources='vzc.cicd.samples.flyway.postgres/src' -D sonar.dynamicAnalysis=reuseReports -D sonar.projectBaseDir='vzc.cicd.samples.flyway.postgres' -D sonar.exclusions='' -D sonar.working.directory='vzc.cicd.samples.flyway.postgres/.scannerwork' -D sonar.language=sql -D sonar.sql.dialect=pssqlv2
The execution is a success but only code smells are picked up.
Some example warns:
WARN Unable to parse file '/builds/eng-systems/lifecycle/build/sample-apps/vzc.cicd.samples.flyway.postgres/src/06_tables/r__06.00_vp.firmware.sql' : Parse error at line 3 column 14:
1: /* Copyright 2020. Company Removed for Github. All rights reserved. */
2:
3: CREATE TABLE IF NOT EXISTS vp.firmware
INFO Sensor T-SQL Sensor [tsql]
16:17:14.065 INFO 82 source files to be analyzed
16:17:14.080 WARN Unable to parse file '/builds/eng-systems/lifecycle/build/sample-apps/vzc.cicd.samples.flyway.postgres/src/create_database_scripts/pgsql_create_database.sql' : Parse error at line 1 column 17:
1: CREATE DATABASE {database_name};
Happy to share any other logs but for brevity I've kept it to minimum.