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 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.
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
