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

WordPress Trac noreply at wordpress.org
Wed Jul 20 17:21:17 UTC 2022


#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:  normal                          |  Resolution:
 Keywords:  has-patch has-unit-tests early  |     Focuses:  performance
--------------------------------------------+-----------------------------

Comment (by akramipro):

 @rjasdfiii - also i should mention that wordpress add `GROUP BY` to
 `$groupby` after `posts_clauses` filter so this is safe to use `$groupby`
 in my count query `$count = "COUNT( distinct $groupby )"` since it's just
 contain group column name.

 [[Image(https://i.ibb.co/ZY0h9Wz/download.jpg)]]

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


More information about the wp-trac mailing list