[hibernate-issues] [Hibernate-JIRA] Created: (EJB-365) Can't execute query

[Radosław Smogura (JIRA)]

Can't execute query
-------------------

                 Key: EJB-365
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-365
             Project: Hibernate Entity Manager
          Issue Type: Bug
    Affects Versions: 3.3.2.GA
         Environment: Hibernate 3.2.6
PostrgreSQL 8.0.13
Glassfish
            Reporter: Radosław Smogura
            Priority: Critical


Execution followed named query with followed entity
@Entity
@NamedQuery(name="Foo.test",
query="SELECT f FROM Foo f WHERE ((:bool IS NULL) OR (f.bool = :bool)) ")
public class Foo implements Serializable{
    @Id
    int id;
    
    
    boolean bool;

    public boolean isBool() {
        return bool;
    }

    public void setBool(boolean bool) {
        this.bool = bool;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }   
}

and parameter bool = null
causes PostgreSQL error ERROR: operator does not exist: boolean = bytea

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