Fix Infinite Query Execution Issue with LIMIT in Infinite Sources

Fix possible infinite query execution when the query actually should stop on LIMIT, while reading from infinite source like system.numbers or system.zeros. #10206 (Nikolai Kochetov)