Hi Fernando,

> But it seems that the bug involving the FIRST clause in subqueries
> is really confirmed. Unfortunatelly, it's not listed in the open
> bugs nor in release notes.

The reason could be the following. FIRST/SKIP makes sense only when the
result set is ordered. Since the ORDER BY clause isn't allowed in select
expressions (i.e. subqueries, views, etc), the engine may simply ignore
FIRST/SKIP in such constructs. Just a guess. We should decide whether it's
right or not before considering it an obvious bug.


Dmitry