Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit1d494b6

Browse files
committed
Remove two tests inadvertently added in2b27273
1 parent2b27273 commit1d494b6

File tree

2 files changed

+0
-18
lines changed

2 files changed

+0
-18
lines changed

‎src/test/regress/expected/indexing.out

Lines changed: 0 additions & 16 deletions
Original file line numberDiff line numberDiff line change
@@ -1082,22 +1082,6 @@ insert into fastpath select generate_series(1,10000), 'b', 100;
10821082
vacuum fastpath;
10831083
set enable_seqscan to false;
10841084
set enable_bitmapscan to false;
1085-
explain select sum(a) from fastpath where a = 6456;
1086-
QUERY PLAN
1087-
------------------------------------------------------------------------------------
1088-
Aggregate (cost=4.31..4.32 rows=1 width=8)
1089-
-> Index Only Scan using fpindex1 on fastpath (cost=0.29..4.30 rows=1 width=4)
1090-
Index Cond: (a = 6456)
1091-
(3 rows)
1092-
1093-
explain select sum(a) from fastpath where a >= 5000 and a < 5700;
1094-
QUERY PLAN
1095-
-------------------------------------------------------------------------------------
1096-
Aggregate (cost=5.41..5.42 rows=1 width=8)
1097-
-> Index Only Scan using fpindex1 on fastpath (cost=0.29..5.29 rows=50 width=4)
1098-
Index Cond: ((a >= 5000) AND (a < 5700))
1099-
(3 rows)
1100-
11011085
select sum(a) from fastpath where a = 6456;
11021086
sum
11031087
------

‎src/test/regress/sql/indexing.sql

Lines changed: 0 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -592,8 +592,6 @@ vacuum fastpath;
592592
set enable_seqscan to false;
593593
set enable_bitmapscan to false;
594594

595-
explainselectsum(a)from fastpathwhere a=6456;
596-
explainselectsum(a)from fastpathwhere a>=5000and a<5700;
597595
selectsum(a)from fastpathwhere a=6456;
598596
selectsum(a)from fastpathwhere a>=5000and a<5700;
599597

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp