Lutz Steinborn wrote:
> Hello Armin,
>
> I had a similar problem some time ago with ADABAS D11.0.
We tried it with adabas too, it's the same problem. With postgres,db2,
oracle there's no problem.
> But without an error message. It result in a very long running query
> (20 min. for 20 results). I've found a solution in changing the query
> like this: select a.id
> from foo a, foo b, foo c, foo d
> where a.id = b.id
> and a.id = c.id
> and a.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'
> );
>
> Try it.
Didn't work, same Problem, [at 8214]Row too long
> A different solution might be to do some quries in tmp tables.
tmp tables? The only other solution I know is to use unions and
intersects, but the performance sucks...
Armin
>
> Regards
>
> Lutz
>
> On Thu, 14 Feb 2002 12:04:56 +0100
> Armin Haaf <[EMAIL PROTECTED]> wrote:
>
>
>>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
>>
>
>
--
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] (_)�(_)
--
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
