MySQL checksum field not properly escaped

[AndreasSchaek]

On the table search main page I click on the checksum of a query to view its details.
Some of the queries can't be found and I get an error: 'Unknown checksum'
When I dig into the queries that are executed I find the following:

SELECT `checksum` FROM `global_query_review` WHERE `checksum`='11572617643159325603'

This query will return an empty resultset, altough there is a fitting row.
When I remove the apostrophe it works:

SELECT `checksum` FROM `global_query_review` WHERE `checksum`=11572617643159325603

The checksum column is a bigint and the apostrophe is not needed AFAIK.
In my local installation I adjusted all occurences of a WHERE with $checksum_field_name and it works great, using MySQL 5.5.30.

[yoku0825]

Does this cause translate_checksum function?

Anemometer/lib/Anemometer.php

Lines 365 to 368 in 1a4cca9

	if (preg_match('/^[0-9]+$/', $checksum))
	{
	return $checksum;
	}

When hexed-checksum was constructed only numeric characters, translate_checksum regards it as already translated to bigint.