cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paul Pellegrini (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CAY-1566) Cannot Retrieve Objects Using Query Expression Including "\" On Postgres
Date Sat, 14 May 2011 17:37:47 GMT
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

Mime
View raw message