[MDEV-29919] Support MYSQL Syntax for INSERT ON DUPLICATE KEY UPDATE Created: 2022-10-31  Updated: 2022-10-31

Status: Open
Project: MariaDB Server
Component/s: Data Manipulation - Insert
Fix Version/s: None

Type: Task Priority: Major
Reporter: Marc Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

Starting with MySQL 8.0.20 it supports a new syntax for INSERT ON DUPLICATE KEY UPDATE to refer the new entry in the insert statement:
docu

They use the AS keyword to refer to the new entries instead of using VALUE[S]()
INSERT INTO t1 (a,b,c) VALUES (1,2,3),(4,5,6) AS new
ON DUPLICATE KEY UPDATE c = new.a+new.b;


Generated at Thu Feb 08 10:12:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.