Hello!
we are evaluation sapdb for a project and found a problem with self joins.
A example:
create table foo (
id smallint,
pos smallint,
txt varchar(2048)
);
Both selects didn't work:
select a.id
from foo a, foo b, foo c, foo d
where a.id = b.id
and b.id = c.id
and c.id = d.id
and a.pos = 1
and b.pos = 2
and c.pos = 3
and d.pos = 4
and (
a.txt = 'foo'
or b.txt = 'bar'
or c.txt = 'baz'
or d.txt = 'biz'
);
select a.id
from foo a, foo b, foo c, foo d
where a.id = b.id
and b.id = c.id
and c.id = d.id
and (
(a.pos = 1 and a.txt = 'foo')
or (b.pos = 2 and b.txt = 'bar')
or (c.pos = 3 and c.txt = 'baz')
or (d.pos = 4 and d.txt = 'biz')
)
;
Result of this selects are
"DBTech SQL: [-2000] (at 8343) Row too long"
It seems sapdb creates a result table with the columns of each from
table concatenated. Is this normal behaviour? If this is normal
behaviour, is it possible to do "large" self joins on a table with sapdb?
Greetings
Armin
--
Armin Haaf, mercatis information systems GmbH
Marlene-Dietrich-Str. 5 Fon +49 (0) 731 98588 - 615 ___o
89231 Neu-Ulm, Germany Fax +49 (0) 731 98588 - 511 _\ <_
http://www.mercatis.de mailto:[EMAIL PROTECTED] (_)�(_)
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
