Addition: Order By Statement in Views not working properly

[Scott Klarenbach]

Must be a bug of sorts:

If you add an ORDER BY clause to the view itself, then mysql allows
the caller to override with their own ORDER BY clause and it works as
expected.  However; if no ORDER BY clause is present in the CREATE
VIEW statement, then the caller receives erroneous results if they
call the view with their own ORDER BY clause.

Scott Klarenbach.