NotificationsYou must be signed in to change notification settings
Fork5
Star26

Commit48b9ca0

committed

Fix possible sorting error when aborting use of abbreviated keys.

Due to an error in the abbreviated key abort logic, the most recentlyprocessed SortTuple could be incorrectly marked NULL, resulting in anincorrect final sort order.In the worst case, this could result in a corrupt btree index, whichwould need to be rebuild using REINDEX. However, abbrevation doesn'tabort very often, not all data types use it, and only one tuple wouldend up in the wrong place, so the practical impact of this mistake maybe somewhat limited.Report and patch by Peter Geoghegan.

1 parentc381326 commit48b9ca0Copy full SHA for 48b9ca0

File tree

1 file changed

-3

lines changed

src/backend/utils/sort
- tuplesort.c

1 file changed

-3

lines changed

`‎src/backend/utils/sort/tuplesort.c`

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -1443,7 +1443,7 @@ tuplesort_putindextuplevalues(Tuplesortstate *state, Relation rel,`
`1443`	`1443`	`mtup->datum1=index_getattr(tuple,`
`1444`	`1444`	`1,`
`1445`	`1445`	`RelationGetDescr(state->indexRel),`
`1446`		`-&stup.isnull1);`
	`1446`	`+&mtup->isnull1);`
`1447`	`1447`	`}`
`1448`	`1448`	`}`
`1449`	`1449`
`@@ -4271,7 +4271,7 @@ copytup_cluster(Tuplesortstate state, SortTuple stup, void *tup)`
`4271`	`4271`	`mtup->datum1=heap_getattr(tuple,`
`4272`	`4272`	`state->indexInfo->ii_KeyAttrNumbers[0],`
`4273`	`4273`	`state->tupDesc,`
`4274`		`-&stup->isnull1);`
	`4274`	`+&mtup->isnull1);`
`4275`	`4275`	`}`
`4276`	`4276`	`}`
`4277`	`4277`	`}`
`@@ -4588,7 +4588,7 @@ copytup_index(Tuplesortstate state, SortTuple stup, void *tup)`
`4588`	`4588`	`mtup->datum1=index_getattr(tuple,`
`4589`	`4589`	`1,`
`4590`	`4590`	`RelationGetDescr(state->indexRel),`
`4591`		`-&stup->isnull1);`
	`4591`	`+&mtup->isnull1);`
`4592`	`4592`	`}`
`4593`	`4593`	`}`
`4594`	`4594`	`}`

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!

Commit48b9ca0

File tree

1 file changed

1 file changed

`‎src/backend/utils/sort/tuplesort.c`

0 commit comments