id	summary	reporter	owner	description	type	status	priority	component	severity	resolution	keywords	cc	release
13405	sum totalhours returns int instead decimal	Rochi	Russ Tyndall	"Trac 1.2.2

TimingAndEstimationPlugin 1.5.7b0

MariaDB 10.0.34


If I enter a decimal value for hours like 0.5 the totalhours field is always increased to the next integer value (here 1).

The code casts the newvalue with
{{{
#!sql
CAST( newvalue AS DECIMAL)
}}}

But if you look to the mysql or mariadb documentation ""DECIMAL"" is used as ""DECIMAL(10,0)"" so the scale is 0 (number of digits after the decimal point).
see
https://mariadb.com/kb/en/library/decimal/
https://dev.mysql.com/doc/refman/5.5/en/fixed-point-types.html

So the cast have to look like
{{{
#!sql
CAST( newvalue AS DECIMAL(10,2))
}}}

I've attached a patch."	defect	new	normal	TimingAndEstimationPlugin	normal				1.2