[CAY-1577] SQL queries for LIKE expressions with escape character generated with syntax errors

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.1M3, 3.0.3
• Assignee: Dzmitry Kazimirchyk
• Reporter: Dzmitry Kazimirchyk
• Created: 03/Jun/11 10:42
• Updated: 05/Jul/11 09:58
• Resolved: 05/Jul/11 09:58

Description

Originally reported at users mailing list: http://markmail.org/message/5t6s6deuecn7ni3c
For LIKE expressions with a usage of escape characters Cayenne generates SQL queries such as

SELECT * FROM TEST_TABLE t0 WHERE UPPER(t0.NAME) LIKE UPPER(?

{escape '*'}

) [bind: 1->NAME:'A*_1']

which causes SQLException with message "Incorrect syntax near the keyword 'escape'."