VDB 4.2 - delete from [Table] where [Column] in(Value List)
John Tamburo
started a topic
about 9 years ago
VistaDB 4.2
SQL: "Delete from D_ANIMAL where AN_ID in(8953,8954);"
AN_ID is an INT Identity and the PK of the table.
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
about 9 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.
John Tamburo
VistaDB 4.2
SQL: "Delete from D_ANIMAL where AN_ID in(8953,8954);"
AN_ID is an INT Identity and the PK of the table.
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?