v.22.4Bug Fix

Fix Subquery Implementation Issues

Fix any/all (subquery) implementation. Closes #35489. #35727 (Kseniia Sumarokova).