diff -U3 /tmp/cirrus-ci-build/contrib/cube/expected/cube.out /tmp/cirrus-ci-build/build/testrun/cube/regress/results/cube.out --- /tmp/cirrus-ci-build/contrib/cube/expected/cube.out 2024-04-02 17:04:22.223813381 +0000 +++ /tmp/cirrus-ci-build/build/testrun/cube/regress/results/cube.out 2024-04-02 17:05:25.979761694 +0000 @@ -2,6 +2,16 @@ -- Test cube datatype -- CREATE EXTENSION cube; +WARNING: PageSetPrunable setting pd_prune_xid=740 +WARNING: PageSetPrunable setting pd_prune_xid=740 +WARNING: PageSetPrunable setting pd_prune_xid=740 +WARNING: PageSetPrunable setting pd_prune_xid=740 +WARNING: PageSetPrunable setting pd_prune_xid=740 +WARNING: PageSetPrunable setting pd_prune_xid=740 +WARNING: PageSetPrunable setting pd_prune_xid=740 +WARNING: PageSetPrunable setting pd_prune_xid=740 +WARNING: PageSetPrunable setting pd_prune_xid=740 +WARNING: PageSetPrunable setting pd_prune_xid=740 -- Check whether any of our opclasses fail amvalidate SELECT amname, opcname FROM pg_opclass opc LEFT JOIN pg_am am ON am.oid = opcmethod @@ -1536,8 +1546,113 @@ -- CREATE TABLE test_cube (c cube); \copy test_cube from 'data/test_cube.data' +WARNING: calling heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: heap_page_prune_opt did not find enough space +WARNING: page has free space +WARNING: calling heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: heap_page_prune_opt did not find enough space +WARNING: page has free space +WARNING: calling heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: heap_page_prune_opt did not find enough space +WARNING: page has free space +WARNING: calling heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: heap_page_prune_opt did not find enough space +WARNING: page has free space +WARNING: calling heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: heap_page_prune_opt did not find enough space +WARNING: page has free space +WARNING: calling heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: heap_page_prune_opt did not find enough space +WARNING: page has free space +WARNING: calling heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: heap_page_prune_opt did not find enough space +WARNING: page has free space +WARNING: calling heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: heap_page_prune_opt did not find enough space +WARNING: page has free space +WARNING: page has free space +WARNING: calling heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: heap_page_prune_opt did not find enough space +WARNING: calling heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: heap_page_prune_opt did not find enough space +WARNING: page has free space +WARNING: calling heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: heap_page_prune_opt did not find enough space +WARNING: page has free space +WARNING: calling heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: heap_page_prune_opt did not find enough space +WARNING: page has free space +WARNING: calling heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: heap_page_prune_opt did not find enough space +WARNING: page has free space +WARNING: calling heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: heap_page_prune_opt did not find enough space +WARNING: page has free space +WARNING: calling heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: heap_page_prune_opt did not find enough space +WARNING: page has free space +WARNING: calling heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: heap_page_prune_opt did not find enough space +WARNING: page has free space +WARNING: page has free space +WARNING: calling heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: heap_page_prune_opt did not find enough space +WARNING: page has free space +WARNING: calling heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: heap_page_prune_opt did not find enough space +WARNING: calling heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: heap_page_prune_opt did not find enough space +WARNING: page has free space +WARNING: calling heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: heap_page_prune_opt did not find enough space +WARNING: page has free space +WARNING: calling heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: heap_page_prune_opt did not find enough space +WARNING: page has free space +WARNING: calling heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: heap_page_prune_opt did not find enough space +WARNING: page has free space +WARNING: calling heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: heap_page_prune_opt did not find enough space +WARNING: page has free space +WARNING: calling heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: heap_page_prune_opt did not find enough space +WARNING: page has free space +WARNING: calling heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: heap_page_prune_opt did not find enough space +WARNING: page has free space CREATE INDEX test_cube_ix ON test_cube USING gist (c); SELECT * FROM test_cube WHERE c && '(3000,1000),(0,0)' ORDER BY c; +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt c -------------------------- (337, 455),(240, 359) @@ -1549,6 +1664,11 @@ -- Test sorting SELECT * FROM test_cube WHERE c && '(3000,1000),(0,0)' GROUP BY c ORDER BY c; +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt c -------------------------- (337, 455),(240, 359) @@ -1571,6 +1691,10 @@ (4 rows) SELECT c FROM test_cube WHERE c <@ '(3000,1000),(0,0)' ORDER BY c; +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt c ------------------------- (337, 455),(240, 359) @@ -1582,10 +1706,18 @@ RESET enable_bitmapscan; -- Test kNN INSERT INTO test_cube VALUES ('(1,1)'), ('(100000)'), ('(0, 100000)'); -- Some corner cases +WARNING: page has free space +WARNING: page has free space +WARNING: page has free space SET enable_seqscan = false; -- Test different metrics SET extra_float_digits = 0; SELECT *, c <-> '(100, 100),(500, 500)'::cube as dist FROM test_cube ORDER BY c <-> '(100, 100),(500, 500)'::cube LIMIT 5; +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt c | dist -------------------------+------------------ (337, 455),(240, 359) | 0 @@ -1597,6 +1729,11 @@ RESET extra_float_digits; SELECT *, c <=> '(100, 100),(500, 500)'::cube as dist FROM test_cube ORDER BY c <=> '(100, 100),(500, 500)'::cube LIMIT 5; +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt c | dist -------------------------+------ (337, 455),(240, 359) | 0 @@ -1607,6 +1744,11 @@ (5 rows) SELECT *, c <#> '(100, 100),(500, 500)'::cube as dist FROM test_cube ORDER BY c <#> '(100, 100),(500, 500)'::cube LIMIT 5; +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt c | dist -------------------------+------ (337, 455),(240, 359) | 0 @@ -1618,6 +1760,18 @@ -- Test sorting by coordinates SELECT c~>1, c FROM test_cube ORDER BY c~>1 LIMIT 15; -- ascending by left bound +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt ?column? | c ----------+--------------------------- 0 | (0, 100000) @@ -1638,6 +1792,18 @@ (15 rows) SELECT c~>2, c FROM test_cube ORDER BY c~>2 LIMIT 15; -- ascending by right bound +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt ?column? | c ----------+--------------------------- 0 | (0, 100000) @@ -1658,6 +1824,20 @@ (15 rows) SELECT c~>3, c FROM test_cube ORDER BY c~>3 LIMIT 15; -- ascending by lower bound +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt ?column? | c ----------+--------------------------- 0 | (100000) @@ -1678,6 +1858,20 @@ (15 rows) SELECT c~>4, c FROM test_cube ORDER BY c~>4 LIMIT 15; -- ascending by upper bound +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt ?column? | c ----------+--------------------------- 0 | (100000) @@ -1698,6 +1892,20 @@ (15 rows) SELECT c~>(-1), c FROM test_cube ORDER BY c~>(-1) LIMIT 15; -- descending by left bound +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt ?column? | c ----------+------------------------------- -100000 | (100000) @@ -1718,6 +1926,20 @@ (15 rows) SELECT c~>(-2), c FROM test_cube ORDER BY c~>(-2) LIMIT 15; -- descending by right bound +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt ?column? | c ----------+------------------------------- -100000 | (100000) @@ -1738,6 +1960,20 @@ (15 rows) SELECT c~>(-3), c FROM test_cube ORDER BY c~>(-3) LIMIT 15; -- descending by lower bound +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt ?column? | c ----------+------------------------------- -100000 | (0, 100000) @@ -1758,6 +1994,20 @@ (15 rows) SELECT c~>(-4), c FROM test_cube ORDER BY c~>(-4) LIMIT 15; -- descending by upper bound +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt ?column? | c ----------+------------------------------- -100000 | (0, 100000) @@ -1782,6 +2032,42 @@ SET enable_indexscan = OFF; SET extra_float_digits = 0; SELECT *, c <-> '(100, 100),(500, 500)'::cube as dist FROM test_cube ORDER BY c <-> '(100, 100),(500, 500)'::cube LIMIT 5; +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt c | dist -------------------------+------------------ (337, 455),(240, 359) | 0 @@ -1793,6 +2079,42 @@ RESET extra_float_digits; SELECT *, c <=> '(100, 100),(500, 500)'::cube as dist FROM test_cube ORDER BY c <=> '(100, 100),(500, 500)'::cube LIMIT 5; +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt c | dist -------------------------+------ (337, 455),(240, 359) | 0 @@ -1803,6 +2125,42 @@ (5 rows) SELECT *, c <#> '(100, 100),(500, 500)'::cube as dist FROM test_cube ORDER BY c <#> '(100, 100),(500, 500)'::cube LIMIT 5; +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt c | dist -------------------------+------ (337, 455),(240, 359) | 0 @@ -1813,6 +2171,42 @@ (5 rows) SELECT c~>1, c FROM test_cube ORDER BY c~>1 LIMIT 15; -- ascending by left bound +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt ?column? | c ----------+--------------------------- 0 | (0, 100000) @@ -1833,6 +2227,42 @@ (15 rows) SELECT c~>2, c FROM test_cube ORDER BY c~>2 LIMIT 15; -- ascending by right bound +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt ?column? | c ----------+--------------------------- 0 | (0, 100000) @@ -1853,6 +2283,42 @@ (15 rows) SELECT c~>3, c FROM test_cube ORDER BY c~>3 LIMIT 15; -- ascending by lower bound +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt ?column? | c ----------+--------------------------- 0 | (100000) @@ -1873,6 +2339,42 @@ (15 rows) SELECT c~>4, c FROM test_cube ORDER BY c~>4 LIMIT 15; -- ascending by upper bound +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt ?column? | c ----------+--------------------------- 0 | (100000) @@ -1893,6 +2395,42 @@ (15 rows) SELECT c~>(-1), c FROM test_cube ORDER BY c~>(-1) LIMIT 15; -- descending by left bound +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt ?column? | c ----------+------------------------------- -100000 | (100000) @@ -1913,6 +2451,42 @@ (15 rows) SELECT c~>(-2), c FROM test_cube ORDER BY c~>(-2) LIMIT 15; -- descending by right bound +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt ?column? | c ----------+------------------------------- -100000 | (100000) @@ -1933,6 +2507,42 @@ (15 rows) SELECT c~>(-3), c FROM test_cube ORDER BY c~>(-3) LIMIT 15; -- descending by lower bound +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt ?column? | c ----------+------------------------------- -100000 | (0, 100000) @@ -1953,6 +2563,42 @@ (15 rows) SELECT c~>(-4), c FROM test_cube ORDER BY c~>(-4) LIMIT 15; -- descending by upper bound +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt +WARNING: in heap_page_prune_opt ?column? | c ----------+------------------------------- -100000 | (0, 100000)