MariaDB 11.7 is no longer maintained. Please use a more recent release.
MariaDB 11.7 is a rolling release.
are now included in the binaries
Numerous improvements ()
When is enabled, committing a large transaction no longer freezes all other transactions until completed ()
has been deprecated ()
Async rollback prepared transactions during binlog crash recovery ()
New variable, , for aborting long-running queries on a replica ()
New function for generating version 4 UUIDs ()
New function for generating version 7 UUIDs ()
Optimization improvement for single-table UPDATE/DELETE: make cost-based choice between subquery strategies ()
The is now on by default ()
Allow a to be converted from implicit to explicit row_start/row_end columns ()
New variable, , for specifying that all queries longer than this time are logged to the , regardless of and ()
ROW data type for stored function return values ()
Add optional correlation column list for ()
Implement ()
Allow arbitrary options in ()
, which used to be an alias for now shows the value of when the session was created ()
CURRENT_TIMESTAMP should return a TIMESTAMP (WITH TIME ZONE?) ()
A warning has been added when is exceeded. ()
()
The Spider variables and have been deprecated ()
New variable, , for increasing transaction concurrency for large transactions (MDEV-32014)
Alpha
21 Nov 2024
RC
21 Nov 2024
RC
25 Sep 2024
Release date: 13 Feb 2025
MariaDB 11.7.2 is a Stable (GA) release. It is an evolution of MariaDB 11.6 with several entirely new features.
MariaDB 11.7 is a rolling release. One is expected to upgrade to MariaDB 11.8.2, there will be no 11.7.3.
Thanks, and enjoy MariaDB!
Fix possible InnoDB hang while running out of buffer pool ()
Fix assertion failure on cascading foreign key update of table with vcol index in parent ()
Fix potential issue in secondary Index with ROW_FORMAT=COMPRESSED and Change buffering enabled ()
Fix issue where ON UPDATE SET NULL could not be specified on a NOT NULL column ()
Fix possible crash on DELETE from a HEAP table ()
Fix possible Spider thread hang in 'Update' state on 2nd INSERT ()
Fix possible crash on bootup in spider_sys_open_table «ext-issue»«», «ext-issue»«» ()
44 new added. These are aliases for MySQL collations to make it easier to replicate from MySQL to MariaDB ()
The includes a new column, COMMENT which contains information about which collation the alias refers to.
Fix assertion falilure and possible index corruption with unique key and nopad collation without DESC or HASH keys ()
Fix incorrect formatting of timestamp during parsing of a binary log, causing point in time recovery discrepancies ()
can now correctly process more than one logfile when --stop-datetime is specified ()
Setting pseudo_thread_id to a value exceeding 4 bytes previously resulted in truncation when written to the binary log ()
Fix server crash in get_sort_by_table/make_join_statistics after INSERT into a view with ORDER BY ()
Fix failing assertion causing disruption and replication failure ()
Conditions with SP local variables are now pushed into derived table. Previous behaviour caused slow performance and table scans instead of using the pushed down condition ()
NULL-aware materialization with IN predicate and single column no longer skips building sorted Ordered_key structures (
History is now stored on the same partitions on different Galera nodes when system versioning is enabled ()
Fix possible hang or crash during InnoDB purge with HASH indexes during ALTER TABLE ()
EXCHANGE PARTITION now works for tables with unique blobs ()
algorithm = instant can now correctly be used if a table has partitions and one tries to change a column with an index which is not the partitions key. This previously gave the error "ERROR 1846 (0A000): ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY". (
updated to 26.4.21
NOTE: Includes increasing the GCS protocol version, which prevents downgrades of individual nodes in the cluster as soon as all nodes have been updated
Fix streaming replication transaction crash with innodb_snapshot_isolation ()
Fix sporadic failure of async replication on Galera async replica nodes with parallel replication enabled (
For an authentication with the the password of the CREATE USER statement is now masked in the audit log ()
MariaDB Audit now detects all DCLs forms for masking a password ()
Adding a regular index on a vector column leads to invalid table structure ()
Vector values become zero after / restore, impacting data integrity for vector columns. ()
Server can crash when a SELECT query is including a DISTINCT and ORDER BY, and a vector index is used ()
Fix possible crash where server could not construct a geomery object from the input ()
Fix trigger created with "" which is adding rows to another table using "FOR EACH ROW insert into table2(id, name) values (NEW.id, NEW.name);" that did not work correctly when if bulk inserts are used by the application. Only the first row of the bulk insert would be added to the table ()
Fixes for the following :
For a complete list of changes made in , with links to detailed information on each push, see the .
For a full list of contributors to , see the .
Release date: 21 Nov 2024
MariaDB 11.7 is a rolling release. It is an evolution of MariaDB 11.6 with several entirely new features.
MariaDB 11.7.1 is a Release Candidate (RC) release.
Thanks, and enjoy MariaDB!
are a feature that allow MariaDB Server to perform as a relational vector database. Previously available in the special , it has now been added to MariaDB Community Server 11.7.1 with various enhancements ()
Data type VECTOR ()
Conversion functions VEC_FromText and VEC_ToText ()
Defaults change - the system variable now defaults to ON, previously was OFF ()
Fix attempt to read outside the bounds of the file: ./ibdata1 ()
Fix MariaDB crash with SIGILL because the OS does not support AVX512 ()
Fix deadlock caused by lock_rec_unlock_unmodified() ()
Fix server crash when calling after is enabled ()
SELECT MIN on Spider table no longer returns more rows than expected ()
Fix Spider group by handler wrong result on order by aggregate ()
Fix Storage Engine S3 that caused 500 error when using Huawai Cloud S3 and possibly other S3 providers ()
A new option has been added. s3-provider=Huawai needs to be set for Huawai Cloud S3
Fix crash caused by query containing constant having clause ()
Fix assertion with optimizer_join_limit_pref_ratio and 1-table select ()
Fix InnoDB crash under Windows Subsystem for Linux on ALTER TABLE or OPTIMIZE TABLE ()
Fix case where modification of the column incorrectly checked foreign key constraint ()
Fix incorrect NULL value handling for instantly dropped BLOB columns ()
Galera updated to 26.4.20
Fix server crash when setting wsrep_cluster_address after adding invalid value to wsrep_allowlist table ()
TOI (ALTER) no longer hangs on a parent table if SR transaction is in progress on a child table ()
Fix INSERT...SELECT' on MyISAM table suddenly replicated by alera ()
Recovery now correctly notes some log corruption ()
InnoDB now correctly merges the change buffer to ROW_FORMAT=COMPRESSED tables ()
Can now selectively restore sequences using innodb tables from backup ()
now properly unquotes strings ()
default values now allows non-string literals ()
New function for generating version 4 UUIDs ()
New function for generating version 7 UUIDs ()
As per the , this will be the last release of for Windows 11 22H2
no longer hangs on startup when --init-file target does not exist ()
LOAD DATA INFILE with geometry data no longer fails ()
Fix heap-use-after-free in group_concat with compressed or GIS columns ()
For a complete list of changes made in , with links to detailed information on each push, see the .
For a full list of contributors to , see the .
Release date: 25 Sep 2024
MariaDB 11.7 is a rolling release. It is an evolution of MariaDB 11.6 with several entirely new features.
MariaDB 11.7.0 is a single preview release. Features are to be considered preview, and none are guaranteed to make it into MariaDB 11.7.
The preview is available as a container quay.io/mariadb-foundation/mariadb-devel:11.7-preview.
Thanks, and enjoy MariaDB!
When is enabled, committing a large transaction no longer freezes all other transactions until completed ()
has been deprecated ()
Async rollback prepared transactions during binlog crash recovery ()
New variable, , for aborting long-running queries on a replica ()
New function for generating version 4 UUIDs ()
New function for generating version 7 UUIDs ()
Optimization improvement for single-table UPDATE/DELETE: make cost-based choice between subquery strategies ()
The is now on by default ()
New GIS functions. These functions improve compatibility with MySQL 8. Note that these were not included in
()
()
()
()
Allow a to be converted from implicit to explicit row_start/row_end columns ()
New variable, , for specifying that all queries longer than this time are logged to the , regardless of and ()
ROW data type for stored function return values ()
Add optional correlation column list for ()
()
Implement ()
Allow arbitrary options in ()
, which used to be an alias for now shows the value of when the session was created ()
CURRENT_TIMESTAMP should return a TIMESTAMP (WITH TIME ZONE?) ()
A warning has been added when is exceeded. ()
()
The Spider variables and have been deprecated ()
New parameter --skip-freed-pages for . Use this parameter to not get freed undo logs reported as existing undo log pages. (MDEV-35394)
Cloning of table statistics while saving the InnoDB table stats is now avoided (MDEV-35363)
InnoDB deadlock output query length increased to improve visibility of deadlocked statements. (MDEV-32576)
now works with INDEX DESC (MDEV-35169)
Fix occasional failure of recovery of a multi-batch operation with InnoDB on startup (MDEV-35699)
Fix client crash the command after client sets character set to utf32 (MDEV-34090)
Fix possible runtime error caused by XA RECOVER applying a zero offset to a null pointer (MDEV-35549)
Fix issue where functions in default values in tables with certain character sets could break SHOW CREATE and mariadb-dump (MDEV-29968)
no longer ignores binary log events written with system timestamp 4294967295 and possibly all following events, avoiding potential data loss during recovery from binlogs (MDEV-33239)
Table flags, preserved from the old storage engine after changing the storage engine of a table, can no longer break replication (MDEV-31794)
Fix issue where / ALL REPLICAS errors without returning an error if the command could be executed due to wrong privileges. (MDEV-21858)
Fix possibly wrong result using a degenerated subquery (SELECT ) with window function (MDEV-35869)
Fix possible failure of wsrep_sst_rsync SST script if user specified aria_log_dir_path different from default data directory (MDEV-35387)
Fix cluster node hang during shutdown if threadpool is used (MDEV-35710)
MariaDB Cluster and ALTER INPLACE running in Total Order Isolation (wsrep_OSU_method=TOI) now correctly abort a DML INSERT operation in InnoDB (MDEV-33064)
Fix possible crash in wsrep_check_sequence (MDEV-33245)
Fix sporadic reporting of success when a deadlock error occurs under --ps-protocol BF aborted transaction (MDEV-35446)
Rows in table mysql.gtid_slave_pos are now correctly deleted on Galera nodes when wsrep_gtid_mode = 1 is used, which previously lead to wrong information about replica delays (MDEV-34924)
Undefined behavior could occur when attempting to perform INSERT DELAYED on a Galera cluster node. (MDEV-35852)
Fix issue where DROP TABLE on child and UPDATE of parent table can cause a metadata lock BF-BF conflict when applied concurrently. (MDEV-35018)
Galera protocol versions are now shown by show status - change available with installation of galera library 26.4.21+ (MDEV-35505)
Fix possible crash in wsrep_sst_mariadb-backup script when upgrading node in cluster from 10.11.9 to 10.11.10. (MDEV-35526)
wsrep_sst_mariadb-backup.sh no longer uses --use-memory default (100MB) resulting in prepare stage which could take hours (MDEV-35749)
NOTE: System tables should never be modified by a user anyhow (MDEV-33783)
Fix connection hang after query on a partitioned table with UNION and LIMIT ROWS EXAMINED (MDEV-35571)
Fix possible crash during index traversal using tree_search_next. (MDEV-28130)
FIx assertion failure where CURRENT_USER was not correctly copied during condition pushdown (MDEV-35090)
START TRANSACTION, when triggering an implicit commit as a COMMIT or ROLLBACK has not been executed before, now resets optional characteristics added to the last START TRANSACTION command (MDEV-35335)
sql_mode='NO_UNSIGNED_SUBTRACTION' now works for multiple unsigned integers (MDEV-35651)
The "Failed to write to mysql.slow_log" error no longer shown without a detailed reason for the error (MDEV-20281)
Fix doublewrite recovery of innodb_checksum_algorithm=full_crc32 encrypted pages (MDEV-34898)
Can now correctly add a foreign key on a table with a long UNIQUE multi-column index that contains a foreign key as a prefix (MDEV-33658)
During an online table rebuild of an InnoDB statistics table, opt_search_plan_for_table() no longer sometimes degrades to full table scan (MDEV-35443)
Fix debian-start script failure when using non-standard socket path (MDEV-35907)
Fix possible hang or crash where zero offset applied to null pointer (MDEV-35864)
Fixed issue where ST_PointFromWKB ignored SRID parameter and returned 0 (MDEV-32619)
Fix possible hang during CREATE TABLE…SELECT error handling, especially with innodb_snapshot_isolation enabled (MDEV-35647)
Fix incorrect locking order of LOCK_log/LOCK_commit_ordered and LOCK_global_system_variables (MDEV-29744)
Fix rare cases where binlog entries could receive incorrect timestamps on secondary nodes of a Galera cluster, potentially impacting replication accuracy (MDEV-35157)
Fix possible memory leak on SHUTDOWN (MDEV-35326)
Fix possible memory leak while shutting down server after installing the auth_gssapi plugin (MDEV-35575)
Fix possible server crash when using INSERT DELAYED on tables with virtual columns. (MDEV-26891)
Fix possible Spider crash or hang when the first byte of a connection key is changed (MDEV-34849)
A BEFORE INSERT Trigger previously returned with error ""Field 'xxx' doesn't have a default value", if a NULL value is added for a column defined NOT NULL without explicit value and no DEFAULT specified (MDEV-19761)
Calling a stored routine that executes a join on three or more tables and referencing not-existent column name in the USING clause could previously result in a crash on its second invocation. (MDEV-24935)
Fix rare cases where binlog entries could receive incorrect timestamps on secondary nodes of a Galera cluster, potentially impacting replication accuracy (MDEV-35157)
Comparison of UUID v1 and V6 could return incorrect results (MDEV-35468)
INSERT SELECT on NOT NULL columns with BEFORE UPDATE trigger can fail with error 1048 (23000) (MDEV-36026)
It was not possible to use a package body variable as a fetch target, instead error "Undeclared variable" was returned. (MDEV-36047)
Validation of SSL certificate fails for mariadb-backup. For a MariaDB Cluster (Galera) SST operations can be affected (MDEV-35368)
Upper limit for one MHNSW vector index cache
Default value for the DISTANCE vector index option
Default value for the M vector index option
Defines the minimal number of result candidates to look for in the vector index for ORDER BY … LIMIT N queries.
Fix duplicate key error in table 'mysql.innodb_table_stats' (MDEV-34207)
Fix possible adaptive hash index corruption with ALTER TABLE...IMPORT TABLESPACE and FULLTEXT SEARCH (MDEV-35059)
XA prepare now correctly releases unmodified records in non-blocking mode (MDEV-34466)
Fix contention between secondary index UPDATE and purge due to large innodb_purge_batch_size (MDEV-34515)
Fix redundant page lookups that hurt performance (MDEV-34791)
Implement on 64-bit systems for improving ib_logfile0 reads (MDEV-34062)
Fix case where with wsrep_mode=REPLICATE_ARIA, only part of the mixed-engine transactions was replicated (MDEV-30653)
Fix galera_ssl_reload failure with warning message (MDEV-32778)
When InnoDB gets an assertion failure, WSREP layer is now handled gracefully (MDEV-32363)
Fix assertion `!is_cond()' failed in Item_bool_func::val_int / do_select (MDEV-35135)
Trigger now works correctly with bulk update (MDEV-34718)
Fix assertion failure in find_producing_item upon a query from a view (MDEV-35276)
Add new setting, to the mariadb client for use in --quick mode (MDEV-34704)
New variable, , for increasing transaction concurrency for large transactions (MDEV-32014)
MariaDB 11.7 was a rolling release, and is no longer maintained.
Do not use non-stable (non-GA) releases in production!
Do not use non-stable (non-GA) releases in production!
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL