SQL queries for LIKE expressions with escape character generated with syntax
errors
-----------------------------------------------------------------------------------
Key: CAY-1577
URL: https://issues.apache.org/jira/browse/CAY-1577
Project: Cayenne
Issue Type: Bug
Reporter: Dzmitry Kazimirchyk
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'."
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
