[CAY-1279] Passing null values in query parameters

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2.5, 3.0 beta 1, 3.0, 2.0.5
• Fix Version/s: 1.2.5, 3.0 beta 1, 2.0.5
• Component/s: Core Library
• Assignee: Andrus Adamchik
• Reporter: Evgeny Ryabitskiy
• Created: 23/Sep/09 18:51
• Updated: 27/Sep/09 13:18
• Resolved: 27/Sep/09 13:18

Description

Example1:

INSERT INTO TABLE1 (id, NullableColumn) values (10, $MyNullValue)

If I put null in MyNullValue parameter I will get: bad formed query because of how Velocity do merge with templates.
But Cayenne is using #bind directive, so....

Example2:

INSERT INTO TABLE1 (id, NullableColumn) values (10, #bind($MyNullValue))

If I put null in MyNullValue parameter I will get Bind Exception.

So.... how can I insert null in my column using Cayenne?!