[V4RB] DELETE and Index Corruption

[Ruslan Zasukhin]

on 5/4/03 10:43 PM, Frank Schima at frank-list at mindstarprods.com wrote:

> Hi Ruslan,
> 
> 
> I just discovered a strange problem with Indexes in V4RB 1.9.8b2.
> 
> I have a large database where I deleted all 3 records from a table
> using the DELETE FROM sql. This table has an ObjectPointer to another
> table. I added a single record to the now empty original table using
> INSERT sql.
> 
> Now when I query that table with a simple SELECT * FROM myTable, I get
> the record. But when I query that record as follows:
> 
>   SELECT * FROM myTable WHERE ObjectPtrField = 1234
> 
> I get the correct number of columns returned, but no rows! Now it gets
> really weird. If I put quotes around the value like so:
> 
>   SELECT * FROM myTable WHERE ObjectPtrField = "1234"
> 
> Then it works!!
> 
> So I deleted the index file and let it rebuild and all works normal
> again.
> 
> Conclusion: The index can get corrupted when records are deleted from a
> table with ObjectPointer fields.

Hi Frank,

Am I right that this is NOT always ?
Actually just once ?

Can you reproduce?
As I see table was quite small, correct?
May be something special combination of values in that records?


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------