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:36:26 -0400 |
| commit | 81322fc409743f9ef169cb7bd89b0d0113a0aaa1 (patch) | |
| tree | 68bf4263e5080d1804a1fcea85c8a6457b903c19 /src/backend/utils/adt/timestamp.c | |
| parent | b1c1b7af573bbc9fe9039c82ffb7d3a3c378fe4a (diff) | |
| download | postgresql-81322fc409743f9ef169cb7bd89b0d0113a0aaa1.tar.gz postgresql-81322fc409743f9ef169cb7bd89b0d0113a0aaa1.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; |