Re: Addition: Order By Statement in Views not working properly

2005-10-26 Thread Gleb Paharenko
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

Addition: Order By Statement in Views not working properly

2005-10-25 Thread 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 ca