VDB 4.2 - delete from [Table] where [Column] in(Value List)

John Tamburo

Deletes several thousand rows instead of just the two specified and then stops when it hits a FK dependency that stops it.

I can duplicate this in the data builder with ease 100% of the time.

Deleting each row key individually is easy and it works properly.

This is romper-room SQL. Id this a VistaDB bug that must be addressed?

1 Comment

Kendall Miller

said
almost 3 years ago

VistaDB 4.x had a defect in the IN operator which was largely fixed in 5.0, however the 5.0 optimizer has issues with it in some cases which we have fixed in version 5.0.4 which has now been published.