Select bug or bad indices

[Ivan Smahin]

On Nov 15, 2013, at 4:19 AM, Chris Jones <cjones at daz3d.com> wrote:

> So I re-indexed the problem table again and ran diagnosis on it, I am an error box that says:
> 
> "Kernel error: 0x83504.  Unique violation of index " S".
> 
> Running diagnosis  again I get:
> 
> Field: fldKeyword. Index record count (246125) differ from field one (323470).
> Field: fldKeyword. Index have 77345 missing records.
> 
> 
> Problems found!  ( Table: tblKeyword )
> 


Could you send that db for testing?
Is there the same results for that queries without any indexes on fldKeyword?

-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20131115/306aabd8/attachment.html>