let $message=
      ... to reproduce a bug ... seen on Suse 9.3 with 5.0.23-bk
      .
      ChangeSet@1.2211, 2006-06-28 10:11:43-07:00, patg@govinda.patg.net
      .;
--source include/show_msg80.inc

--disable_warnings
DROP FUNCTION IF EXISTS fn2;
--enable_warnings
delimiter //;
CREATE FUNCTION fn2( f1 bigint unsigned) returns bigint unsigned
BEGIN
set f1 = (f1 / 2); set f1 = (f1 * 2); set f1 = (f1 - 10); set f1 = (f1 + 10);
return f1;
END//
delimiter ;//

--echo ... check a numeric result, shouldn_t it be 18400000000000000000  both with and without --ps-protocol?
SELECT fn2(1.84e+19);

SELECT fn2(1.84e+18);
SELECT fn2(1.84e+17);
SELECT fn2(1.84e+16);
SELECT fn2(1.84e+15);
SELECT fn2(1.84e+14);
SELECT fn2(1.84e+13);
SELECT fn2(1.84e+12);
SELECT fn2(1.84e+11);
SELECT fn2(1.84e+10);
SELECT fn2(1.84e+09);
SELECT fn2(1.84e+08);
SELECT fn2(1.84e+07);
SELECT fn2(1.84e+06);
SELECT fn2(1.84e+05);
SELECT fn2(1.84e+04);
SELECT fn2(1.84e+03);
SELECT fn2(1.84e+02);
SELECT fn2(1.84e+01);
SELECT fn2(1.84e+00);
SELECT fn2(1.84e-00);
SELECT fn2(1.84);
SELECT fn2(1.84e-01);
SELECT fn2(1.84e-02);

DROP FUNCTION fn2;