Subquery - Planning error. Could not find symbol

[mtawk]

I have an issue happening on a specific query containing subquery joins and I am getting the exception: org.teiid.core.TeiidRuntimeException: Planning error. Could not find symbol...

if I remove one join from the query it executes successfully.

you find attached the exception error along with the query SQL and the query plan.

[shawkins]

What version are you on?  And have you run this scenario in latest version?

[mtawk]

we are using Teiid version 10.2.1 but we have patched the fix for this error from TEIID-5636

And the patch has solved the symbol error for the cases we have sent earlier.

Now this is a new case that is reproduced uniquely when using subquery joins

[shawkins]

If this still occurs against the latest version, please open an issue.

[mtawk]

It is reproduced on the latest version.

Issue opened: TEIID-5721