SELECT f1, MIN(f2), AVG(f2), SUM(f2) FROM t1 

GROUP BY f1 LIMIT 1;

f1	MIN(f2)	AVG(f2)	SUM(f2)

1	1.0	1.00000	1.0

Warnings:

Error	1918	Encountered illegal value '' when converting to DECIMAL

# Test case:

--disable_warnings

DROP TABLE IF EXISTS t1;

--enable_warnings

CREATE TABLE t1 ( f1 INT, f2 decimal(20,1) ) ENGINE=MyISAM;

--disable_query_log

let $i= 11000;

--echo # <Insert $i rows into the table>

while ($i)

{

  eval INSERT INTO t1 values($i,$i);

  dec $i;

}

--enable_query_log

INSERT INTO t1 values(11001,NULL),(11001,NULL);

SELECT f1, MIN(f2), AVG(f2), SUM(f2) FROM t1 

  GROUP BY f1 LIMIT 1;

DROP TABLE IF EXISTS t1;

# End of test case