At 05:29 PM 18/01/2008, you wrote:

>Hi
>
>I have a query which works fine in a Sybase database but
>throws "Implementation limit exceeded" when executed against a
>Firebird
>database. I tried also SQL-92 syntax; the result is the same. If I
>remove the third table (SYS_EntityClass_LU) everything works
>fine.
>
>I am using version 2.1.0.16780-0 RC1.

Then please read the General Notes section of the release notes and don't post your problems to this list.

>select * from Relation rel, SYS_Keyword skw, SYS_EntityClass_LU sec
> where rel.KeywordID = skw.KeywordID and
> sec.ID = skw.EntityClassID and
> rel.RoleID = 2017 and
> sec.Name = 'relation.Relation' <----------------------------------
> order by rel.RoleID asc;

As a clue, read the DML and Configuration sections of the release notes carefully. Such a query is illegal in v.2.0 but in v.2.1 you can configure the server to accept them...

As another, make sure the server is finding the right error message file.

./heLen