You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
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:
This query will return an empty resultset, altough there is a fitting row.
When I remove the apostrophe it works:
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.
The text was updated successfully, but these errors were encountered: