Commit7262f24

committed

Fix BRIN minmax-multi distance for timetz type

The distance calculation ignored the time zone, so the result of (b-a)might have ended negative even if (b > a). Fixed by considering the timezone difference.Reported-by: Jaime CasanovaDiscussion:https://postgr.es/m/CAJKUy5jLZFLCxyxfT%3DMfK5mtPfSzHA1rVLowR-j4RRsFVvKm7A%40mail.gmail.com

1 parent2b10e0e commit7262f24Copy full SHA for 7262f24

File tree

-1

lines changed

-1

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -2090,7 +2090,7 @@ brin_minmax_multi_distance_timetz(PG_FUNCTION_ARGS)`
`2090`	`2090`	`TimeTzADT*ta=PG_GETARG_TIMETZADT_P(0);`
`2091`	`2091`	`TimeTzADT*tb=PG_GETARG_TIMETZADT_P(1);`
`2092`	`2092`
`2093`		`-delta=tb->time-ta->time;`
	`2093`	`+delta=(tb->time-ta->time)+ (tb->zone-ta->zone)*USECS_PER_SEC;`
`2094`	`2094`
`2095`	`2095`	`Assert(delta >=0);`
`2096`	`2096`

Comments

(0)