创建一个100w的表，使用 row_number + limit 查询的时候，结果集会重复
问题复现：
CREATE TABLE test as
WITH t as (
SELECT 0 as id
UNION ALL
SELECT 1 as id
UNION ALL
SELECT 2 as id
UNION ALL
SELECT 3 as id
UNION ALL
SELECT 4 as id
UNION ALL
SELECT 5 as id
UNION ALL
SELECT 6 as id
UNION ALL
SELECT 7 as id
UNION ALL
SELECT 8 as id
UNION ALL
SELECT 9 as id
)
SELECT cast(t1.id as VARCHAR) as id FROM t t1
LEFT JOIN t t2 on 1 = 1
LEFT JOIN t t3 on 1 = 1
LEFT JOIN t t4 on 1 = 1
LEFT JOIN t t5 on 1 = 1
LEFT JOIN t t6 on 1 = 1;
SELECT count(1), count(DISTINCT rank_id) FROM (SELECT *, row_number() over(partition by 1 order by id desc) as rank_id FROM test k LIMIT 10000000 ) kk
