[jboss-jira] [JBoss JIRA] Commented: (JBAS-3800) EJBQLToSQL92Compiler should use only searchable columns with DISTINCT
anajavi (JIRA)
jira-events at lists.jboss.org
Sat Mar 3 07:29:09 EST 2007
[ 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
More information about the jboss-jira
mailing list