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

Comment (by akramipro):

 `COUNT(*)` query is not working when using `GROUP BY` in sql query .
 and if you remove `GROUP BY`the result is not the same as `SELECT
 FOUND_ROWS()`

 see this exam. main query result has 415 rows but with count query if we
 remove `GROUP BY` we get 423 rows

 [[Image(https://i.ibb.co/M5rsqzY/179920451-1c238783-b255-4b07-ac39-e50296100f36.png)]]
 [[Image(https://i.ibb.co/Y8KRVNQ/179920575-81b41c72-c033-456c-a442-9e9fe82e4765.png)]]

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