It worked for me if I start out with some domain declaration for ID

Create Domain ID bigint;

----- Original Message -----
From: "Daniel Putra" <dp@...>
To: "Mailing List: firebird-support" <firebird-support@yahoogroups.com>
Sent: Thursday, January 17, 2008 12:10 PM
Subject: [firebird-support] Implementation limit exceeded


> 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.
>
> 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;
>
> Here is the DDL:
>
> CREATE TABLE RELATION(
> KEYWORDID ID NOT NULL,
> ORIGINATINGOBJECTID Numeric(18,0),
> RELATEDOBJECTID Numeric(18,0),
> ROLEID Smallint NOT NULL,
> PRIMARY KEY (KEYWORDID)
> );
>
> CREATE TABLE SYS_KEYWORD(
> KEYWORDID ID NOT NULL,
> ENTITYCLASSID Numeric(18,0),
> PRIMARY KEY (KEYWORDID)
> );
>
> CREATE TABLE SYS_ENTITYCLASS_LU(
> ID Numeric(18,0) NOT NULL,
> NAME Varchar(1600),
> PRIMARY KEY (ID)
> );
>
> ALTER TABLE RELATION ADD CONSTRAINT FK_RELATION_REF_95626_SYS_KEYW
> FOREIGN KEY (KEYWORDID) REFERENCES SYS_KEYWORD (KEYWORDID) ON
> DELETE CASCADE;
>
> ALTER TABLE SYS_KEYWORD ADD CONSTRAINT FK_SYS_KEYW_REF_SYS_ENTITYCLS
> FOREIGN KEY (ENTITYCLASSID) REFERENCES SYS_ENTITYCLASS_LU
> (ID);
>
>
> Any help in greatly appreciated.
>
> Best regards
> Daniel Putra
> South Africa
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>