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