[hibernate-issues] [Hibernate-JIRA] Created: (EJB-404) QueryTest - PostgreSQL - "ERROR: operator does not exist: character varying = bytea"
Juraci Paixao Krohling (JIRA)
noreply at atlassian.com
Fri Nov 28 08:55:15 EST 2008
QueryTest - PostgreSQL - "ERROR: operator does not exist: character varying = bytea"
------------------------------------------------------------------------------------
Key: EJB-404
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-404
Project: Hibernate Entity Manager
Issue Type: Patch
Components: EntityManager
Environment: PostgreSQL and Entity Manager
Reporter: Juraci Paixao Krohling
Assignee: Juraci Paixao Krohling
Attachments: QueryTest_2.diff
Test org.hibernate.ejb.test.QueryTest#testIsNull fails due to this query:
select i from Item i where (i.descr is null and :descr is null) or i.descr = :descr
When changing the query to what it reads below, it works properly:
select i from Item i where i.descr = :descr or (i.descr is null and :descr is null)
As this happened only with PostgreSQL, I assume this is an issue with either the driver or with the database itself. Will dig into pgsql's site to find out more about this issue.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the hibernate-issues
mailing list