Fix Infinite Query Execution Issue 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).