[wp-trac] [WordPress Trac] #60058: SQL_CALC_FOUND_ROWS is deprecated in MySQL 8.0.17

WordPress Trac noreply at wordpress.org
Wed Dec 13 14:02:55 UTC 2023


#60058: SQL_CALC_FOUND_ROWS is deprecated in MySQL 8.0.17
----------------------------+------------------------------
 Reporter:  johnstonphilip  |       Owner:  (none)
     Type:  defect (bug)    |      Status:  new
 Priority:  normal          |   Milestone:  Awaiting Review
Component:  General         |     Version:  trunk
 Severity:  normal          |  Resolution:
 Keywords:                  |     Focuses:
----------------------------+------------------------------

Comment (by JavierCasares):

 Looks like in MySQL will be deprecated, but doesn't look like for MariaDB

 - https://dev.mysql.com/doc/refman/8.0/en/information-functions.html
 #function_found-rows
 - https://mariadb.com/kb/en/select/#sql_calc_found_rows

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


More information about the wp-trac mailing list