Database for testing, Unique in v1 is not unique in v2.

[Ruslan Zasukhin]

On 12/17/05 1:51 AM, "Ivan Smahin" <IvanSmahin at public.kherson.ua> wrote:

HI Ivan,
HI Stan

> SB> Ruslan asked me to send you the database I have problems to convert.
> SB> It is available here: http://www.maxprog.com/misc/valentina/
> SB> Database_ConvertCrash.zip
> 
> SB> Converting this v1 database to v2 I get:
> 
> SB> ERROR: 0x23503 Attempt to insert duplicate key row in object
> SB> "GroupList" with unique index "U_GroupList_GroupList_GroupID".
> 
> SB> It refers to a field that is set a VUnique in v1 however v1_to_v2
> SB> converter finds duplicates. The index has been rebuilt.
> 
> SB> Problem is that such file in now unconvertible because:
> 
> SB> With Valentina.ThrowExceptions = True, I get the VException.
> SB> With Valentina.ThrowExceptions = False, I get a crash.
> 
> SB> Please feel free to contact me if you need anything else that may
> SB> help you to sort that out.
> 
> At least you may consider such steps as temporary workaround:
> 
> 1. 1.x version - Remove Unique flag from the GropID field.
> 2. Perform Convert_1_2.
> 3. 2.x version - Set collator strength to UCOL_IDENTICAL value for this field.
> 4. 2.x version - Make it unique.
> 
> The problem:
> GroupID  is  a string  unique  field. It contains some local-specific  data.
> For some records the data could be considered as equal
> (UCOL_DEFAULT_STRENGTH is not so strict as UCOL_IDENTICAL).
> 
> Example:
> RecID 1300 considered as EQUAL for RecID 44 ( UCOL_DEFAULT_STRENGTH)
> RecID 2504 considered as EQUAL for RecID 842
> ...
> 
> and so on..

Aha, so problem is Valentina 1.x have use binary compare of strings,
But Valentina 2.x uses language local rules.

And right, collator option UCOL_IDENTICAL is almost binary compare.

Ivan, can you show also VALUES of e.g. 1300 and 44 records?
Interesting to see what they are.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]