パッチです
これでいかがでしょうか？

============== patch ===========================
--- include/global.h.orig	Tue Aug 10 08:40:55 1999
+++ include/global.h	Sun Sep  5 10:45:29 1999
@@ -618,6 +618,7 @@
 				  int4store((T),def_temp); \
 				  int4store((T+4),def_temp2); \
 				}
+#ifdef WORDS_BIGENDIAN
 #define float4store(T,A)    { *(T)= ((byte *) &A)[3];\
                               *((T)+1)=(char) ((byte *) &A)[2];\
                               *((T)+2)=(char) ((byte *) &A)[1];\
@@ -648,6 +649,13 @@
                               ((byte*) &def_temp)[6]=(M)[1];\
                               ((byte*) &def_temp)[7]=(M)[0];\
 			      (V) = def_temp; }
+#else
+
+#define float4get(V,M)   memcpy((byte*) &V,(byte*) (M),sizeof(float))
+#define float4store(V,M) memcpy((byte*) &M,(byte*) (V),sizeof(float))
+#define float8get(V,M)   doubleget((V),(M))
+#define float8store(V,M) doublestore((V),(M))
+#endif
 
 #endif /* sint2korr */
============== patch END ===========================

=========結果=========== 
mysql> select email, sum(count) as total from count where date > '1999-08-27' and date < '1999-09-04' GROUP by email order by total  desc;
+-------------------------+-------+
| email                   | total |
+-------------------------+-------+
| testtest@xxxxxxxxxx |   242 |
| tateyan@xxxxxxxxxx |    74 |
+-------------------------+-------+
2 rows in set (0.01 sec)

-- 
 村上 毅  takeshi@xxxxxxxxxx
 Soft Agency Co., Ltd. TEL +81-48-661-1527
 PGP fingerprint = 45 5D 54 12 B4 55 77 7F  D4 52 66 EC 03 3F 1B E9
 [ http://www.softagency.co.jp/mysql/ ]
 [ MySQL ML: mysql-guide@xxxxxxxxxx ]