SQL_CALC_FOUND_ROWS and SQL_CALC_FOUND_ROWS are deprecated

[jdorner]

According to ​https://dev.mysql.com/doc/refman/8.0/en/information-functions.html#function_found-rows

The SQL_CALC_FOUND_ROWS query modifier and accompanying FOUND_ROWS() function are deprecated as of MySQL 8.0.17; expect them to be removed in a future version of MySQL.

These functions do not appear to be deprecated in MariaDB.

These are used in the following methods:
WP_Query->get_posts()
WP_Comment_Query->get_comment_ids()
WP_Network_Query->get_network_ids()
WP_Site_Query->get_site_ids()
WP_User_Query->prepare_query()

[craigfrancis]

Hi John, thanks for reporting... can you check if this issue is covered by #47280?

[desrosj]

Duplicate of #47280.

This does look like a duplicate report to me. @jdorner feel free to reopen if that's not the case.