[wp-trac] [WordPress Trac] #60503: MySQL VALUES function deprecated in MySQL 8

[WordPress Trac]

#60503: MySQL VALUES function deprecated in MySQL 8
--------------------------+------------------------------
 Reporter:  kkmuffme      |       Owner:  (none)
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Database      |     Version:
 Severity:  minor         |  Resolution:
 Keywords:  close         |     Focuses:
--------------------------+------------------------------
Changes (by OllieJones):

 * keywords:  needs-patch => close
 * severity:  normal => minor


Comment:

 I assume the SQL log you mention, the one getting spammed with warnings
 about deprecated SQL syntax, is the stuff from the system table
 {{{
 performance_schema.events_statements_summary_by_digest
 }}}
 shown in the view
 {{{
 sys.statements_with_errors_or_warnings
 }}}

 If that's not correct, please write a comment showing which log you have
 in mind.

 I am pretty sure that maintaining that log is very low overhead for the
 server.

 If Oracle, as the owners of MySQL, decide to actually remove the languuage
 features they've deprecated, that will cause a lot of scrambling in the
 WordPress world. Most of that scrambling will be to switch over to
 MariaDB. Hopefully people are tracking this.

 The deprecations I see are this INSERT ... ON DUPLICATE KEY UPDATE ...
 VALUES() thing, and SQL_CALC_FOUND_ROWS ... LIMIT.

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