[firebird-support] Re: Unexpected behaviour when using union

[roydamman]

Hello Ismael!

>
> select * from (select "TESTID", "NAME" from test 
> union select "TESTID", "NAME" from test) t order by upper(2)
> 

The query is indeed accepted by Firebird, but the sorting result is wrong as 
for a single select (as found out later).