MySQL 9.2 ! Thank you for your contributions!

At the beginning of the year, we released MySQL 9.2, the latest Innovation Release. Sorry for the delay, but I was busy with the preFOSDEM MySQL Belgian Days and FOSDEM MySQL Belgium Days. Of course, we released bug fixes for 8.0 and 8.4 LTS, but in this post, I focus on the newest release.

Within these releases, we included patches and code received by our amazing Community.

Here is the list of contributions we processed and included in MySQL 9.2:

MySQL Server

• #98521 – Core client cannot send any query with commentary characters in hints – Kaiwang Chen (Tencent)
• #116339 – Fix Incorrect Payload Length for COM_QUERY Example Packet – Konno Satoshi

InnoDB

• #115115 – Private bug on special dropping primary key case – Shaohua Wang (Alibaba)
• #115511 – Inplace ALTER TABLE might fail with duplicate key error – Dmitry Lenev (Percona)
• #115608 – Inplace ALTER TABLE might cause lost rows if concurrent purge – Dmitry Lenev (Percona)

Performance Schema

• #116625 – Under certain circumstances, a metadata lock can be upgraded or downgraded to a different LOCK_TYPE – George Ma (Alibaba)

Fulltext Search

• #113707 – Fixed an issue relating to FTS comparisons – Shaohua Wang (Alibaba)
• #116212 – fts_delete is not crash-safe if binlog is disabled – Yin Peng (Tencent)

Replication & Group Replication

• #105290 – Private bug that could cause a crash related on secondary indexes – Rahul Malik (Percona)
• #110673 – Optimize the garbage_collect of group_replication – Fangxin Flou

Command-line Clients

• #116844 – fix mysqlslap --ssl-mode=disable not working issue – Chen Chen

Connector/NET

• #110553 – Run inserts in batch command as one block – Sebastian Schwarzhuber
• #114457 – Fixed NullReferenceException – Maximilian Bienhüls
• #115020 – MySQLUpdateSqlGenerator to inherit UpdateAndSelectSqlGenerator – Hikari Fujioka
• #115853 – ConcurrencyFix – Added back in RowCount checking (Added ROW_COUNT() concurrency checking in EFCore for update operations) – Ryan Kelly

MySQL Cluster (NDB)

• #116748 – db_config did not always handle very long file paths correctly – Dirkjan Bussink

MySQL is Open Source and 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!