diff options
| author | John Naylor <john.naylor@postgresql.org> | 2021-07-22 17:34:19 -0400 |
|---|---|---|
| committer | John Naylor <john.naylor@postgresql.org> | 2021-07-22 17:34:19 -0400 |
| commit | a0db4294aeffe428cdcb381fc66ba725ec588e95 (patch) | |
| tree | 8100de60d647c0ea1c4554f26bc32bd30e5e239b /src/backend/utils/adt/timestamp.c | |
| parent | 86a1aae764b03c7fe06e290e409c8d1a72ff187d (diff) | |
| download | postgresql-a0db4294aeffe428cdcb381fc66ba725ec588e95.tar.gz postgresql-a0db4294aeffe428cdcb381fc66ba725ec588e95.zip | |
Fix division by zero error in date_bin
Bauyrzhan Sakhariyev, via Github
Backpatch to v14
Diffstat (limited to 'src/backend/utils/adt/timestamp.c')
| -rw-r--r-- | src/backend/utils/adt/timestamp.c | 10 |
1 files changed, 10 insertions, 0 deletions
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; |