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 wor
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
ca