[Firebird-test] AVG is not properly defined

[Skopalik S. <sko...@hl...>]

From description of AVG function (Original FireBird Lang. Ref.) I can't
determine result of this:
CREATE TABLE test( id INTEGER NOT NULL CONSTRAINT unq UNIQUE,
                   text VARCHAR(32));

INSERT INTO test VALUES(5,null);
INSERT INTO test VALUES(6,null);
INSERT INTO test VALUES(6,null);
SELECT AVG(id) FROM test;

FB 1.0.821 - result is 5 !

It's see as SUM() DIV COUNT() insted Round(SUM()/COUNT).

	Slavek

ing. Slavomir Skopalik DEL a.s.
Olomoucka 355 Marianske udoli 783 75
Czech Republic
----------------------------------------------
Tel: 068 535 35 48
Mobil: 0602 795 874
Fax: 068 535 23 64
e-mail:sko...@hl...
http://hlubocky.del.cz