How does your database count?

Posted by ads on Thursday, 2006-12-14
Posted in [Other-Dbs]

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]
Tags: [Mysql] [Oracle]