[CAY-317] Improve SQL Logging Output when Optimistic Locking is Used

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.1 [LEGACY]
• Fix Version/s: 1.1 [LEGACY]
• Component/s: Core Library
• Environment: All
• Assignee: Michael Gentry
• Reporter: Michael Gentry
• Created: 19/May/05 22:45
• Updated: 29/Sep/05 00:00
• Resolved: 16/Jun/05 03:07

Description

When Cayenne outputs SQL for logging and optimistic locking is being used, Cayenne smartly doesn't create bindings for null values (generates "IS NULL" for the SQL), but the "bind:" output immediately following shows "NULL" in the output instead of omitting it.

Example:

INFO QueryLogger:315 - UPDATE Foo SET bar = ? WHERE bar = ? and baz IS NULL
INFO QUeryLogger:337 - [bind: 2, 1, NULL]

Since Cayenne generated "IS NULL for the SQL, it is not needed (and in fact Cayenne does not include it) as a bind parameter, but the logging doesn't reflect this, which is confusing.