--- "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 Alexei. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
