[MDEV-27766] CONNECT Engine Support for INSERT IGNORE with Mysql Table type Created: 2022-02-07  Updated: 2022-06-10  Resolved: 2022-06-10

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Connect
Fix Version/s: 10.3.36, 10.4.26, 10.5.17, 10.6.9, 10.7.5, 10.8.4, 10.9.2

Type: Task Priority: Major
Reporter: Mathew Assignee: Daniel Black
Resolution: Fixed Votes: 0
Labels: None


 Description   
  • CONNECT rebuilds INSERT statements without other options such as INSERT IGNORE or ON DUPLICATE KEY UPDATE.
  • CONNECT maps these INTO INSERT statements or INSERT DELAYED (if the undocumented "delayed=1" option is used)
  • CONNECT could support other options (or even support recognizing these from the source query)
  • Since IGNORE is a simple but useuful feature, and CONNECT supports INSERT DELAYED already (very similar in implementation i.e opt list) I've built support in the same way

PR to follow

 Comments   
Comment by Daniel Black [ 2022-06-10 ]

Fixed the bug that this was ignoring the ignore option.

Thanks splitice for the a patch

Generated at Thu Feb 08 09:55:25 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.