[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:  normal        |  Resolution:
 Keywords:  needs-patch   |     Focuses:
--------------------------+------------------------------

Comment (by OllieJones):

 Did some testing.

 This newer

     ...VALUES('what','ever') AS new
     ON DUPLICATE KEY UPDATE key=new.key, val=new.val

 syntax ''does not work on MariaDB 10.11.10'' (a recent version). Nor on
 MySQL 5.5.62 or 5.7.42 according to my testing. The old

     ON DUPLICATE KEY UPDATE key=VALUES(key), val=VALUES(val)

 syntax works in all cases I've tried (not a surprise).

 The new syntax does work on MySQL 8.0.27.  So, at best we can't get rid of
 the old syntax.

 If the MySQL people follow through on their promise to remove the old
 syntax from a future version, we'll be faced with a breaking
 incompatibility between MariaDB and MySQL.

 I put a ticket in MariaDB's JIRA.
 https://jira.mariadb.org/browse/MDEV-35586  .

 We can't change anything in WordPress because we can't break recent
 MariaDB versions.

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