Hasty Briefsbeta

MySQL 9.4 Is Released

5 days ago
https://dev.mysql.com/doc/relnotes/mysql/9.4/en/news-9-4-0.html
Copy Link
  • #Release Notes
  • #MySQL
  • #Bug Fixes
  • LDAP SASL authentication plugin installation issue when Option Tracker is already installed (Bug #37983282).
  • Important Change: IFNULL() in a LIKE clause raised ER_CANT_AGGREGATE_2COLLATIONS due to binary collation and NONE derivation. Fixed by adjusting collation derivation strength (Bug #37285902).
  • CREATE TABLE with non-ASCII identifier in generated column expression caused syntax error if client charset wasn't UTF-8 compatible (Bug #30453221).
  • Group Replication: TASK_EVENT_TRACE in gcs_profile.in broke GCS/XCOM build (Bug #38042851).
  • macOS: Server compilation now possible with -DWITH_KERBEROS and aligned buffer for status variables (Bug #38042758).
  • Upgraded bundled libcurl to 8.14.1 (Bug #38042758).
  • MySQL Server now supports CMake 4 (Bug #38027636).
  • Use -DWITH_PROTOBUF=system for faster builds (Bug #38022751).
  • Removed warning in gcs_xcom_networking.cc (Bug #38021787).
  • System bzip2 library now located by cmake before linking (Bug #38005363).
  • MySQL Server now requires GCC 11 or later; ARM RHEL7 support removed (Bug #38004285).
  • Removed CMake workaround; minimum CMake version is 3.14.6 (Bug #37901122).
  • Upgraded ICU to 77-1 and zstd to 1.5.7 (Bugs #37870791, #37869972).
  • Fixed Clang 20 warnings (Bug #37785251).
  • Disabled clang::musttail with GCC 15 (Bug #37776018).
  • Worked around CMake list handling issue (Bug #37709169).
  • Compiler features tests now pass with -fprofile-use (Bug #37707556).
  • MySQL Server on RHEL 9 now built with GCC 14 (Bug #37702396).
  • Boost version raised to 1.87.0 (Bug #37403602).
  • Fixed linker issue with ${ICU_LIBRARIES} (Bug #36524167).
  • macOS: Now looks for generic openssl symlink (Bug #35468370).
  • Silenced deprecation warnings on macOS (Bug #34776172).
  • UDF unregistration issue fixed (Bug #35772996).
  • Dynamic loader improved to register services after init() (WL #16918).
  • Windows: MySQL Configurator fixes for in-place upgrades and custom settings (Bugs #37917039, #37481548, #37463478, #37460190, #37460173, #37460061).
  • Windows: MySQL Enterprise Firewall Component support added (WL #16760).
  • Increased back_log default to 10000 (WL #16888).
  • Added server_memory to limit physical memory usage (WL #16938).
  • Deprecated MySQL plugin API (WL #16574).
  • Removed temptable_use_mmap (WL #16745).
  • Deprecated MD5() and SHA1() (WL #16955).
  • MySQL Enterprise Firewall Component introduced (WL #16570).
  • Memory management improvements (Bug #37826893).
  • Fixed information_schema.innodb_cmp_per_index issue (Bug #37820227).
  • Fixed table import issue (Bug #37621360).
  • Changed innodb_change_buffer_max_size default to 5 (WL #16968).
  • macOS: Fixed plugin-dir issue (Bug #36816216).
  • Debian packages now support rootless installations (Bug #37765153).
  • RPM/Yum support for RHEL/Oracle Linux 10 (Bug #37592019).
  • Fixed MLE component memory issue (Bug #37952656).
  • Upgraded Graal Maven to 24.2.1.0.1 (Bug #37938310).
  • Upgraded GraalVM and Truffle library (Bug #37833200).
  • Fixed mysqldump --routines issue (Bug #37498680).
  • Added BIT type support for JavaScript routines (WL #16885).
  • Added WebAssembly library support (WL #16794, WL #16824, WL #16834, WL #16951).
  • ECMAScript 2024 compliance (WL #16887).
  • Added JSON duality views (WL #16616, WL #16617, WL #16618, WL #16619, WL #16623).
  • Added CPU and memory logging (WL #16940).
  • Fixed VECTOR_TO_STRING() collation (Bug #37815490).
  • Added mysql client --commands option (WL #16949).
  • InnoDB: Improved debugging (Bug #35115629).
  • Group Replication: Added ER_GRP_RPL_APPLIER_THD_KILLED (Bug #37764717).
  • NDB Replication: Added binary log slicing (WL #15413).
  • Increased query printing limit during signal handling (Bug #37603354).
  • Upgraded bundled curl to 8.14.1 (Bug #37389565).
  • Group Replication: Fixed connection attempts to old members (Bug #37704514).
  • Performance: Fixed redundant condition optimization (Bug #37808260).
  • NDB Cluster: Fixed simultaneous restart issue (Bug #37994985).
  • NDB Cluster: Improved ALTER TABLE lock handling (Bug #37955025).
  • InnoDB: Optimized foreign key checks (Bug #37867653).
  • InnoDB: Fixed pthread_setaffinity_np interpretation (Bug #37825544).
  • InnoDB: Fixed primary key rebuild issue (Bug #37822992).
  • InnoDB: Fixed column drop issue (Bug #37726881).
  • InnoDB: Removed OpenTelemetry symbols (Bug #37689163).
  • InnoDB: Optimized double write buffer (Bug #37684656).
  • InnoDB: Fixed DELETE operation issue (Bug #37478594).
  • InnoDB: Fixed secondary index memory allocation (Bug #37233273).
  • InnoDB: Fixed spatial datatype indexing (Bug #36682518).
  • InnoDB: Fixed temptable handler shutdown (Bug #36538081).
  • InnoDB: Fixed redo log consumer lag (Bug #36330455).
  • InnoDB: Fixed range query issue (Bug #31360522).
  • Partitioning: Fixed truncation issue (Bug #35912852).
  • Replication: Fixed CREATE TABLE ... AS SELECT inconsistency (Bug #37986380).
  • Replication: Fixed memory management issue (Bug #37371443).
  • Replication: Fixed semisync protocol change (Bug #37024069).
  • Group Replication: Fixed Gr_empty_consensus_proposals_count (Bug #37937927).
  • Group Replication: Fixed stuck transactions (Bug #37764970).
  • NDB Cluster APIs: Fixed VARCHAR exclusion issue (Bug #37766391).
  • RPM: Fixed Fedora 24 installation (Bug #37976913).
  • Fixed BETWEEN assert (Bug #37952274).
  • Fixed trigger execution issue (Bug #37915445).
  • Fixed transform_table_subquery_to_join_with_derived issue (Bug #37884336).
  • Fixed memory leak in item_cmpfunc.cc (Bug #37883669).
  • Fixed HLL() function behavior (Bug #37839325).
  • Fixed CTE subquery handling (Bug #37832605).
  • Fixed server startup with keyring and binlog_encryption (Bug #37821740).
  • Removed opt_costconstantcache.cc warning (Bug #37814484).
  • Fixed Oracle package installation on Ubuntu 25.04 (Bug #37804480).
  • Fixed RPM conflicts with MariaDB (Bug #37798784).
  • Improved client connection termination (Bug #37755594).
  • Fixed INTERSECT assert (Bug #37742092).
  • Adapted Fedora 42 RPM packages (Bug #37737658).
  • Improved InnoDB fulltext search performance (Bug #37682648).
  • Fixed keyring_okv plugin issue (Bug #37655299).
  • Removed sql_resolver.cc assertion (Bug #37601389).
  • Fixed subquery materialization check (Bug #37587388).
  • Fixed mysql client bug (Bug #37572191).
  • Fixed mysql_secure_installation password check (Bug #37563088).
  • Fixed init file handling (Bug #37559598).
  • Fixed CREATE TABLE/DROP TABLE sequence (Bug #37534068).
  • Fixed caching SHA-2 authentication performance (Bug #37523469).
  • Fixed UPDATE rollback issue (Bug #37489167).
  • Fixed DEFAULT column expressions (Bug #37436220).
  • Fixed correlated subquery aggregation (Bug #37415167).
  • Fixed Windows MSI installer VC++ check (Bug #37365476).
  • Fixed unquoted semicolon in comments (Bug #37117875).
  • Fixed keyring_aws memory leak (Bug #36684413).
  • Fixed nested aggregate function handling (Bug #36421727).
  • Fixed subquery to derived table transform (Bug #36421710).
  • Fixed max_join_size processing (Bug #35625769).
  • Fixed scalar subquery transform (Bug #35150438).
  • Fixed EXPLAIN ANALYZE FORMAT=JSON (Bug #37285902).
  • Fixed SET TRANSACTION ISOLATION LEVEL PERSIST (Bug #36854635).
  • Fixed query rewrite plugin with autocommit=OFF (Bug #36784795).
  • Fixed MIN() window function null handling (Bug #36182490).
  • Fixed RANGE frame nondeterministic ORDER BY (Bug #35521787).
AboutLogin