[NIFI-11682] Upsert and Insert Ignore keys not quoted in PutDatabaseRecord

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0.0-M1, 1.23.0
• Component/s: Extensions
• Assignee: Matt Burgess
• Reporter: Matt Burgess
• Created: 13/Jun/23 21:59
• Updated: 16/Jun/23 20:06
• Resolved: 16/Jun/23 20:06

Description

When update keys are used in PutDatabaseRecord (either by declaring them in the Update Keys property or being auto-determined from the database metadata), they are not being quoted correctly when 'Quote Column Identifiers' is set to 'true'. This happens for Upsert, Update, and Insert Ignore statements.

This was fixed for Upsert in NIFI-8043 but a regression was introduced via NIFI-9607 when the quoting was removed inadvertently. Testing has revealed this issue exists for Upsert, Update, and Insert Ignore statements, so should be fixed for all of them.

Issue Links

• links to: GitHub Pull Request #7385