[hibernate-issues] [Hibernate-JIRA] Created: (HHH-3606) Can't use distinct in Oracle with BLOB/CLOB column

[Julien HENRY (JIRA)]

Can't use distinct in Oracle with BLOB/CLOB column
--------------------------------------------------

                 Key: HHH-3606
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3606
             Project: Hibernate Core
          Issue Type: Bug
          Components: core
    Affects Versions: 3.2.6
         Environment: Oracle 9i
            Reporter: Julien HENRY


Problem: Oracle doesn't support distinct when a row is BLOB/CLOB. The resulting error is: ORA-00932: inconsistent datatypes: expected - got CLOB

I got this error when trying to filter root entity (see FAQ: http://www.hibernate.org/117.html#A12).


It is not really an Hibernate bug, much likely an Oracle limitation. But perhaps an entry may be added in the FAQ, or perhaps some workaround may be found 
to not use SQL distinct keyword when a BLOB/CLOB is involved in the query.

Some related links:
http://drupal.org/node/48435
(FR) http://www.developpez.net/forums/d553106/java/general-java/persistance/hibernate/clob-oracle-9-inconsistent-datatypes-ora-00932-a/#post3288401
http://www.dbasupport.com/forums/showthread.php?t=46785 (possible rewriting of the query)

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