On July 1st, 3 new releases of MySQL came out. Indeed, we released the next 8.0 (8.0.38), the first update of the 8.4 LTS (8.4.1), and the very first 9.0 as Innovation Release. We now support 3 versions of the most popular Open Source database.
With these releases, we also want to thank all the great contributors who send patches to MySQL.
For some time now, all the contributors have also been highlighted in the Release Notes, but we never thank enough, so let’s take back the good habits of listing them in a dedicated blog post.
Some contributions were merged into multiple versions. Let’s have a look at all these contributions:
MySQL 8.0
As I missed some releases, I would like to go back in time, so these contributions cover the releases from 8.0.34 to 8.0.38.
Clients & C API
- #92755 – Fix mysqldump querying column stats – Meta [8.0.34]
- #98350 – Initialize error variable – Meta [8.0.34]
- #98352 – Check net before deference – Meta [8.0.34]
- #98385 – Mysqladmin related – Meta [8.0.34]
- #110658 – mysql_binlog_xxx() symbols are not exported in lybmysqlclient.so – Yura Sorokin (Percona) [8.0.34]
MySQL Cluster (NDB)
- #103814 – ClusterJ partition key scratch buffer size too small – Mikael Ronström [8.0.34]
- #110807 – Add missing s390x support for NDB – Namrata Bhave [8.0.36]
- #112775 – Rondb 475 contribute – Mikael Ronström [8.0.36]
- #114147 – [RONDB-620] Foreign key column ordering mismatch – Axel Svensson [8.0.38]
MySQL Server
- #105092 – AUTO_INCREMENT can be set to less than MAX + 1 and not forced to MAX + – Dmitry Lenev (Percona) [8.0.34]
- #109576 – Contribution: Fix scramble algorithm docs – Niklas Keller [8.0.34]
- #110251 – change information about get_lock error message – Bin Wang [8.0.34]
- #110494 – Deadlock between FLUSH STATUS, COM_CHANGE_USER and SELECT FROM I_S.PROCESSLIST – Dmitry Lenev (Percona) [8.0.34]
- #110801 – prepared stmt issue – Hao Lu [8.0.35]
Replication
- #107996 – wrong default value of geometry column – Yin Peng (Tencent) [8.0.34]
- #109154 – Fix incorrect suggested commands to start slave in error logs … – Dan McCombs [8.0.34]
- #109485 – Previous_gtids miss gtid when binlog_order_commits off – Yewei Xu (Tencent) [8.0.34]
InnoDB / Clone
- #109873 – no need to maintain err in buf_page_init_for_read – Alex Xing [8.0.34]
- #110569 – Clone plugin sometimes failed, errno 22 – Yin Peng(Tencent) [8.0.35]
- #110652 – InnoDB：trx hangs due to wrong trx->in_innodb value – Shaohua Wang [8.0.37]
- #111823 – mysqldb instant column – Richard Dang [8.0.37]
- #112137 – parallel read is slow when innodb_use_native_aio = off – Ke Yu [8.0.37]
- #112424 – Crash during background rollback if both prepare and active transaction exist – Genze Wu [8.0.37]
- #114154 – Parallel read is slow after partition table is read in parallel – Ke Yu [8.0.38]
- #115041 – Unused heap in function Validate_files::check – Huaxiong Song [8.0.38]
Optimizer
- #109979 – Query with GROUP_CONCAT and ROLLUP – Dmitry Lenev (Percona) [8.0.34]
- #111465 – Issue with cached queries – Nicholas Othieno (Amazon) [8.0.35]
Performance_Schema
- #104121 – Ensure that prepared statements are shown correctly in PERFORMANCE_SCHEMA.THREADS – Dishon Merkhai (Amazon) [8.0.38]
Full Text Search
- #114156 – fts_sync_commit is not crash safe – Yin Pen (Tencent) [8.0.37]
Compiling
- #110216 – failed to compile in static mode – Alex Xing [8.0.34]
- #111190 – Build fails with LANG=ja_JP.UTF-8 – Kento Takeuchi [8.0.34]
- #111549 – Fix system zlib version detection –Nikolai Kostrigin [8.0.34]
- #111467 – Set variables to PARENT_SCOPE in CMake functions – Meng-Hsiu Chiang (Amazon) [8.0.35]
- #110808 – sql/memory: Fix build on musl – Sam James [8.0.36]
- #112209 – The warning of deprecated function in openssl3 not be supressed – Karry Zhang [8.0.36]
- #112845 – On s390x, use the stckf instruction to get the cycles timer… – Jonathan Albrecht [8.0.37]
- #113095 – s390x is a big endian platform so use the big endian icu data – Jonathan Albrecht [8.0.37]
- #113096 – On s390x, compile the FMA test with -O2 to avoid over-optimiz … – Jonathan Albrecht [8.0.37]
- #114064 – Unified behaviour when calling \”plugin->deinit\” for all plugins – Martin Alderete [8.0.37]
MySQL 8.4
I’m also including the contributions of 8.3.
Clients & Connectors
- #107107 – Redundant “Reset stmt” when setting useServerPrepStmts&cachePrepStmts to true – Marcos Albe (Percona) [8.3]
- #110286 – Only call Messages.getString(…) when it’s needed – Janick Reynders [8.4]
- #110784 – cdk: Use cmake’s FindOpenSSL, not custom FindSSL module – Sam James [8.4]
- #111031 – Update SyntaxRegressionTest.java – Abby Palmero [8.4]
- #113599 – Replace StringBuffer with StringBuilder in ValueEncoders – Henning Pöttker [8.4]
- #113600 – Contribution: Fix join condition for retrieval of imported primary keys – Henning Pöttker [8.4]
- #113766 – Fix compile errors on GCC 14 – Christopher Fore [8.4]
- #114272 – Fix deadlock in mysql poolmanager attempt #2 – Marek Matys [8.4]
InnoDB
- #108731 – just need to maintain FIL_PAGE_LSN once during recovery – Alex Xing [8.3]
- #111823 – issue with upgrades and instant columns – Richard Dang [8.3]
- #112532 – Innodb_row_lock_current_waits values show non-zero when there is no lock – Bin Wang [8.3]
- #110652 – InnoDB：trx hangs due to wrong trx->in_innodb value – Shaohua Wang [8.4]
- #112137 – parallel read is slow when innodb_use_native_aio = off – Ke Yu [8.4]
- #112424 – Crash during background rollback if both prepare and active transaction exist – Genze Wu [8.4]
- #114154 – Parallel read is slow after partition table is read in parallel – Ke Yu [8.4.1]
- #115041 – Unused heap in function Validate_files::check – Huaxiong Song [8.4.1]
Compiling
- #112209 – The warning of deprecated function in openssl3 not be supressed – Karry Zhang [8.3]
- #112845 – On s390x, use the stckf instruction to get the cycles timer v … – Jonathan Albrech [8.3]
- #110808 – sql/memory: Fix build on musl – Sam James [8.4]
- #112845 – On s390x, use the stckf instruction to get the cycles timer… – Jonathan Albrecht [8.4]
- #113095 – s390x is a big endian platform so use the big endian icu data – Jonathan Albrecht [8.4]
- #113096 – On s390x, compile the FMA test with -O2 to avoid over-optimiz … – Jonathan Albrecht [8.4]
- #114064 – Unified behaviour when calling “plugin->deinit” for all plugins – Martin Alderete [8.4.1]
Optimizer
- #112304 – MEM_ROOT::AllocBlock() does not satisfy minimum_length bigger than wanted_length – Kaiwang Chen [8.3]
- #112426 – wrong dbug_dump for accesspath in debug mode – Tianfeng Li [8.3]
MySQL Cluster (NDB)
- #112775 – Rondb 475 contribute – Mikael Ronström [8.3]
- #114147 – [RONDB-620] Foreign key column ordering mismatch – Axel Svensson [8.4.1]
MySQL Server
- #112846 – Fix usage of BIO_get_mem_data – Samuel Chiang [8.3]
Documentation
- #112957 – Doc: Update compression protocol information – Daniël van Eeden [8.3]
MySQL Operator for K8s
- #113149 – Add Timezone Support To Backup Schedule – Eldin Didic [8.3]
Full Text Search
- #114156 – fts_sync_commit is not crash safe – Yin Pen (Tencent) [8.4]
Document Store / X Plugin / MySQL Shell
- #113500 – fix stale link about functions – Minha Jeong [8.4.1]
- #114127 – Fix handling of table/schema names containing non-ASCII characters in get_schema() – Daniel Lenski (Amazon) [8.4.1]
- #114707 – collect_diagnostics() fails with AttributeError when handling None diff values – Ioannis Androulidakis [8.4.1]
MySQL 9.0
Clients & Connectors
- #110512 – Replace synchronized with ReentrantLock – Bart De Neuter
- #113443 – SQL Keyword “RETURNING” not handled properly when updating data – Wang Shiyao
- #114985 – update dnspython required versions to allow latest 2.6.1 – Michael Perrone
InnoDB
- #110652 – InnoDB：trx hangs due to wrong trx->in_innodb value – Shaohua Wang
- #112424 – Crash during background rollback if both prepare and active transaction exist – Genze Wu
- #113640 – no need to judge rseg in while loop – Alex Xing
- #114154 – Parallel read is slow after partition table is read in parallel – Ke Yu
- #115041 – Unused heap in function Validate_files::check – Huaxiong Song
Document Store / X Plugin / MySQL Shell
- #113500 – fix stale link about functions – Minha Jeong
- #114127 – Fix handling of table/schema names containing non-ASCII chara … – Daniel Lenski
- #114707 – collect_diagnostics() fails with AttributeError when handling None diff values – Ioannis Androulidakis
MySQL Server
- #113933 – Contribution: Fix multibyte bugs in my_instr_mb – Dirkjan Bussink
Compiling
- #114064 – Unified behaviour when calling “plugin->deinit” for all plugins – Martin Alderete
MySQL Cluster (NDB)
- #114147 – [RONDB-620] Foreign key column ordering mismatch – Axel Svensson
Full Text Search
- #114156 – fts_sync_commit is not crash safe – Yin Pen (Tencent)
Don´t forget that MySQL is Open Source and that we, as Oracle, accept contributions. Please note that the time for processing contributions may differ depending on the category and complexity.
If you have patches and you also want to be part of the MySQL Contributors, it’s easy, you can send Pull Requests from MySQL’s GitHub repositories or send your patches on Bugs MySQL (signing the Oracle Contributor Agreement is required).
Thanks again to all our amazing contributors!
