> i'm testing the code against a 1.0 server and against a 1.5 server.
> the problem seems to be in the server.
> ...
> i am a bit upset about this... switching to 1.5 will broke my code.
> did i do something wrong doing those type of queries?

This is a known problem with all InterBase versions up to 6.0 (do not
know anything about 6.5 and 7.0) and Firebird 1.0.x. It was changed
in 1.5, but I believe there's a configuration parameter that brings
old behavior back.

Roman