HELP : CORE DUMP on select sum ..

I have Problem when selecting aggregates from a table. Please have a look at these statements which describe the problem : The Table looks like that : create table t_core ( i1 integer , i2 integer , i3 integer ) ; INSERT INTO t_core VALUES (1,1,1); Here are some (simple ?) selects. a) select sum(i1*i2)/sum(i2) from t_core ; CORE DUMP b) select sum(i1*i2),sum(i2) from t_core ; RETURNS 1 1 c) select sum(i1*i2) v1 ,sum(1/i2) v2 from t_core INTO TEMP test ; RETURNS 1 1.00 into temp Table d) select v1/v2 FROM test CORE DUMP e) select sum(i1/i2)/sum(i3) from t_core ; CORE DUMP f) select sum(i1/i2)*sum(1/i3) from t_core ; RETURNS 1.00 just now i'm working with the reciprokal solution f) but i hope that there is a better solution Hardware is SCO 3.2.4 INFORMIX ONLINE 5.00.UD1 thanks in advance Chris +++++++++++++++++++++++++++++++++ ---------------------------- greetings from Christoph Schiffer \\ / Voice : +49 2104 9385-18 chris@csl-gmbh.net o FAX : +49 2104 9385-55 CSL-GmbH Erkrath / \\ http://www.csl-gmbh.net --------------------------------- +++++++++++++++++++++++++++++