rentzsch.com: tales from the red shed

Panther Server MySQL datetime Sorting Bug

Bugs
Mac OS X Server 10.3.2 ships with MySQL 4.0.16. Don't bother turning it on: it's broken out-of-the-box. It fails to correctly sort rows when faced with an ORDER BY directive on a "datetime" column.

This is fairly basic database functionality, and it significantly reduced my opinion of the quality of Mac OS X Server. My line of thought is: if this slipped by, what else is broken?

The work-around is simple: ignore Apple's installation. Instead, download and install the binary directly from mysql.com.

Monday, January 12, 2004
11:42 PM