On 20 Dec 2005 at 19:53, Wei Yu wrote:

> I did investigate the problem for detail. It ends up that everything
> went to OK, if you return a empty dataset. BUT got error if there
> are data needs to be returned. and futher, if I comment the SUM(..)
> fields and GROUP BY clause. then I get the result set from this for
> execute statement. so IT MUST BE A BUG in the current version of
> FireBird.

It may be a bug, but not the bug you expect. The fact that FB does
not automatically convert types in EXECUTE STATEMENT is not a bug -
it is by design.
You can call 'a bug' that SUM(integer) may be not integer but this
is a different story.

--
SY, Dimitry Sibiryakov.