Hi, with the help of Michal we found an error within the optimizer concerning subqueries on index columns. Thanks to Michal for reporting. We'll fix this bug in one of the next releases no time schedule by now.
Kind regards, Holger SAP Labs Berlin > -----Original Message----- > From: Becker, Holger > Sent: Freitag, 28. März 2003 10:17 > To: 'Michal Wójcik'; [EMAIL PROTECTED] > Subject: RE: General error;-9111 POS(1) System error: Move error. > > > Michal Wójcik wrote: > > > I am new with SAP DB, but I found a problem: > > When I am executed following query: > > SELECT FROM IndexQueue WHERE Car_Id <= 900 AND Car_Id IN > > (SELECT Card.Car_Id > > FROM Card, DtdForDivision WHERE Int_Id = 2 AND Dii_Id = > > Dii_DivisionId) > > > > I received error: > > [SAP AG][SQLOD32 DLL][SAP DB]General error;-9111 POS(1) > > System error: Move > > error. > > > > I found that this error is caused by sub query, no matter > > what there is, eg: > > SELECT FROM IndexQueue WHERE Car_Id <= 900 AND Car_Id IN > > (SELECT Card.Car_Id > > FROM Card) > > > > This situation exists, when column Car_Id from IndexQueue has > > no primary key > > (even if index exists). This problem disappeared when I > > created primary key > > for Car_Id column. > > Please provide the kernel version and the knldiag.err of your > database > because there is more information about this error. > > Kind regards, > Holger > SAP Labs Berlin > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
