Jason Dodson wrote:

> Hey all,
>
> I came in this morning to a list of complaints that data was missing. Upon investigation, it ended up being a stored
> procedure was returning nothing. This procedure hasn't changed in two years, so as to what the cause could be was
> puzzling. I started a lengthy process of debugging this procedure only to find that there was no logic error. This
> should be returning data. After some playing around, I ended up using the metadata of this procedure and made an
> identical one, appending "test" to the end of the procedure name. Weirdly enough, this new procedure works as the old
> one was expected to. I was able to then drop the procedure and recreate it with exactally its own metadata definition...
> not changes at all... and now it works.
>
> Should I be concerned?
>
> Jason

I cannot help but Firebird developers would be concerned ,I think.

Maybe....broken BLR code ? Impossible ,I hope.
Do you still have original database ? It might be needed to recreate
this case.

Regards
Boguslaw