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
Mysql seems to have a problem returning ordered lists from views.
ie, 'select * from myView order by column' does not return a properly
ordered list. (it does change the ordering sequence, but to an
erroneous list)
converting myView to be a Temporary Table using 'ALGORITHM=TEMPTABLE'
in the 'CRE
