In the process of upgrading mysql from 3.22.32 to 3.23.24 our sql seems to have broken.
SELECT sum(evalgames) as evaluatedgames,newrank.pos,round((avg(standing)),2) avg_standing
FROM newrank
WHERE
newrank.pos = 'FH'
GROUP BY newrank.pid
HAVING !(evaluatedgames between 0 and 1)
ORDER BY standing DESC LIMIT 10;
Works perfectly on the old system and not the new. All the fingers point to the 'HAVING' clause not evaluating the 'SUM()'. Is there a work around for this?
Please don't reply with it works fine on mine, as I know it works on some versions of MySql.
Thanks,
Paymon Yau
SELECT sum(evalgames) as evaluatedgames,newrank.pos,round((avg(standing)),2) avg_standing
FROM newrank
WHERE
newrank.pos = 'FH'
GROUP BY newrank.pid
HAVING !(evaluatedgames between 0 and 1)
ORDER BY standing DESC LIMIT 10;
Works perfectly on the old system and not the new. All the fingers point to the 'HAVING' clause not evaluating the 'SUM()'. Is there a work around for this?
Please don't reply with it works fine on mine, as I know it works on some versions of MySql.
Thanks,
Paymon Yau