Building and testing MySQL 8.0.45, 8.4.8, and 9.6.0 on macOS

Oracle has just released MySQL 8.0.45, 8.4.8, and 9.6.0 and here are the results of my usual testing of building them and running the testsuite on macOS, Apple Silicon hardware.

Build

All three versions compile with the current XCode (26.2) OK. With Homebrew-packaged LLVM, versions 14 to 17 inclusive are getting a strange CMake error that might have more to do with macOS than MySQL. LLVM 19 still fails to build 8.0.45 (bug #119238), but not 8.4.8, and so does LLVM 20 (bug #119239). Both these issues are pre-existing. But, 8.4.8 regressed in that it started being affected by bug #119246 too. LLVM 21 still fails to build 9.6.0 (preexisting bug #119246).

Test

Bad news:

1. Bug #119735 Unhandled error log warning in main.initialize-sha256
2. Bug #119738 global-buffer-overflow on INSTALL PLUGIN
3. Bug #119739 Test rpl_gtid.rpl_gtids_table_disable_binlog_on_slave result difference
4. Bug #119746 innodb.table_encrypt_4 failing with a result difference

No news aka old bad news:

1. Bug #113189 ColumnStatisticsTest.StoreAndRestoreAttributesEquiHeight unit test fails
2. Bug #113190 Several tests in routertest_integration_routing_sharing_constrained_pools fail
3. Bug #113260 Client error in error log: MY-004031 - The client was disconnected …
4. Bug #113665 perfschema.relaylog fails with a result difference
5. Bug #113709 StrXfrmTest.ChineseUTF8MB4 failing with an AddressSanitizer error
6. Bug #113722 Test main.index_merge_innodb failing with a result difference
7. Bug #114892 Test XComControlTest.SuspectMemberFailedRemovalDueToMajorityLoss fails
8. Bug #115480 Test innodb.log_first_rec_group failing
9. Bug #116369 rpl.rpl_semi_sync_alias crashes under AddressSanitizer
10. Bug #116373 auth_sec.acl_tables_row_locking failing with result diff
11. Bug #116378 routertest_integration_routing_splitting crashing under AddressSanitizer
12. Bug #116385 Test main.mysql_upgrade_grant timing out on debug build
13. Bug #116394 Test binlog_gtid.binlog_gtid_binlog_recovery_errors crashes with an assert
14. Bug #118171 Test main.mysqldump-tablespace-escape failing
15. Bug #118185 Non-specific ASan error on TestLoaderGood/LoaderReadTest.load_wrong_version/0
16. Bug #118213 Test perfschema.idx_compare_mutex_instances fails under debug + sanitizers
17. Bug #119247 Test main.log_buffered-big failure
18. Bug #119249 Router unit test setup failures
19. Bug #119251 Test rpl.rpl_seconds_behind_master failure
20. Bug #119252 Test router.response_cache failure
21. Bug #119253 innodb.tablespace_encrypt_9 crashing the server with assertion failure
22. Bug #119258 router integration tests failing to login

Good news:

1. none! Every single bug I am tracking is present

Conclusion

With 4 new, 22 unchanged bugs, and not a single fix, the testsuite quality is continuing to slowly decay. I hope this will change for the better.

Addendum

A note for my future self. Issues I couldn't reliably reproduce:

• main.mysqltest failing testcase check on 8.0.45, 8.0.45 debug build
• innodb_zip.16k, main.mysqlpump_bugs failing with a result difference, 8.0.45 debug+sanitizers build
• main.subquery_sj_firstmatch failing with a result difference, 8.0.45 release build
• main.lowercase_table4 timeout, 8.0.45 debug+sanitizers build
• x.mysqlxtest_mode_ssl test command failure, 8.4.8 release build
• connection_control.performance_schema_processlist test result difference, 8.4.8 release build
• merge_innodb_tests-t failed once, 8.4.8 debug+sanitizers build
• routertest_harness_net_ts_timer failed once, 8.4.8 debug build
• rpl_nogtid.rpl_semi_sync_optimize_for_static_plugin_config failing with global-buffer-overflow under 9.6.0 debug+sanitizers build, serious, but I couldn't reproduce.
• routertest_integration_routing_direct, routertest_integration_routing_router_require, routertest_integration_routing_sharing, and routertest_integration_routing_sharing_constrained_pools failed once under 9.6.0 debug+sanitizers build and once under 9.6.0 debug build
• perfschema.system_events_plugin, test_service_sql_api.test_sql_stmt, main.group_by, main.index_merge_innodb, perfschema.idx_compare_metadata_locks failed once, 9.6.0 debug build
• router.authentication_mysql_accounts, router.app_specific_metadata_v_latest, and main.ps failed once, 9.6.0 release build