Felipe Zorzo

Better support for test and coverage reports generated by utPLSQL

1

Generating tests and coverage accurately with utPLSQL-cli can be quite challenging due to its mapping configuration, as illustrated in [this guide](https://github.com/felipebz/zpa/wiki/utPLSQL-integration#example-with-dedicated-folders-for-each-file-type). Achieving accurate results can be challenging due to certain...

Unnecessary concatenation of string literals

1

It's not necessary concatenate two string literals at runtime. Noncompliant code: ``` var := 'a'||'b'; var2 := concat('a', 'b'); ``` Compliant code: ``` var := 'ab'; var2 := 'ab'; ```

Currently to create new rules it's necessary to know the internals of the grammar and look at the generated AST using the zpa-toolkit. Ideally we should provide an easier API...

"INSERT ALL" is not recognized by the parser. Source: https://github.com/utPLSQL/utPLSQL/blob/35dbe64739c0fe42c09cf9812ed946971ad04040/examples/remove_rooms_by_name/test_remove_rooms_by_name.pkg#L27 Reference: https://sonarcloud.io/project/issues?id=utPLSQL-zpa-demo&issues=AWrh9a36ezZPqKiffFMW&open=AWrh9a36ezZPqKiffFMW

Inspired by #92, it should be possible to create rules targeting the test annotations provided by utPLSQL 3.x. Example: * Every test case (annotated with "-- %test") should have a...

Documentation: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/SELECT.html#GUID-CFA006CA-6FF1-4972-821E-6996142A51C6 (originally reported on #8)

Documentation: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/SELECT.html#GUID-CFA006CA-6FF1-4972-821E-6996142A51C6 (originally reported on #8)

The SQL/JSON functions have special syntaxes and they need to be handled like the [XML functions](https://github.com/felipebz/zpa/blob/main/zpa-core/src/main/kotlin/org/sonar/plugins/plsqlopen/api/SingleRowSqlFunctionsGrammar.kt): - [ ] [JSON_ARRAY](https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/JSON_ARRAY.html) - [ ] [JSON_ARRAYAGG](https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/JSON_ARRAYAGG.html) - [ ] [JSON_DATAGUIDE](https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/JSON_DATAGUIDE.html) - [...

Consider the code below: ``` declare const_length constant number := 5; var1 number(const_length); var2 number(5); begin null; end; ``` Both variables are essentially "number(5)", but currently, ZPA interprets the length...

[assemble] Jlink doesn't support cross-platform linking for JDKs with JEP 493 (Temurin 24+)

1

### Task List - [x] Steps to reproduce provided - [ ] Stacktrace (if present) provided - [x] Example that reproduces the problem (link to git repository is ideal) -...