Skip to main content

ZPA 4.2.0

· 2 min read
Maintainer

ZPA 4.2.0 is out! This is the largest expansion of Oracle SQL and PL/SQL grammar support in the project's history. Hundreds of syntax gaps were addressed, reducing the known parsing gaps in the integration test corpus to nearly zero.

  • SonarQube compatibility: Compatible with SonarQube Community Build 26.2 and newer (tested with 26.2 to 26.10).
  • Java 21: The plugin and the ZPA Toolkit now target Java 21.
  • Grammar: New or completed support for, among others:
    • DDL for tables, indexes, sequences, views, materialized views, domains, types, users, roles, tablespaces and pluggable databases
    • ALTER DATABASE, ALTER DISKGROUP, ADMINISTER KEY MANAGEMENT, AUDIT/NOAUDIT and other administration statements
    • MODEL, MATCH_RECOGNIZE, WINDOW and QUALIFY clauses, CROSS APPLY/OUTER APPLY and LATERAL inline views
    • SQL/JSON functions and JSON relational duality views
    • Vector datatype, functions and indexes, property graphs (GRAPH_TABLE) and MLE modules
    • Wrapped PL/SQL units
  • New rules:
  • utPLSQL: Six new rules for test code validate how utPLSQL reads the annotations: ConflictingUtPlSqlAnnotations, IneffectiveUtPlSqlAnnotation, InvalidUtPlSqlAnnotationArgument, InvalidUtPlSqlContextStructure, UnresolvedUtPlSqlSetupCleanupReference and UtPlSqlTestShouldHaveDescription (not activated by default). DisabledTest now reports every effective test annotated with %disabled, even when the annotation has a comment.
  • Project-aware analysis: ZPA now collects declarations from all files of the project, resolving package specifications, package bodies and RECORD types across files. Custom rules can use this information through an experimental API.
  • QueryWithoutExceptionHandling no longer reports single-group aggregate queries, which always return one row.
  • The ZPA Toolkit can now inspect the semantic information of the analyzed code.

For detailed release notes, please visit the full changelog.