VALUES deprecation on INSERT since 8.0.19

[Stephan Woods]

Hello everyone,

since MySQL 8.0.19 in a procedure there is a warning in INSERT INTO ON DUPLICATE UPDATE

(We are using version 8.0.20)

Here an example:

INSERT INTO articles
(SELECT
a.id,
a.app,
a.title
FROM articles_pre a
INNER JOIN cards_pre c ON a.id = c.artIdRef
WHERE
c.collectionIdRef = collId # var given to procedure
AND c.contentType = 'article'
)
ON DUPLICATE KEY UPDATE
title = VALUES ( title );

articles_pre and articles have the same structure and the same spelling.
The order of the subquery does not matter, the id will be the same in both tables.

Is there a way to keep INSERT SELECT ON DUPLICATE UPDATE without VALUE and use the row alias "new"?

I have tested serveral stmts, but nothing works without VALUES for me. My only option left is to split things up into SELECT and INSERT or UPDATE.
Has someone an idea, how to still work with INSERT SELECT ON DUPLICATE for this constellation?

Thank you