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?

https://github.com/box/Anemometer/blob/1a4cca940046a465065e7388d4789cfc0d424485/lib/Anemometer.php#L365-L368

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