Filter: (c1 < 2500)

(12 rows)

/* Test recursive CTE */

create table test.recursive_cte_test_tbl(id int not null, name text not null);

select * from create_hash_partitions('test.recursive_cte_test_tbl', 'id', 2);

create_hash_partitions

------------------------

2

(1 row)

insert into test.recursive_cte_test_tbl (id, name) select id, 'name'||id from generate_series(1,100) f(id);

insert into test.recursive_cte_test_tbl (id, name) select id, 'name'||(id + 1) from generate_series(1,100) f(id);

insert into test.recursive_cte_test_tbl (id, name) select id, 'name'||(id + 2) from generate_series(1,100) f(id);

select * from test.recursive_cte_test_tbl where id = 5;

id | name

----+-------

5 | name5

5 | name6

5 | name7

(3 rows)

with recursive test as (select min(name) as name from test.recursive_cte_test_tbl where id = 5 union all select (select min(name) from test.recursive_cte_test_tbl where id = 5 and name > test.name) from test where name is not null) select * from test;

name

-------

name5

name6

name7

(4 rows)

DROP SCHEMA test CASCADE;

NOTICE: drop cascades to 51 other objects

DROP EXTENSION pg_pathman CASCADE;

VACUUM ANALYZEtest.index_on_childs;

EXPLAIN (COSTS OFF)SELECT*FROMtest.index_on_childsWHERE c1>100AND c1<2500AND c2=500;

createtabletest.recursive_cte_test_tbl(idintnot null, nametextnot null);

select*from create_hash_partitions('test.recursive_cte_test_tbl','id',2);

insert intotest.recursive_cte_test_tbl (id, name)select id,'name'||idfrom generate_series(1,100) f(id);

insert intotest.recursive_cte_test_tbl (id, name)select id,'name'||(id+1)from generate_series(1,100) f(id);

insert intotest.recursive_cte_test_tbl (id, name)select id,'name'||(id+2)from generate_series(1,100) f(id);

select*fromtest.recursive_cte_test_tblwhere id=5;

with recursive testas (selectmin(name)as namefromtest.recursive_cte_test_tblwhere id=5union allselect (selectmin(name)fromtest.recursive_cte_test_tblwhere id=5and name>test.name)from testwhere nameis not null)select*from test;

DROPSCHEMA test CASCADE;

DROP EXTENSION pg_pathman CASCADE;

DROPSCHEMA pathman CASCADE;