]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Fix collation of expressions in GRAPH_TABLE COLUMNS clause
authorPeter Eisentraut <peter@eisentraut.org>
Fri, 24 Apr 2026 06:43:26 +0000 (08:43 +0200)
committerPeter Eisentraut <peter@eisentraut.org>
Fri, 24 Apr 2026 06:43:26 +0000 (08:43 +0200)
commitac3bcc041c5cc2b7ce522d4ce6e6c4653f1263ea
tree8a6a1290ffe6467368b0971c1abed54fb365ad57
parent9082680c34e987d51f84c217e1dbd140d4a4517b
Fix collation of expressions in GRAPH_TABLE COLUMNS clause

GRAPH_TABLE clause is converted into a rangetable entry, which is
ignored by assign_query_collations().  Hence we assign collations
while transforming its parts.  But expressions in COLUMNS clause
missed that treatment, so fix that.

While at it, also add comments about collation assignment to the parts
of GRAPH_TABLE clause, and also fix a small grammar issue.

Reported-by: Satyanarayana Narlapuram <satyanarlapuram@gmail.com>
Author: Satyanarayana Narlapuram <satyanarlapuram@gmail.com>
Author: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Discussion: https://www.postgresql.org/message-id/CAHg+QDc4aaiufYSgrwMMPMMRTPtQ66SghcrPFbWJFZMqNaG+BA@mail.gmail.com
src/backend/parser/parse_clause.c
src/backend/parser/parse_graphtable.c
src/test/regress/expected/graph_table.out
src/test/regress/sql/graph_table.sql