Subject Re: SQL question: bug or feature?
Author sserdyuk_05446
So you think it is a feature. It did not seem to be logical to me.
I realize they re-compute "in" expressions, but I was excepting
it to be happenning on pre-delete snapshot.
Btw, my college has checked it on MS SQL and it worked there

> Sigh. The "in" expression is being computed for each record
> rather than once for the whole delete. Once the two records
> with "ACTIVE RECORD = N" are deleted, nothing else matches.
> There are a variety of work arounds.