[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:  johnbillion
     Type:  enhancement               |      Status:  reviewing
 Priority:  normal                    |   Milestone:  Future Release
Component:  Database                  |     Version:
 Severity:  major                     |  Resolution:
 Keywords:  has-patch has-unit-tests  |     Focuses:  performance
--------------------------------------+-----------------------------

Comment (by johnbillion):

 Replying to [comment:20 xParham]:
 > Hey @johnbillion, can we also maybe add `count` as an option for the
 `fields` query parameter

 Interesting idea! I'll open a follow-up ticket for that so we keep this
 one focused.

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