Re: Why Query Cache Actived Returns Wrong Results?

[Daniel Estrada]

Thank you for your attention...
This is the query:

SELECT SUBSTRING(clave,1,2) AS result1,
SUM(vol) AS total_vol,
SUM(result) AS total_result,
FROM mainTable
WHERE date fecha1<='201205'
AND clave LIKE 'V%'
GROUP BY SUBSTRING(clave,1,2);

The results sometimes have some rows with value 0, but If I execute this query:

SELECT SUBSTRING(clave,1,2) AS result1,
SUM(vol) AS total_vol,
SUM(result) AS total_result,
FROM mainTable
WHERE date fecha1<='201205'
AND substring(clave, 1, 2)='VA';

This query returns the specific result with value 0, the result is correct, All the rows have values... If I execute this query with cache disabled, all the results are right, but I really need to use cache... Maybe my configuration is wrong...