From 72647ac3bf0f11732483eac2cd9b5cf4972f2e1f Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Mon, 28 Sep 2020 14:12:38 -0400 Subject: Assign collations in partition bound expressions. Failure to do this can result in errors during evaluation of the bound expression, as illustrated by the new regression test. Back-patch to v12 where the ability for partition bounds to be expressions was added. Discussion: https://postgr.es/m/CAJV4CdrZ5mKuaEsRSbLf2URQ3h6iMtKD=hik8MaF5WwdmC9uZw@mail.gmail.com --- src/backend/parser/parse_utilcmd.c | 1 + 1 file changed, 1 insertion(+) (limited to 'src/backend/parser/parse_utilcmd.c') diff --git a/src/backend/parser/parse_utilcmd.c b/src/backend/parser/parse_utilcmd.c index 6d2f36da2df..0dc03dd9840 100644 --- a/src/backend/parser/parse_utilcmd.c +++ b/src/backend/parser/parse_utilcmd.c @@ -4209,6 +4209,7 @@ transformPartitionBoundValue(ParseState *pstate, Node *val, */ if (!IsA(value, Const)) { + assign_expr_collations(pstate, value); value = (Node *) expression_planner((Expr *) value); value = (Node *) evaluate_expr((Expr *) value, colType, colTypmod, partCollation); -- cgit v1.2.3