[hibernate-issues] [Hibernate-JIRA] Reopened: (EJB-404) QueryTest - PostgreSQL - "ERROR: operator does not exist: character varying = bytea"

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, DB2 and Entity Manager Reporter: Juraci Paixao Krohling Assignee: Juraci Paixao Krohling Fix For: 3.4.0.GA, 3.4.1 Attachments: QueryTest_2.diff, QueryTest_3.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.