> :) The problem is not in syntax, I've posted only the pattern of the
> real query and if I'd had problem in syntax I'd received error before
> the query was executed. In my case the same query is executed
> normally under SYSDBA user and hangs when it is executed under non-
> SYSDBA user.

Lack of sql privileges does not cause Firebird to hang,
so you must find error somewhere in you application.

Ivan