[Cdash] dynamicanalysisdefect.value: string or numeric?
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
More information about the CDash