[OPENJPA-80] Bad Escaping for LIKE in MySQL

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.9.7
• Component/s: query
• Environment: openJPA 0.9.7 ; MySQL 5.0.15
• Assignee: Unassigned
• Reporter: Jakob Braeuchi
• Created: 13/Nov/06 20:01
• Updated: 09/Mar/10 18:32
• Resolved: 06/Mar/07 09:34

Description

the following query :

em.createQuery("select k from KategorieGruppe k where k.bezeichnung like ?1 order by k.bezeichnung asc");

generates an sql-statement with a bad escaping character '\' for MySQL :

SELECT t0.id, t0.bezeichnung FROM ekv2kategoriegruppe t0 WHERE (t0.bezeichnung LIKE ? ESCAPE '\') ORDER BY t0.bezeichnung ASC

the correct escaping would be '
'.