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
Reporter: Kurt T Stam
Assignee: Kurt T Stam
Fix For: 3.0.1
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.
