[jboss-jira] [JBoss JIRA] Commented: (JBAS-3800) EJBQLToSQL92Compiler should use only searchable columns with DISTINCT
[ http://jira.jboss.com/jira/browse/JBAS-3800?page=comments#action_12354894 ]
anajavi commented on JBAS-3800:
-------------------------------
This can be reproduced with Sybase using TEXT columns.
I once tested this with couple of RDBMS's, and most of them didn't support
DISTINCT with Clob or Blob. However postgresql seems to accept DISTINCT queries in Clob
fields.
EJBQLToSQL92Compiler should use only searchable columns with
DISTINCT
---------------------------------------------------------------------
Key: JBAS-3800
URL: http://jira.jboss.com/jira/browse/JBAS-3800
Project: JBoss Application Server
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: CMP service
Affects Versions: JBossAS-4.0.5.GA, JBossAS-3.2.8.SP1
Reporter: Alexey Loubyansky
Assigned To: Alexey Loubyansky
Currently it selects all columns which causes errors since, e.g. BLOBs are not comparable
or searchable and, hence, can't be used with distinct.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira