Subject Re: [firebird-support] Object is in use?
Author Dimitry Sibiryakov
> So, can anyone explain if this is 1) a bug or 2) as designed and if it's
> as deigned 3) why and 4) how to avoid it or solve it without a disconnect?

If you can reproduce your test case with isql, it may be regarded as
a problem with FB. But most likely FR (IBPP) just does not free
statement handle after SELECT from A. As long as prepared statements,
which use the object exist - the object is in use. This is "by design".