[jira] Closed: (JUDDI-341) Distinct query is causing an issue on Db2 and SqlServer

["Kurt T Stam (JIRA)" <ju...@ws.apache.org>]

     [ https://issues.apache.org/jira/browse/JUDDI-341?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kurt T Stam closed JUDDI-341.
-----------------------------

    Resolution: Fixed

> Distinct query is causing an issue on Db2 and SqlServer
> -------------------------------------------------------
>
>                 Key: JUDDI-341
>                 URL: https://issues.apache.org/jira/browse/JUDDI-341
>             Project: jUDDI
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.0, 3.0.1
>            Reporter: Kurt T Stam
>            Assignee: Kurt T Stam
>             Fix For: 3.0.2
>
>
> Both dbs have issues with: the query:
> select distinct ss from Subscription ss where (ss.authorizedName = ?)
> "The text data type cannot be selected as DISTINCT because it is not comparable." I think it does a distinct over all the fields rather then just the PK, and one of the fields on subscription is "text", which is causing an issue.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.