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

[Juraci Paixao Krohling (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/EJB-404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Juraci Paixao Krohling updated EJB-404:
---------------------------------------

    Attachment: QueryTest_3.diff

This patch fixes the test for DB2 as well. Do not use the QueryTest_2.diff. 

> 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
>             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.

-- 
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