[Cdash] dynamicanalysisdefect.value: string or numeric?

Markus Grabner grabner at icg.tugraz.at
Tue Sep 30 15:54:56 UTC 2008


    In "index.php", the column "value" of the table "dynamicanalysisdefect " 
is used as a numeric value (its sum is computed) in the SQL query

"SELECT sum(dd.value) FROM dynamicanalysisdefect AS dd..."

However, the column is defined as "varchar(50)". MySQL silently converts 
strings to integers in the sum, PostgreSQL reports an error in the query 
above. So my question is if the column "dynamicanalysisdefect.value" can be 
changed in the database to a numeric data type, or are there other situations 
where this field actually stores a string which is not a number?

	Thanks & kind regards,

Markus Grabner - Computer Graphics and Vision
Graz University of Technology, Inffeldgasse 16a/II, 8010 Graz, Austria
Phone: +43/316/873-5041, Fax: +43/316/873-5050
WWW: http://www.icg.tugraz.at/Members/grabner

More information about the CDash mailing list