I’m sure that many of you use the magic query from Shlomi.
This query retrieves the difference between two status values with a single query.
I’m really fan of this kind of query and about this query in particular. This query is very useful to retrieve an information without to have to store a middle result.
Now, I tried this query on a MariaDB 5.5 server and I had a surprise :
The result was a bit strange, with negative or null values.
I’ve just had these server for few hours in my hands and I had no more time to analyze the situation.
I assume that the subquery optimisations in MariaDB can be involve here but it’s just an assumption.
Does anyone encountered the same issue? (with MariaDB or other distro)