[wp-trac] [WordPress Trac] #60058: SQL_CALC_FOUND_ROWS is deprecated in MySQL 8.0.17

[WordPress Trac]

#60058: SQL_CALC_FOUND_ROWS is deprecated in MySQL 8.0.17
----------------------------+-----------------------------
 Reporter:  johnstonphilip  |      Owner:  (none)
     Type:  defect (bug)    |     Status:  new
 Priority:  normal          |  Milestone:  Awaiting Review
Component:  General         |    Version:  trunk
 Severity:  normal          |   Keywords:
  Focuses:                  |
----------------------------+-----------------------------
 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.

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