ZPA 4.2.0
· 2 min read
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/NOAUDITand other administration statementsMODEL,MATCH_RECOGNIZE,WINDOWandQUALIFYclauses,CROSS APPLY/OUTER APPLYandLATERALinline 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:
- DeterministicFunction: deterministic functions should not depend on external state
- FunctionShouldBeDeterministic: consider declaring suitable functions
DETERMINISTIC(not activated by default) - PackageBodyParameterNocopy: package body parameters should match the
specification's
NOCOPYqualification - SequenceNextvalInConditionalResult: sequence
NEXTVALshould not be used in conditional results - UnnecessaryStringLiteralConcatenation: adjacent string literals should be merged
- 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
RECORDtypes 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.