Alexei Novakov wrote: > --- "Becker, Holger" <[EMAIL PROTECTED]> wrote: > > > Alexei Novakov wrote: > > > > > I trying out latest MaxDB version 7.5.0.26 and ran > > > into a problem with extremely simple query: > > > > > > select T1.ENTITY_ID, T2.ENTITY_DOWN_FK > > > from ENTITY_E T1, RELATIONSHIP_R T2 > > > where T1.ENTITY_ID = 3640722049958068233 > > > and T2.TYPE_FK = 201104 > > > and 3640722049958068233 = T2.ENTITY_UP_FK > > > order by T2.ORDER_R, 1, 2 > > > > > > It results: "[-9111]: System error: Move error" I > > > guess this is some kind of internal error. It > > supposed > > > to return 3 records in result set. It starts > > working > > > OK if I remove and of listed columns in "ORDER BY" > > > clause (for instance "order by T2.ORDER_R, 1" > > works > > > fine). It also works fine if I add T2.ORDER_R into > > > select. > > > > > > Any ideas? > > > > Hi, > > > > you are right it's an internal error and there is > > more > > information in the knldiag or knldiag.err about the > > problem. > > > > Please send one of those file to the list. > > > > Kind regards > > Holger > > > > Hi, > > Yes I found corresponding message in the knldiag.err. > Here it is: > > 2005-06-04 13:13:23 0x67C ERR 11012 MOVECODE Bad > parameter: limit source 80 destination 80, source > [0X7E687858]+49, destination [0X7E687858]+0, 12 bytes > 2005-06-04 13:13:23 0x67C ERR 51080 SYSERROR > -9111 Move error > 2005-06-04 13:13:23 0x67C ERR 11012 MOVECODE + > 2005-06-04 13:13:23.640 MOVECODE ERROR 11014 > 2005-06-04 13:13:23 0x67C ERR 11012 MOVECODE - > Module Join_JoinOperator.cpp call index 3 > 2005-06-04 13:13:23 0x67C ERR 11012 MOVECODE Bad > parameter: limit source 80 destination 80, source > [0X7E687858]+49, destination [0X7E687858]+0, 12 bytes
Hi, I was able to reproduce the bug and we'll fix it with one of the next builds. For detailed information about target release see http://www.sapdb.org/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1136011. Thanks for reporting this bug. Kind regards Holger -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
