NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commitb26d8fd

committed

Protect GIST logic that assumes penalty values can't be negative.

Apparently sane-looking penalty code might return small negative values,for example because of roundoff error. This will confuse places likegistchoose(). Prevent problems by clamping negative penalty values tozero. (Just to be really sure, I also made it force NaNs to zero.)Back-patch to all supported branches.Alexander Korotkov

1 parente73bd1e commitb26d8fdCopy full SHA for b26d8fd

File tree

2 files changed

+13

-3

lines changed

doc/src/sgml
- gist.sgml
src/backend/access/gist
- gistutil.c

2 files changed

+13

-3

lines changed

`‎doc/src/sgml/gist.sgml`

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -374,6 +374,8 @@ my_decompress(PG_FUNCTION_ARGS)`
`374`	`374`	`Returns a value indicating the <quote>cost</quote> of inserting the new`
`375`	`375`	`entry into a particular branch of the tree. Items will be inserted`
`376`	`376`	`down the path of least <function>penalty</function> in the tree.`
	`377`	`+ Values returned by <function>penalty</function> should be non-negative.`
	`378`	`+ If a negative value is returned, it will be treated as zero.`
`377`	`379`	`</para>`
`378`	`380`
`379`	`381`	`<para>`

`‎src/backend/access/gist/gistutil.c`

Lines changed: 11 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -13,6 +13,8 @@`
`13`	`13`	`*/`
`14`	`14`	`#include"postgres.h"`
`15`	`15`
	`16`	`+#include<math.h>`
	`17`	`+`
`16`	`18`	`#include"access/gist_private.h"`
`17`	`19`	`#include"access/reloptions.h"`
`18`	`20`	`#include"storage/freespace.h"`
`@@ -532,16 +534,22 @@ gistpenalty(GISTSTATE *giststate, int attno,`
`532`	`534`	`{`
`533`	`535`	`floatpenalty=0.0;`
`534`	`536`
`535`		`-if (giststate->penaltyFn[attno].fn_strict== FALSE\|\| (isNullOrig== FALSE&&isNullAdd== FALSE))`
	`537`	`+if (giststate->penaltyFn[attno].fn_strict== FALSE\|\|`
	`538`	`+(isNullOrig== FALSE&&isNullAdd== FALSE))`
	`539`	`+{`
`536`	`540`	`FunctionCall3(&giststate->penaltyFn[attno],`
`537`	`541`	`PointerGetDatum(orig),`
`538`	`542`	`PointerGetDatum(add),`
`539`	`543`	`PointerGetDatum(&penalty));`
	`544`	`+/* disallow negative or NaN penalty */`
	`545`	`+if (isnan(penalty)\|\|penalty<0.0)`
	`546`	`+penalty=0.0;`
	`547`	`+}`
`540`	`548`	`elseif (isNullOrig&&isNullAdd)`
`541`	`549`	`penalty=0.0;`
`542`	`550`	`else`
`543`		`-penalty=1e10;/* try to preventto mix null and non-null`
`544`		`- value /`
	`551`	`+penalty=1e10;/* try to preventmixing null and non-null`
	`552`	`+ values /`
`545`	`553`
`546`	`554`	`returnpenalty;`
`547`	`555`	`}`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

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

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitb26d8fd

File tree

2 files changed

2 files changed

`‎doc/src/sgml/gist.sgml`

`‎src/backend/access/gist/gistutil.c`

0 commit comments