The problem is that, although it usually does work, SQL doesn't guarantee that the results will be always sorted properly in such a situation, and in some cases won't be (optimizer...