MySQL 9.0 is out! Thank you for your contributions!

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!

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

You can find articles I wrote on Oracle’s blog.