mysql8 @8.4.2: fails to compile with Xcode Clang on Sonoma

[raxod502-plaid (Radon Rosborough)]

I recently uninstalled libunwind due to #69235 and this triggered rev-upgrade for a number of ports. They all rebuilt successfully except for mysql8 which fails with the following:

:info:build /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_databases_mysql8/mysql8/work/mysql-8.4.2/storage/ndb/plugin/ndb_binlog_purger.cc:79:20: error: no member named 'any_of' in namespace 'std::ranges'
:info:build    79 |   if (std::ranges::any_of(m_purge_files, [filename](const auto &request) {
:info:build       |       ~~~~~~~~~~~~~^
:info:build /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_databases_mysql8/mysql8/work/mysql-8.4.2/storage/ndb/plugin/ndb_binlog_purger.cc:98:25: error: no member named 'none_of' in namespace 'std::ranges'
:info:build    98 |            std::ranges::none_of(m_purge_files, [session](const auto &request) {
:info:build       |            ~~~~~~~~~~~~~^
:info:build 2 errors generated.

Here is the compiler that is being selected:

:debug:configure Preferred compilers: clang macports-clang-19 macports-clang-18 macports-clang-17 macports-clang-16
:debug:configure Using compiler 'Xcode Clang'

I will attach the full build output to this ticket.