SQL_CALC_FOUND_ROWS is deprecated in MySQL 8.0.17

[johnstonphilip]

I stumbled on this notice that is being deprecated in MySQL 8.0.17. See:
​https://dev.mysql.com/doc/refman/8.0/en/information-functions.html#function_found-rows

I also see WordPress uses it in a few places:
​https://github.com/search?q=repo%3AWordPress%2Fwordpress-develop%20SQL_CALC_FOUND_ROWS&type=code

I haven't had time to dig in further but I wanted to flag it just in case it hasn't been yet.

[JavierCasares]

Looks like in MySQL will be deprecated, but doesn't look like for MariaDB

• ​https://dev.mysql.com/doc/refman/8.0/en/information-functions.html#function_found-rows
• ​https://mariadb.com/kb/en/select/#sql_calc_found_rows

[johnbillion]

Thanks for the report, this is a duplicate of #47280 which has stalled for a while as it's not clear how this change can be made in a fully backwards compatible manner.