[wp-trac] [WordPress Trac] #47280: SQL_CALC_FOUND_ROWS is deprecated as of MySQL 8.0.17

[WordPress Trac]

#47280: SQL_CALC_FOUND_ROWS is deprecated as of MySQL 8.0.17
-------------------------+-----------------------------
 Reporter:  javorszky    |       Owner:  (none)
     Type:  enhancement  |      Status:  new
 Priority:  normal       |   Milestone:  Future Release
Component:  Database     |     Version:
 Severity:  normal       |  Resolution:
 Keywords:  needs-patch  |     Focuses:
-------------------------+-----------------------------

Comment (by javorszky):

 No. For various reasons I have stepped back from contributing to WordPress
 in any way except for this ticket via comments.

 Regarding the performance advantage, as long as the `select count(column)
 from table where ...` happens on indices, and uses only one column, it
 should be okay.

 Also per mysql docs, there's not much in terms of alternatives.

 Alternative is to not have the number of total rows available any more,
 which I suspect would break bc.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/47280#comment:3>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform