hi,
i've been working with adabas and sapdb for a number of
years. good work. keep it up!
using the brand new version of sapdb i've encountered a
problem with joins in a select: and it's rather basic.
1) using suse linux 7.2 i fully deinstalled 7.4.3.7 and then
installed the new 7.4.3.10 (i.e. no update).
2) i then ran my data definition
CREATE TABLE WORDBASE_T (
ID SERIAL NOT NULL,
EQUATE VARCHAR(254) NOT NULL,
PRIMARY KEY (ID)
)
//
CREATE UNIQUE INDEX WORDBASEEQUATE_X ON WORDBASE_T (
EQUATE ASC
)
//
CREATE TABLE MIMETYPE_T (
ID SERIAL NOT NULL,
CONTEXT INTEGER,
SUBCONTEXT INTEGER,
PRIMARY KEY (ID),
CONSTRAINT FK_MIMETYPE_MIMETYPE_WORDBASE2 FOREIGN KEY (CONTEXT)
REFERENCES WORDBASE_T (ID) ON DELETE CASCADE,
CONSTRAINT FK_MIMETYPE_MIMETYPE_WORDBASE1 FOREIGN KEY (SUBCONTEXT)
REFERENCES WORDBASE_T (ID) ON DELETE CASCADE
)
//
CREATE UNIQUE INDEX MIMETYPE_X ON MIMETYPE_T (
CONTEXT ASC,
SUBCONTEXT ASC
)
//
3) then i performed the following...
select t.ID, wc.EQUATE Context, ws.EQUATE Subcontext
from MIMETYPE_T t, WORDBASE_T wc, WORDBASE_T ws
where t.CONTEXT = wc.ID and t.SUBCONTEXT = ws.ID
and wc.equate = 'internal' and ws.equate = 'file'
which resulted with the following error:
native error -8 general;-8 POS(-1) Execution failed, parse again.
also attached as bitmap.
as i have already said, this has worked with previous sapdb versions.
after manually inserting the first row in mimeType_t the
select worked correctly.
insert into wordBase_t set equate = 'internal'
insert into wordBase_t set equate = 'file'
insert into mimeType_t set context = 1, subcontext = 2
assuming the above are the first inserts in wordbase_t
btw, when will ignore trigger be available for inserts and deletes?
thanx in advance,
John Holland
Consultant
BANCOTEC
Ein Unternehmen der Cellent AG.
Calwer Strasse 33, 70173 Stuttgart
Tel: ++49 711 222 992 900
Fax: ++49 711 222 992 999
Mobile: ++49 172 7886719
mailto:[EMAIL PROTECTED]
http:\\www.bancotec.de
http:\\www.cellent.de
<<attachment: error.gif>>
