ORA-00932 when executing a HQL with "distinct" on an entity with a Blob ----------------------------------------------------------------------- Key: HHH-3835 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3835 Project: Hibernate Core Issue Type: Bug Components: query-hql Affects Versions: 3.2.6 Environment: Oracle 10 Reporter: Martin Zeltner Hi I get an Oracle exception "ORA-00932: inconsistent datatypes: expected - got BLOB" when I execute a HQL on an entity that has a blob and the HQL contains the "distinct". When I remove the "distinct" then it works. HQL: "select distinct ci from CircuitInstruction ci ..." Entity "CircuitInstruction" has the following property: /** * @return Returns the CI PDF. */ @Lob @Basic(fetch = FetchType.LAZY) public Blob getCiPdf() { return m_ciPdf; } Cheers Martin -- 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira