[kepler-dev] [Bug 4512] missing entries with multiple copies of the same KAR file in a single repository

[bugzilla-daemon at ecoinformatics.org]

http://bugzilla.ecoinformatics.org/show_bug.cgi?id=4512

--- Comment #3 from Aaron <aschultz at nceas.ucsb.edu> 2009-12-02 11:41:44 PST ---
With the new Library changes, having two different KARS with the same LSIDs
works fine now.

As for having multiple identical KARS in the local repositories (i.e. the KAR
LSIDs are the same) this is a structural flaw of the database desing.  Because
the primary key of the KARS_CACHED table is the KAR LSID there is no way to
keep track of multiple copies of the same KAR at the moment.  During the cache
synchronization any identical KARS are just skipped.

This could be fixed by making the primary key of the KARS_CACHED table an
autoincremented integer instead of the KAR LSID.  This would change the
KAR_CONTENTS table as well since it has a foreign key to the KAR LSID in the
KARS_CACHED table.  Some code changes would be needed as well in order to
properly handle identical KARS.

It certainly wouldn't be too terribly impossible to fix this but may take a
couple days of time.

-- 
Configure bugmail: http://bugzilla.ecoinformatics.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.