MySQL 9.4.0 Release

Oracle has released a new branch of the MySQL 9.4.0 database management system. MySQL Community Server 9.4.0 builds are available for all major distributions. Linux, FreeBSD, macOS и WindowsIn accordance with the release model implemented in 2023, MySQL 9.4 is assigned to the "Innovation" branch. Innovation branches are recommended for those who want early access to new functionality. They are released every three months and are supported only until the next major release (for example, after the release of branch 9.4, support for branch 9.3 ended). LTS release 9.5 is planned for release in the fall, recommended for deployments that require predictability and long-term stability. Following the LTS branch, a new Innovation branch—MySQL 10.0—will be released.

Major changes in MySQL 9.4:

• Stored procedures written in JavaScript support the BIT type. BIT values less than or equal to JavaScript.MAX_SAFE_INTEGER are converted to the JavaScript Number type, and larger values are converted to the JavaScript BigInt type.
• The mysql command line utility has a new option "--commands" that allows you to enable support for running local commands (commands are disabled by default):
  • charset
  • clear
  • connect
  • edit
  • ego
  • exit
  • go
  • help
  • nopager
  • notee
  • nowarning
  • pay
  • print
  • prompt
  • query_attributes
  • quit
  • rehash
  • reset connection
  • ssl_session_data_print
  • source
  • professional status
  • system
  • tee
  • \u
  • warnings
• The firewall plugin, which allows filtering SQL queries to the DBMS based on specified templates, has been replaced by the MySQL Enterprise Firewall component, which implements identical functionality except for support for account profiles (group profiles are supported instead). The firewall plugin has been declared deprecated and will be removed in one of the next releases. MySQL Enterprise Firewall is only available to users of the commercial version of MySQL Enterprise Edition.
• 30 vulnerabilities have been fixed, one of which can be exploited remotely if there is access to send queries to the DBMS. The four most serious issues have a severity level of 6.5 and are related to vulnerabilities in DML and the optimizer. Less serious vulnerabilities affect InnoDB, the optimizer, stored procedures, LDAP Auth, and the replication system.

Source: opennet.ru