Oracle formed the new division of the DBMS MySQL 9.3.0. The MySQL Community 9.3.0 is prepared for all major distributions of Linux, FreeBSD, MacOS, and Windows. In 2023, a new model of release formation was introduced where MySQL 9.3 is categorized under the “Innovation” branches. Innovation branches are recommended for those seeking early access to new functionality, are released every 3 months, and are only supported until the next significant release (e.g. after the release of branch 9.3, support for branch 9.2 ends). An LTS release 9.4 is expected in the summer, recommended for implementations requiring predictability and long-term unchanged behavior. Following the LTS release will be the new Innovation-View-MySQL 10.0.
The main changes in MySQL 9.3:
- In the utility MySQLDUMP, the option “–users” is added to create logical dumps with information on user accounts displayed through SQL expressions like “Create User” and “Grant”. The option “–add-drop-User” is provided to include “Drop User” before “Create User”. Additionally, selective reflections in dumps for individual users can be achieved using options “–include-user=user@host” and “–exclude-user=user@host”, which can be specified multiple times.
- In the multilingual engine component (mle), which allows the use of stored code and functions in different SQL languages, JavaScript support has been enhanced. Decimal type in JavaScript can now be used for incoming and returned arguments, with the option to convert MySQL Decimal type into JavaScript type “Number” using ‘Select Mle_Set_SESSION_STATE(‘Decimal_type”:”Number}’)’. Decimal values can be supported with JavaScript types Boolean, Number, String, and Bigint.
- In stored procedures on JavaScript, localization using JavaScript API intl