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