[CAY-1896] Flattened attributes don't work with optimistic locking on

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.2.M1
• Component/s: Core Library
• Assignee: Unassigned
• Reporter: John Huss
• Created: 31/Jan/14 18:01
• Updated: 25/Jun/15 07:11

Description

Flattened attributes can not be modified and saved with if you have optimistic locking turned on for a to-one relationship in the same entity with the flattened attribute.

For example, say you have Artist and Painting and a flattened attribute "artistName" on Painting and you set this to a new value. And you also have optimistic locking on the Painting.artist relationship. It tries to generate SQL for the flattened object (Artist) that includes the to-one relationship foreign key from the source object (Painting) and fails because the column is not found:

UPDATE ARTIST SET NAME = ? WHERE ID IS NULL AND ARTIST_ID = ?
Column 'ARTIST_ID' is either not in any table in the FROM list...

A minimal example is attached.