[MDEV-11359] Implement IGNORE for bulk operation Created: 2016-11-26  Updated: 2016-11-29  Resolved: 2016-11-29

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Fix Version/s: 10.2.3

Type: Task Priority: Major
Reporter: Oleksandr Byelkin Assignee: Oleksandr Byelkin
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
is blocked by MDEV-11360 Dynamic SQL: DEFAULT as a bind parameter Closed
Relates
relates to MDEV-9114 Bulk operations (Array binding) Closed

 Description   

Implement IGNORE indicator for bulk operation parameters as was with DEFAULT.

For implementing SQL_COLUMN_IGNORE in odbc https://msdn.microsoft.com/en-us/library/ms711010(v=vs.85).aspx

For INSERT & REPLACE it will insert default value.

To make possible printing statements with ignored parameters with having legal index we also implement IGNORE "function" with no parameters (same as DEFAULT syntax) for UPDATE/INSERT/REPLACE.

 Comments   
Comment by Alexander Barkov [ 2016-11-27 ]

As agreed, Sanja will add IGNORE as a possible dynamic SQL bind value, and add test based on it.

Comment by Alexander Barkov [ 2016-11-29 ]

This patch is OK to push:

Subject: [Commits] cefa676: MDEV-11359 Implement IGNORE for bulk operation
Date: Mon, 28 Nov 2016 18:53:13 +0100

I'd suggest to extend tests though, using the tests from MDEV-11360 and changing DEFAULT to IGNORE.

Thanks.

Generated at Thu Feb 08 07:49:20 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.