From: Date: June 4 2005 7:27pm
Subject: [-9111]: System error: Move error
List-Archive: http://lists.mysql.com/maxdb/25498
Message-Id: <20050604172712.18111.qmail@web88104.mail.re2.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi List,

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?

Regards
Alexei Novakov