You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@cayenne.apache.org by "Paul Pellegrini (JIRA)" <ji...@apache.org> on 2011/05/14 19:37:47 UTC

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

Cannot Retrieve Objects Using Query Expression Including "\" On Postgres
------------------------------------------------------------------------

                 Key: CAY-1566
                 URL: https://issues.apache.org/jira/browse/CAY-1566
             Project: Cayenne
          Issue Type: Bug
          Components: Core Library
    Affects Versions: 3.0.1
         Environment: Windows 7 64 bit, Postgresql 9.0
            Reporter: Paul Pellegrini


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?

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira