You have received the benefit of an honorable bug. I say "honorable" because
it riddled IB4, then it f***ed IB5 and it still spoils IB6 and FB. It may be
related to a weird "conversion error" when sorting some data, that's another
strange bug.

If you can distill a very small db with only a couple of records and the bug
still happens, it will be a good test case for Firebird.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing

<marcos.otc@...> wrote in message news:9q1p9i+ev90@......

> I am using Firebird WI.T1.0.0.448 (aka Beta2)
> and trying to do this :
>
> SELECT P.ID_ALOJ_GRJ, V.JA_PEGO
> FROM PEGA P JOIN V_ALOJ_GALPAO_PEGOS V ON (P.ID_ALOJ_GLP =
> V.ID_ALOJ_GALPAO)
> order by P.ID_ALOJ_GRJ
>
> and I am getting this :
>
> ID_ALOJ_GRJ JA_PEGO
> 112 4320
> 112 1837
> 112 4320
> 112 4320
> 114 16337 <----------- Why this wrong order ?
> 112 12421
> 112 12587
> 112 12587
> 112 12035
>
> the situation worsens when I try to group the same resultset
> with :
>
> SELECT P.ID_ALOJ_GRJ, SUM(V.JA_PEGO)
> FROM PEGA P JOIN V_ALOJ_GALPAO_PEGOS V ON (P.ID_ALOJ_GLP =
> V.ID_ALOJ_GALPAO)
> GROUP BY P.ID_ALOJ_GRJ
>
> ID_ALOJ_GRJ SUM
> 112 14797
> 114 16337
> 112 49630
>
> What kind of disaster is happening ?
> Can anyone help me with this ?
>
> (ID_ALOJ_GRJ is an integer column)
>
> TIA,
>
> MNobre
>
> (I am an old user (Delphi programmer) of Interbase)
>
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>