V5RB - Phantom records in index

[Steve Albin]

Sorry for not including version.  I'm using version 5.5.5 for Xojo.  This is strictly a local version, no client server.

I converted my app to only use object pointers.  In previous versions, I created my own foreign keys and used the object pointers. It was an old app and at the time I developed it, quite frankly, I didn't quite understand the use of object pointers so I created my own foreign keys as well as the object pointers, but only retrieved records using the foreign keys.

I only have a few dozen users for my app, but all of them but one are successful using it.  This one user is running into the problem with phantom records, but he does things very unconventionally.  He is one of those users that finds ways to use your app that you never thought of.  (This is normally good!)  

I would have entered this in Mantis, but I don't think it is a Valentina bug.  You mention deletions so I'm going to look at that.  

Thanks,
Steve

--
Steve Albin, Montclair, NJ
http://www.steve-albin.com
http://www.jazzdiscography.com

On Oct 19, 2014, at 7:44 AM, Ruslan Zasukhin <ruslan_zasukhin at valentina-db.com> wrote:

> On 10/19/14, 6:30 AM, "Steve Albin" <steve at steve-albin.com> wrote:
> 
> Hi Steve,
> 
> Can you remind: 
>    * version 
>    * API you are using
>    * Local or client-server
> 
> 
>> For some SQL queries, I am getting repeats of the same records in the cursor.
>> When I view the database using VStudio, I can see that there is only one
>> record, but 5 of them will be returned in the cursor.
>> 
>> I don't think this is a bug in Valentina or my SQL.  But I do a diagnose on
>> the database and for one field involved the query, I have a problem where
>> diagnose says there are 4,848 phantom records in the index.
>> 
>> So, I believe I have an error in my app somewhere when I create these records.
>> My problem is that I'm not seeing it.
>> 
>> Is there something specific I can look for that creates phantom index records?
>> What is a "phantom" index record?
> 
> If I not mistaken,
> This is the case when index have { value, recID },
> but there is no record at recID.
> 
> So this is related to deletion of records I think.
> 
> May be there is sense to open issue in Mantis,
> And step by step collect info there.
> 
> 
> -- 
> 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]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina