[wp-trac] [WordPress Trac] #55781: SQL_CALC_FOUND_ROWS and SQL_CALC_FOUND_ROWS are deprecated

[WordPress Trac]

#55781: SQL_CALC_FOUND_ROWS and SQL_CALC_FOUND_ROWS are deprecated
-------------------------------+-----------------------------
 Reporter:  jdorner            |      Owner:  (none)
     Type:  defect (bug)       |     Status:  new
 Priority:  normal             |  Milestone:  Awaiting Review
Component:  Posts, Post Types  |    Version:  5.9.3
 Severity:  normal             |   Keywords:  needs-patch
  Focuses:                     |
-------------------------------+-----------------------------
 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()

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/55781>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform