Re: Suggested replacement for use of deprecated VALUES() to access new row values in INSERT ... SELECT ... ON DUPLICATE KEY UPDATE statements

[Jens Hatlak]

https://dbfiddle.uk/?rdbms=mysql_8.0&fiddle=67069b7ec9cb69ebee644b9c87132968

Since there is no VALUES or SET part after INSERT INTO someTable, there is no way to apply an alias as documented.

Please, when you reply,
1. explain how to adapt INSERT INTO SELECT cases like this
2. update the documentation and/or release notes to cover that case
3. include examples.

Thanks.