id	summary	reporter	owner	description	type	status	priority	component	severity	resolution	keywords	cc	release
1697	Hour reports not working with Trac 10.4 & MySQL 5.0	duckie@parnet.fi	bobbysmith007	E.g. when opening 'ticket hours grouped by component' report the following error message appears:\r\n\r\n'' Report execution failed: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'REAL) as Estimated_work,\\n CAST(totalhours.value as REAL) as Total_work,\\n ' at line 11") ''\r\n\r\nThis error seems to be related to the fact that MySQL doesn't support casting to REAL. (http://dev.mysql.com/doc/refman/5.0/en/differences-from-ansi.html). \r\n\r\nI haven't had time to test it yet but I guess the problem could be solved by replacing '''REAL''' with '''DECIMAL'''.	defect	closed	normal	TimingAndEstimationPlugin	normal	invalid			0.10