OSDN > Find Software > Use planner hints on PostgreSQL > SCM > git > pg_hint_plan > Commit

Use planner hints on PostgreSQL
Fork

pg_hint_plan: Commit

firtst release

Revision	da398b84ad25a395af100451d88de57d7d0a4ac3 (tree)
Time	2020-07-14 17:36:22
Author	Kyotaro Horiguchi <horikyota.ntt@gmai...>
Commiter	Kyotaro Horiguchi

Mask non-significant parts of regression output

To stabilize test, mask more of non-significant parts of EXPLAIN output.

--- a/expected/ut-W.out

+++ b/expected/ut-W.out

		@@ -1241,7 +1241,7 @@ error hint:
1241	1241
1242	1242	\o
1243	1243	\! sql/maskout2.sh results/ut-W.tmpout
1244		- QUERY PLAN
	1244	+--(snip..)
1245	1245	--(snip..)
1246	1246	Append
1247	1247	-> Result

--- a/sql/maskout2.sh

+++ b/sql/maskout2.sh

		@@ -1,3 +1,3 @@
1	1	#! /bin/sh
2	2	cat $1 \| \
3		-sed 's/^-\+$/--(snip..)/;s/^$ \+Foreign File: $.*$/\1 (snip..)/'
	3	+sed 's/^ QUERY PLAN $/--(snip..)/;s/^-\+$/--(snip..)/;s/^$ \+Foreign File: $.*$/\1 (snip..)/'

		@@ -1,3 +1,3 @@
1	1	#! /bin/sh
2	2	cat $1 \| \
3		-sed 's/^-\+$/--(snip..)/;s/^\( \+Foreign File: \).*$/\1 (snip..)/'
	3	+sed 's/^ QUERY PLAN $/--(snip..)/;s/^-\+$/--(snip..)/;s/^\( \+Foreign File: \).*$/\1 (snip..)/'