[hibernate-issues] [Hibernate-JIRA] Created: (HHH-3835) ORA-00932 when executing a HQL with "distinct" on an entity with a Blob

[Martin Zeltner (JIRA)]

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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira