Initially we used float as database column type for costs. Floats get rounding issues with values above 130,000.00 or below -130,000.00. Therefore we limited allowed values to this range. This is uncomfortable if you want to use higher values for task costs.
The columns actual_costs and target_costs of the tables task and del_task are changed from float to NUMERIC(12,2). This requires two ALTER TABLE statements copying and changing the tables task and del_task.
Be prepared for a long running time and high IO load on the database servers due to this update task.
The columns actual_costs and target_costs of the tables task and del_task are changed from float to NUMERIC(12,2). This requires two ALTER TABLE statements copying and changing the tables task and del_task.
Be prepared for a long running time and high IO load on the database servers due to this update task.