| Key: |
OPENJPA-80
|
| Type: |
Bug
|
| Status: |
Resolved
|
| Resolution: |
Fixed
|
| Priority: |
Major
|
| Assignee: |
Unassigned
|
| Reporter: |
Jakob Braeuchi
|
| Votes: |
0
|
| Watchers: |
0
|
|
If you were logged in you would be able to see more operations.
|
|
|
|
Environment:
|
openJPA 0.9.7
MySQL 5.0.15
openJPA 0.9.7
MySQL 5.0.15
|
|
| Resolution Date: |
06/Mar/07 09:34 AM
|
|
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 '\\'.
|
|
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 '\\'. |
Show » |
|
Bad Escaping for LIKE in MySQL
