Priority: Not Evaluated
Affects Version/s: 5.15.2
Fix Version/s: None
Component/s: SQL Support
Have found another strange one.
For last few years I was using MySQL 5.6.xx and all was good but today I've even then MySQL Workbench started returning the wrong numbers if IFNULL or COALESCE were used in the query.
So I've though that it's 5.6.xx's fauld and have removed it and installed the latest 8.0.26.
And now the Workbench is returning the right numbers, but Qt still doesn't.
Now take notice that MySQL plugin was build against the 5.6. So maybe rebuilding it with 8.0 code will solve the issue.
Anyway check the image to get the feeling of what I'm talking about.
On the left side (at the bottom in the watch window you will see the invalid values returned).
I'll ping you if the latest 5.15 and latest MySQL rebuild does the same thing.