Icon View Incident Report

Serious Serious
Reported By: Curt Mayers
Reported On: 5/21/2010
For: Version 2.03 Build 14
# 3223 NexusDB Migrator Converting Non-Unique Indexes to Primary Keys

I found a little problem with the NexusDB migrator.

It makes the assumption that the "default index" for a Nexus table is a primary key, and assumes it to be unique, even if it was not defined as such...


Comments Comments
The problem was that the NexusDB table component was setting the ixPrimary flag in the index definitions, but not the ixUnique flag, which is correct for NexusDB. However, the migration code assumed that any index with the ixPrimary flag was a primary key and, therefore, automatically unique.


Resolution Resolution
Fixed Problem on 6/14/2010 in version 2.03 build 15


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image