Fix Infinite Query Execution on LIMIT with Infinite Sources

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