Building and testing MySQL 9.7.0 early access build on macOS

Oracle released 9.7.0 community early access build, which is a part of their work towards fulfilling their new promises to the community. This is great news for community testing and I did my part in my usual way (previously: 8.0.45 / 8.4.8 / 9.6.0).

Build

No changes from 9.6.0: the current Xcode (26.3) builds the 9.7.0 early access build fine, LLVM 21 still fails (bug #119246).

Tests

Bad news

• Bug #120088 Hypergraph MTR tests failing, although I'm happy to see hypergraph in the community builds.

No news

• Bug #113665 perfschema.relaylog fails with a result difference
• Bug #116394 Test binlog_gtid.binlog_gtid_binlog_recovery_errors crashes with an assert
• Bug #118213 Test perfschema.idx_compare_mutex_instances fails under debug + sanitizers
• Bug #119249 Router unit test setup failures
• Bug #119250 routertest_integration_routing_sharing_constrained_pools missing connection_pool.so
• Bug #119251 Test rpl.rpl_seconds_behind_master failure
• Bug #119253 innodb.tablespace_encrypt_9 crashing the server with assertion failure
• Bug #119258 router integration tests failing to login
• Bug #119739 Test rpl_gtid.rpl_gtids_table_disable_binlog_on_slave result difference
• Bug #119746 innodb.table_encrypt_4 failing with a result difference

Good news

• Bug #119252 Test router.response_cache failure no longer reproduces with 9.7.0

One-off issues

• component_keyring_file.tablespace_encrypt_10 failed once under debug build
• Likewise main.func_in_mrr
• Likewise perfschema.idx_compare_metadata_locks
• main.mysqltest failed testcase check one under debug build
• rpl_gtid.rpl_semisync_gtid_tag crashed once under debug + sanitizers build
• perfschema.system_events_component failed once under debug + sanitizers build
• Likewise perfschema.stage_mdl_global
• Likewise innodb_undo.truncate