Bug 1008824
Summary: | Avoid task duplicates when querying for tasks | ||||||
---|---|---|---|---|---|---|---|
Product: | [JBoss] JBoss Enterprise BRMS Platform 5 | Reporter: | Toshiya Kobayashi <tkobayas> | ||||
Component: | jBPM 5 | Assignee: | Kris Verlaenen <kverlaen> | ||||
Status: | VERIFIED --- | QA Contact: | |||||
Severity: | high | Docs Contact: | |||||
Priority: | unspecified | ||||||
Version: | BRMS 5.3.1 | CC: | abhumbe, ajuricic, nwallace | ||||
Target Milestone: | GA | ||||||
Target Release: | --- | ||||||
Hardware: | Unspecified | ||||||
OS: | Unspecified | ||||||
Whiteboard: | |||||||
Fixed In Version: | Doc Type: | Bug Fix | |||||
Doc Text: | Story Points: | --- | |||||
Clone Of: | |||||||
: | 1053793 (view as bug list) | Environment: | |||||
Last Closed: | Type: | Bug | |||||
Regression: | --- | Mount Type: | --- | ||||
Documentation: | --- | CRM: | |||||
Verified Versions: | Category: | --- | |||||
oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
Cloudforms Team: | --- | Target Upstream Version: | |||||
Embargoed: | |||||||
Bug Depends On: | 1026838, 1018173 | ||||||
Bug Blocks: | 1022758 | ||||||
Attachments: |
|
Description
Toshiya Kobayashi
2013-09-17 07:00:38 UTC
Created attachment 798674 [details]
jBPMEx109_getTasksAssignedAsPotentialOwner_BZ
Just adding 'distinct' fails in Oracle because Oracle doesn't accept CLOB columns (name.text, subject.text, description.text) for distinct. Need to use I18NText.shortText like implemented in master as well. If you fix this BZ with 'distinct' + I18NText.shortText, you also need to backport BZ1018173 to BRMS 5.3.x branch because I18NText.shortText has a defect which is decribed in the BZ. backported to 5.2.x branch: https://github.com/droolsjbpm/jbpm/commit/751dfcb907cc26721b54ebad6d2fd2c17a19fffd this includes usage of distinct and change of text to shortText to all I18NText fields used in the queries. Verified with BRMS-5.3.1-P05 |