Subject Re: [firebird-support] Bug #546274 state
Author Alexandre Benson Smith
At 16:21 20/01/2004 -0300, you wrote:

>The bug <#546274 group by EXTRACT function doesn't work> appear as closed and
>fixed but at changes history at the end of tracker's detailed view page appear
>as opened and with resolution id as none.
>What's the real state of this bug? I'm asking because i can't test with RC8
>right now and with RC7 the bug still exists.

Hi Valdir,

I have just tried

sum(cmp_total), extract(year from emissao), extract(month from emissao)
group by
extract(year from emissao), extract(month from emissao)
order by
2, 3

Appears to work fine, no errors, but I do not check if the values are correct.

What errors do you get ?

Sintax or wrong values ?

Alexandre Benson Smith
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil


Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
Version: 6.0.564 / Virus Database: 356 - Release Date: 19/01/2004

[Non-text portions of this message have been removed]