Bug 780093 (SOA-2460)

Summary: ModeShape_LARGEVALUE_USAGES table does not contain primary key
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Jiri Pechanec <jpechane>
Component: EDSAssignee: Van Halbert <vhalbert>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.1.0.ER3   
Target Milestone: ---   
Target Release: 5.1.0.ER4   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-2460
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2010-11-10 11:18:11 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Jiri Pechanec 2010-10-22 12:09:37 UTC
project_key: SOA

The table in question does not contain primary key on its id column. It can be a performance issue.

Comment 1 Van Halbert 2010-10-22 12:18:36 UTC
Link: Added: This issue depends MODE-976


Comment 2 Jiri Pechanec 2010-10-22 12:20:03 UTC
More precisely as this is a join table for node and large values it should contain primary key or unique constraint on tuple id largevalues_sha1 and separate index for id column

Comment 3 Van Halbert 2010-10-24 21:35:25 UTC
ModeShape has applied the fix to the 2.2.x branch.  Should be available now for those who pull the latest from 2.2.x branch.

Comment 4 Jiri Pechanec 2010-11-10 11:18:11 UTC
Verified in ER4