Just found out a curiosity which was only recently fixed:
If you ask a database for a SELECT COUNT(1)
you expect to have a result of 1
(or get an error because of the missing FROM
, like Oracle does). But MySQL until version 5.0.24a returns 0
. Starting with version 5.0.27 it returns the correct 1
;
So MySQL was not only counting your input in a wrong way, the developers also changed the output behaviour during minor (bugfix) releases. Anybody seen a note about this change (which was not hidden in some dozen changelog pages)?
Categories:
[Other-Dbs]