One of our queries is giving error: Assertion failed
I was able to simplify the query to the following while it is still giving this same error:
SELECT CHORUS_B."SYSID", CHORUS_B."USERID", CHORUS_B."NAME",
CHORUS_B."LUDATE", CHORUS_B."CREDATE", CHORUS_B."SUSPEND", CHORUS_B."LUSYSID",
'SECURITY_USERUPDATE.BASEUSER' as "__objecttype__"
FROM SECURITY_USERUPDATE.BASEUSER AS CHORUS_B
INNER JOIN SECURITY.SCPUSER AS SU
ON (CHORUS_B.SYSID = SU.SYSID AND CHORUS_B.USERID = RTRIM(SU.USERMASK))
WHERE SU.SYSID = 'DE29'
I do not see anything in the query itself or the execution plan that would cause this error. In fact processing plan says "MERGE JOIN (ALREADY_SORTED/ALREADY_SORTED)" while based on the stacktrace it looks like data is still being sorted for the join. Is there hint I can try ?
Please advise. Both stacktrace and execution plans are attached. It runs on Teiid8/JBoss7.