Hello.
What exact version of MySQL are you using? Please could you provide a
repeatable test case.
Scott Klarenbach wrote:
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
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