Assertion failed

[nsabina]

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.

Thanks,

Sabina

[shawkins]

Sabina,

I believe this is https://issues.jboss.org/browse/TEIID-2190  Can you try your query with the patch or on 8.2 to confirm?

Steve