[in-commerce] Affiliate Plans - can't save percent [5.1.0]

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:

I added an Affiliate Plan via Affiliates -> Affiliate Plan (ID: 1)
On the Brackets tab, I setup the following:
From Amount
To Amount
Percent
1 100 10
100 500 20
500 infinity 30
I saved the Affiliate plan.
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.

Related Tasks

MINC-72 - Getting issue details... STATUS

From Amount	To Amount	Percent
1	100	10
100	500	20
500	infinity	30