Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 334359

Summary: [DB] Duplicate entries in cdo_package_infos
Product: [Modeling] EMF Reporter: Egidijus Vaisnora <vaisegid>
Component: cdo.dbAssignee: Egidijus Vaisnora <vaisegid>
Status: CLOSED FIXED QA Contact: Eike Stepper <stepper>
Severity: normal    
Priority: P3 CC: stepper
Version: 4.0Flags: stepper: review+
Target Milestone: ---   
Hardware: PC   
OS: Mac OS X - Carbon (unsup.)   
Whiteboard:
Attachments:
Description Flags
patch v1 none

Description Egidijus Vaisnora CLA 2011-01-14 04:48:12 EST 
Working with MySQL. I got duplicated entries for "cdo_package_infos" table (uri was duplicated). 
Seems like code omit to create PK constraint on "uri" column.
Comment 1 Egidijus Vaisnora CLA 2011-01-14 05:18:19 EST 
Created attachment 186811 [details]
patch v1

Ensure to add UNIQUE index for PK column
Comment 2 Eike Stepper CLA 2011-01-17 04:26:00 EST 
I'm sorry but our CVS->Git migration takes longer than expected and it's not yet clear that we want to keep Git. Until a final decision is taken by the team and all workflows work as expected all reviews are on hold...
Comment 3 Eike Stepper CLA 2011-01-25 08:10:18 EST 
I vaguely recall that my initial goal was to use specific SQL syntax for PK creation. It probably didn't work very well so I removed that special handling and forgot to add the if-condition in createIndex ;-(

Please go ahead.
Comment 4 Egidijus Vaisnora CLA 2011-01-25 10:12:17 EST 
committed to trunk, revision 6930
Comment 5 Eike Stepper CLA 2011-06-23 03:41:19 EDT 
Available in R20110608-1407