diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/indexing.out | 16 | ||||
| -rw-r--r-- | src/test/regress/sql/indexing.sql | 2 |
2 files changed, 0 insertions, 18 deletions
diff --git a/src/test/regress/expected/indexing.out b/src/test/regress/expected/indexing.out index ecd2b110ff4..33f68aab712 100644 --- a/src/test/regress/expected/indexing.out +++ b/src/test/regress/expected/indexing.out @@ -1082,22 +1082,6 @@ insert into fastpath select generate_series(1,10000), 'b', 100; vacuum fastpath; set enable_seqscan to false; set enable_bitmapscan to false; -explain select sum(a) from fastpath where a = 6456; - QUERY PLAN ------------------------------------------------------------------------------------- - Aggregate (cost=4.31..4.32 rows=1 width=8) - -> Index Only Scan using fpindex1 on fastpath (cost=0.29..4.30 rows=1 width=4) - Index Cond: (a = 6456) -(3 rows) - -explain select sum(a) from fastpath where a >= 5000 and a < 5700; - QUERY PLAN -------------------------------------------------------------------------------------- - Aggregate (cost=5.41..5.42 rows=1 width=8) - -> Index Only Scan using fpindex1 on fastpath (cost=0.29..5.29 rows=50 width=4) - Index Cond: ((a >= 5000) AND (a < 5700)) -(3 rows) - select sum(a) from fastpath where a = 6456; sum ------ diff --git a/src/test/regress/sql/indexing.sql b/src/test/regress/sql/indexing.sql index 80f4adc6aad..ab7c2d14758 100644 --- a/src/test/regress/sql/indexing.sql +++ b/src/test/regress/sql/indexing.sql @@ -592,8 +592,6 @@ vacuum fastpath; set enable_seqscan to false; set enable_bitmapscan to false; -explain select sum(a) from fastpath where a = 6456; -explain select sum(a) from fastpath where a >= 5000 and a < 5700; select sum(a) from fastpath where a = 6456; select sum(a) from fastpath where a >= 5000 and a < 5700; |