From 81322fc409743f9ef169cb7bd89b0d0113a0aaa1 Mon Sep 17 00:00:00 2001 From: John Naylor Date: Thu, 22 Jul 2021 17:34:19 -0400 Subject: Fix division by zero error in date_bin Bauyrzhan Sakhariyev, via Github Backpatch to v14 --- src/backend/utils/adt/timestamp.c | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'src/backend/utils/adt/timestamp.c') diff --git a/src/backend/utils/adt/timestamp.c b/src/backend/utils/adt/timestamp.c index 79761f809c8..ea847576cd2 100644 --- a/src/backend/utils/adt/timestamp.c +++ b/src/backend/utils/adt/timestamp.c @@ -3843,6 +3843,11 @@ timestamp_bin(PG_FUNCTION_ARGS) stride_usecs = stride->day * USECS_PER_DAY + stride->time; + if (stride_usecs == 0) + ereport(ERROR, + (errcode(ERRCODE_DATETIME_VALUE_OUT_OF_RANGE), + errmsg("stride cannot equal zero"))); + tm_diff = timestamp - origin; tm_delta = tm_diff - tm_diff % stride_usecs; @@ -4021,6 +4026,11 @@ timestamptz_bin(PG_FUNCTION_ARGS) stride_usecs = stride->day * USECS_PER_DAY + stride->time; + if (stride_usecs == 0) + ereport(ERROR, + (errcode(ERRCODE_DATETIME_VALUE_OUT_OF_RANGE), + errmsg("stride cannot equal zero"))); + tm_diff = timestamp - origin; tm_delta = tm_diff - tm_diff % stride_usecs; -- cgit v1.2.3