SQL Enlight Code Quality for SonarQube 2.2.4 Released

By Blog Author

We’re pleased to announce the release of SQL Enlight Code Quality for SonarQube 2.2.4.

This release introduces four new SQL analysis rules, along with performance optimizations, bug fixes, and general enhancements to make SQL code analysis faster, more reliable, and even more comprehensive.

What’s New

The following static analysis rules have been added to help detect data type compatibility issues:

  • SA0276 – Detects assignments where the type of the assigned value is not compatible with the variable’s declared data type.
  • SA0277 – Detects INSERT and UPDATE statements where the value is incompatible with the target column type, potentially causing implicit conversions or data truncation.
  • SA0278 – Detects simple CASE expressions where the input expression and the WHEN expressions are not of the same data type.
  • SA0279 – Detects CASE expressions whose result expressions are not of the same data type.

In addition to the new rules, this release includes:

  • Improved analysis performance
  • Multiple bug fixes
  • Stability and reliability improvements
  • General enhancements across the plugin

Upgrade Today

We recommend upgrading to SQL Enlight Code Quality for SonarQube 2.2.4 to benefit from the latest improvements and expanded SQL analysis capabilities.

The SQL Enlight Code Quality plugin is available for download here; details about it can be found here.

Thank you for using SQL Enlight Code Quality for SonarQube. Your feedback and suggestions continue to help us improve every release.