concerning my posted problem (couple of days now), another company contacted me by mail and told me that they have the same problem.
- Is this a known problem (if not then it should be known by now)?
- When is it expected to be fixed?
- Do you need some further stuff from me to find the bug?
regards
Andreas
Andreas Fuchs wrote:
Hello,
porting from Oracle I've encountered some probs with subselects in sapdb7.4.
The first one works in sapdb 7.3:
select .... from ....
where ...euqi-joins... a.x in
( select ... from .... b.y in
(select .... from .... where .... ))
order by z
in sapdb 7.4:
2002-12-11 13:51:09 6022 ERR 54111 MOVE VGG04.8: 21[32768]->1[1024] len:-8
2002-12-11 13:51:09 6022 ERR 51080 SYSERROR -9111 Move error
The second one:
SELECT A.*,
(SELECT AT.ATEXT FROM RABATTTEXTE RT, A_LMT AT
WHERE RT.RABATTTEXT_ID=A.RABATTTEXT_ID AND
RT.A_TEXT_ID = AT.A_TEXT_ID AND
AT.SPRACH_KZ = 'D') ATEXT,
(SELECT T.STEXT FROM RABATTARTEN RA, LMT T
WHERE RA.RABATTART_ID=A.RABATTART_ID AND
RA.TEXT_ID = T.TEXT_ID AND
T.SPRACH_KZ = 'D') STEXT
FROM EK_RABATTE A
WHERE A.REC_STATUS < '9'
results in a kernel crash:
2002-12-11 15:50:46 0 ERR 11330 COREHAND ABORTING due to signal 8
2002-12-11 15:50:47 0 ERR 11599 BTRACE ----> Emergency Stack Back Trace <----
2002-12-11 15:50:47 0 ERR 11599 BTRACE (0):0x8294dca [0x45a64844](0x45a76cd0,0x45a650cc,0x45a64b64,0x45a65074)
I know that I could solve some Problems with joining the table in a different way, but the software I want to port is HUGE (complete ERP-System) and the developers liked subselects.
Any Ideas?
Andreas
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
