> Heres the definitions you wanted.
> There are some triggers but if I do the same statement in IBExpert it
> works so I'm assuming the triggers are OK.

I have tried to reproduce the issue, but cannot. I suspect it has to do
something with triggers. I have tried to defined some triggers, but they did
not help.

Can you take the Jaybird sources and put a breakpoint in
AbstractJavaGDSImpl.getSqlCounts method after the second line where buffer
is initialized and then send me the contents of the buffer that confuses the
driver?

Alternatively you can send me your database, so I can check it on my
computer.

Also the driver version and server version are needed.

Roman