Imported From: http://groups.google.com/group/in-portal-bugs/browse_thread/thread/cf1569e8ea5b92a5#
Nikita recently fixed this in a project. Here is the original bug report:
1. I added an Affiliate Plan via Affiliates -> Affiliate Plan (ID: 1)
2. On the Brackets tab, I setup the following:
From Amount / To Amount / Percent
-------------------------------------------------
1 / 100 / 10
100 / 500 / 20
500 / infinity / 30
3. I saved the Affiliate plan.
4. I edited the Affiliate plan, opened the Brackets tab and saw that all of
the Percents reset to 9.99.
Nikita can explain more exactly what was fixed, but as far as I understood,
it had to do with how MySQL now stores DECIMAL(3,2) fields. This was also
fixed in a couple other tables with the same problem.
Original bug report was for version 5.1.0. Also tested on 5.1.2-beta2.