Skip to main content

ZPA 3.7.0

· One min read
Maintainer

ZPA 3.7.0 is out! This version brings minor bug fixes and dependency updates. This is the last release compatible with SonarQube 9.9, read the post Important Update on SonarQube Support for more details.

  • SonarQube compatibility: Compatible with SonarQube 9.9 LTA Community Edition and newer.
  • Improve support for constraints in table declarations.

For detailed release notes, please visit the full changelog.

Important Update on SonarQube Support

· 2 min read
Maintainer

At the end of 2024, SonarSource introduced significant changes to the release cycle and versioning of SonarQube Community Edition, now known as SonarQube Community Build. One of the most impactful changes is the removal of a long-term active (LTA) equivalent version for the Community Build. Community builds are now released monthly, while commercial editions follow a separate quarterly release cycle with an annual LTA version.

I would like to clarify my stance on support for SonarQube commercial editions. I have never officially supported the commercial editions, as I do not have access to them for testing. Moving forward, I will no longer be making an effort to maintain compatibility with SonarQube commercial editions, and the ZPA plugin may explicitly prevent execution in those environments.

While SonarSource has announced that they will only support the latest SonarQube Community Build, I remain committed to testing my plugin with the four most recent releases, ensuring greater stability and flexibility for users who may need time to update to newer SonarQube versions.

ZPA 3.7.x will be the last release to offer compatibility with SonarQube 9.9 LTA. Future releases will require at least SonarQube 25.x (with the specific release version to be determined at the time of release). I do not intend to keep the plugin compatible with SonarQube 2025.1 LTA.

If you have any questions, feel free to reach out or contribute to the discussion in the project repository.

ZPA 3.6.0

· One min read
Maintainer

ZPA 3.6.0 is out! This version brings several new features, improvements, and bug fixes.

  • SonarQube compatibility: Compatible with SonarQube 9.9 LTA Community Edition and newer.
  • Enhanced support for various SQL syntax and functions, including:
    • SELECT without a FROM clause from Oracle 23ai, such as SELECT func()
    • DEFAULT value ON CONVERSION ERROR clause on all conversion functions that support it
    • IS TRUE/FALSE conditions
    • Alternative syntax for JSON_OBJECT (JSON { }) and JSON_ARRAY (JSON [ ])
  • Other bug fixes and performance improvements.

For detailed release notes, please visit the full changelog.

Related posts:

DevNotes #1 - Quoted Identifiers

· 2 min read
Maintainer

A few days ago, I discovered that ZPA was not handling quoted identifiers properly. Specifically, the component responsible for creating the symbol table was not correctly identifying and counting the usage of quoted identifiers. This led to inaccurate results, which could affect the quality of the code analysis.

DevNotes #0

· One min read
Maintainer

I intend to start a series of posts called "DevNotes" here. This series will be a collection of posts where I share some discoveries and experiences while developing ZPA and learning even more about PL/SQL and Oracle SQL.

In this series, I will cover a variety of topics related to PL/SQL, including:

  • Code analysis techniques: how ZPA analyzes PL/SQL code and the challenges involved.
  • Code analysis: methods to analyze PL/SQL code to improve performance and maintainability.
  • Best practices: tips and tricks for writing efficient and clean PL/SQL code.

ZPA 3.5.1

· One min read
Maintainer

ZPA 3.5.1 is out!

This is a bug fix release that addresses an issue with coverage import for package bodies declared in the same file as the package specification.

For detailed release notes, please visit the full changelog.

ZPA 3.5.0

· One min read
Maintainer

ZPA 3.5.0 is out! This version brings several new features, improvements, and bug fixes.

  • SonarQube compatibility: Compatible with SonarQube 9.9 LTA Community Edition and newer.
  • utPLSQL integration: First-class support for test and coverage reports generated by utPLSQL.
  • New grammar support: Added support for all SQL/JSON functions.
  • Numerous bug fixes and performance improvements.

For detailed release notes, please visit the full changelog.