-----Ursprüngliche Nachricht----- Von: sin...@mysql.com [mailto:sin...@mysql.com] Gesendet: Montag, 13. März 2000 13:30 An: dol...@mdsys.de Betreff: Re: Query - what's wrong?

Hi there!

I've shutdown the MySQL server with "mysqladmin shutdown", then I've started myisamchk -r temp_op2 ... no errors. But I've done some analysis with a new table:

create table op3 ( IDX DOUBLE PRECISION NOT NULL AUTO_INCREMENT, PKTNR INTEGER (11) NOT NULL, OPBETRAG NUMERIC(15, 2), OPREF VARCHAR (8), PRIMARY KEY (IDX) )

filled the table with the following values:

PKTNR OPBETRAG OPREF "452149" "-25018" "100" "452149" "25276" "100" "452149" "514,8" "100" "452149" "-772,8" "100"

select * from op3 ...

IDX PKTNR OPBETRAG OPREF 1 452149 -25018 100 2 452149 25276 100 3 452149 514,8 100 4 452149 -772,8 100

with the following query i don't receive any row (of course...)

select *, sum(OPBETRAG) as optst from op3 group by PKTNR having optst <> 0

when i change the value of OPBETRAG in the rows with IDX no. 2 and 3

IDX PKTNR OPBETRAG OPREF 2 452149 25276,4 100 3 452149 514,4 100

and run the upper query again, i get 1 row with optst = "0.00".

When i import the table op3 in m$ access and start that group-query there, it works. This really bugs me, so what can i do to fix this problem...

regards marc

sinisa wrote: