At 12:25 PM 3/01/2005 -0200, you wrote:

>Hi,
>
>System: FB Superserver in Windows XP Pro
>
>I have the next query statement that shutdown abnormally the server during
>the prepare query:
>
>The firebird log is: C:\Arquivos de
>programas\Firebird\Firebird_1_5\bin\fbserver.exe: terminated abnormally
>(4294967295)
>
>Query:
>"select B.Nome,
>(select cast(coalesce(sum(case CC.evento
> when 'E' then AA.qtde*L.preco_unit
> when 'S' then -AA.qtde*L.preco_unit
> end),0) as Numeric (9,2))
> from movimentacao_itens_est AA
> join movimentacao_est BB on AA.cod_movimentacao=BB.codigo
> join tipo_mov_est CC on BB.cod_tipo_mov=CC.codigo
> where AA.COD_MATERIAL=A.cod_material

and CC.evento in ('E', 'S')

>) as Total
>from requisicoes_est C
>join requisicoes_itens_est A on A.cod_requisicao=C.codigo
>join almoxarifados_est B on B.codigo=C.cod_almoxarifado
>join compras_Itens_est L on L.cod_material=A.cod_material
>join compras_est M on M.codigo=L.cod_compra
>where M.DATA IN(
>SELECT MAX(C.DATA) FROM COMPRAS_est C WHERE
>EXISTS(SELECT 1 FROM COMPRAS_ITENS_est D WHERE D.COD_COMPRA=C.CODIGO
>AND D.COD_MATERIAL=L.COD_MATERIAL))
>and C.Data between :di and :df
>group by 1
>order by 2 desc"
>
>If I get rid off the group by clause the query prepare ok.

./hb