On Wed, Feb 23, 2011 at 3:06 AM, Kjell Rilbe <kjell.rilbe@...> wrote:

>
> Odd. I thought views didn't support order by at all. If that's correct,
> it should complain at view creation time, not accept the DDL and then
> return incorrect or incomplete results.
>

ORDER BY is included in view definitions in the 2008 standard. If Firebird
accepts the syntax and fails to produce correct results, put together a test
case and submit a bug. We old farts are still grumbling about the fluff and
feathers that went into SQL 2008, so ignore us.


Good luck,

Ann


[Non-text portions of this message have been removed]