Fix Rows Loss in JOIN and UNION ALL Queries

Fix possible rows loss for queries with JOIN and UNION ALL. Fixes #9826, #10113. ... #10099 (Nikolai Kochetov)