pgsql: Avoid unexpected conversion overflow in planner for distant date
От | Tom Lane |
---|---|
Тема | pgsql: Avoid unexpected conversion overflow in planner for distant date |
Дата | |
Msg-id | E1PXnF7-0001du-DS@gemulon.postgresql.org обсуждение исходный текст |
Список | pgsql-committers |
Avoid unexpected conversion overflow in planner for distant date values. The "date" type supports a wider range of dates than int64 timestamps do. However, there is pre-int64-timestamp code in the planner that assumes that all date values can be converted to timestamp with impunity. Fortunately, what we really need out of the conversion is always a double (float8) value; so even when the date is out of timestamp's range it's possible to produce a sane answer. All we need is a code path that doesn't try to force the result into int64. Per trouble report from David Rericha. Back-patch to all supported versions. Although this is surely a corner case, there's not much point in advertising a date range wider than timestamp's if we will choke on such values in unexpected places. Branch ------ REL8_2_STABLE Details ------- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=1fa37ac25d6aa26443e47f96aafe87c3339ebc18 Modified Files -------------- src/backend/utils/adt/date.c | 33 +++++++++++++++++++++++++++++++++ src/backend/utils/adt/selfuncs.c | 3 +-- src/include/utils/date.h | 2 ++ 3 files changed, 36 insertions(+), 2 deletions(-)
В списке pgsql-committers по дате отправления: