[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:  5.7
Component:  Database     |     Version:
 Severity:  normal       |  Resolution:
 Keywords:  has-patch    |     Focuses:
-------------------------+---------------------

Comment (by wpe_bdurette):

 Thanks @morgantocker! That's super helpful.

 Whether or not I use a subselect or just replace the select_expr from the
 original query, I'm going to have to do some surgery on a query string in
 PHP. This is less than ideal without a full parser. It strikes me as safer
 to strip the LIMIT clause and move to a subselect, so that's what I'll do.

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