Fix Pipeline Stuck Error with ORDER BY After RIGHT or FULL Join

Fix possible Pipeline stuck error while using ORDER BY after subquery with RIGHT or FULL join. #18550 (Nikolai Kochetov).