Direction on CALCITE-5213, nested correlated subquery conversion

[Ian Bertolacci]

Hello, JIRA CALCITE-5213 has been open for a while now and still seems to be an 
issue.
I’ve included small example which demonstrates the issue.
I’m hoping someone can figure out what might be happening here (hopefully I’m 
just doing something wrong) and see if there are possible solutions.
Thanks!
-Ian J. Bertolacci