The MariaDB Foundation has announced the release of MariaDB 12.2.1 as a release candidate, marking a significant advancement in the capabilities of this popular database management system. This latest version introduces a range of enhancements aimed at improving compatibility with established systems, particularly MySQL and Oracle, while also refining its optimizer and performance tools.
Key updates include the highly anticipated Oracle TO_NUMBER function, which simplifies number conversion for users familiar with Oracle syntax, alongside the new TRUNC() function that facilitates rounding numbers down. These practical additions are designed to enhance user experience and streamline data handling.
Moreover, developers working with JSON data will benefit from the removal of the previous 32-depth limit on certain functions, allowing for more complex data structures. The update also expands MariaDB's built-in metadata capabilities with the introduction of new INFORMATION_SCHEMA tables and columns, further enhancing its adaptability and power.
In addition to new features, version 12.2.1 addresses several known issues, including fixing the inaccuracies in derived GROUP BY tables' out_rows estimates and providing improved visibility into triggers through the new INFORMATION_SCHEMA.TRIGGERED_UPDATE_COLUMNS view. Furthermore, the handling of stored procedure parameter defaults has been made more consistent with the addition of the PARAMETERS.PARAMETER_DEFAULT column.
In summary, the release candidate 12.2.1 presents significant improvements in performance, flexibility, and compatibility, reinforcing MariaDB's position as a leading database solution. Users can look forward to tangible benefits that enhance their experience and operational efficiency.
For more details, please refer to the official announcement linked below:
MariaDB 12.2.1 Release Candidate now available
The MariaDB Foundation is excited to share the availability of MariaDB 12.2.1, the latest release candidate (RC) in this ongoing series of updates
Key updates include the highly anticipated Oracle TO_NUMBER function, which simplifies number conversion for users familiar with Oracle syntax, alongside the new TRUNC() function that facilitates rounding numbers down. These practical additions are designed to enhance user experience and streamline data handling.
Moreover, developers working with JSON data will benefit from the removal of the previous 32-depth limit on certain functions, allowing for more complex data structures. The update also expands MariaDB's built-in metadata capabilities with the introduction of new INFORMATION_SCHEMA tables and columns, further enhancing its adaptability and power.
In addition to new features, version 12.2.1 addresses several known issues, including fixing the inaccuracies in derived GROUP BY tables' out_rows estimates and providing improved visibility into triggers through the new INFORMATION_SCHEMA.TRIGGERED_UPDATE_COLUMNS view. Furthermore, the handling of stored procedure parameter defaults has been made more consistent with the addition of the PARAMETERS.PARAMETER_DEFAULT column.
In summary, the release candidate 12.2.1 presents significant improvements in performance, flexibility, and compatibility, reinforcing MariaDB's position as a leading database solution. Users can look forward to tangible benefits that enhance their experience and operational efficiency.
For more details, please refer to the official announcement linked below:
MariaDB 12.2.1 Release Candidate now available
The MariaDB Foundation is excited to share the availability of MariaDB 12.2.1, the latest release candidate (RC) in this ongoing series of updates
MariaDB 12.2.1 Release Candidate released
MariaDB Foundation has released the latest release candidate, 12.2.1. The new release offers improvements and refinements in various areas, including deeper compatibility with established systems like MySQL and Oracle, as well as enhancements to the optimizer and performance tools. Additionally, it includes practical additions such as the long-awaited Oracle TO_NUMBER function and a TRUNC() function to round numbers down, making number conversion easier. The update also addresses several issues and expands MariaDB's built-in metadata capabilities, solidifying its position as a strong database option.
MariaDB 12.2.1 Release Candidate released @ Linux Compatible
