>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.

At 04:48 AM 24/02/2011, Ann Harrison wrote:

>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.

Must add that, if Firebird became "SQL 2008 compliant" in this regard at some point, it is undocumented. So, if you would be so kind, please prepare a test case demonstrating that you are able to get away with ORDER BY in a view definition, without encountering an "Unknown token: ORDER" error at commit, and submit it to the Tracker.

./heLen