[CAY-1566] Cannot Retrieve Objects Using Query Expression Including "\" On Postgres

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.1
• Component/s: Core Library
• Labels: expressions query
• Environment: Windows 7 64 bit, Postgresql 9.0
• Assignee: Unassigned
• Reporter: Paul Pellegrini
• Created: 14/May/11 17:36
• Updated: 14/May/11 17:36

Description

I have an entity with a String attribute called name. I created an object whose name was <>.<> ,;'"|\/?

This object landed in my database just fine, however when I tried querying for this object specifically (by using a SelectQuery with an Expression qualifier via expWithParameters) the list comes up with 0 results.

I can retrieve the object using queries that do not explicitly filter on the name, such as an unconstrained SelectQuery. Via process of elimination I have determined that the offending character is the \ (i.e. I changed the object's name to <>.<> ,;'"|/? using the pgAdmin interface and then could query for that object in Cayenne just fine).

I have been unable to find any documentation here or forum posts elsewhere on the internet that discusses this behaviour- is \ supposed to be an acceptable character?