I attached (2 by mistakes) test case with a test as described in the description of the ticket.

In the test, you can see that the non nested version of the query work:

{code:sql}select teacher from Teacher teacher where size(teacher.skills) > 0{code}

While the nested one doesn’t:

{code:sql}select student from Student student where size(student.teacher.skills) > 0{code}