pgsql: Resolve unknown-type literals in property expressions

Started by Peter Eisentraut5 months ago1 messagescommitters
Jump to latest
#1Peter Eisentraut
peter@eisentraut.org

Resolve unknown-type literals in property expressions

When a string literal is provided as a property expression, the data
type of the property was set to "unknown", which may lead to various
failures when the property is used in GRAPH_TABLE or when its data
type is compared against other properties with the same name. To fix
this, call resolveTargetListUnknowns() on the targetlist of new
properties being added to resolve unknown type literals.

Reported-by: Noah Misch <noah@leadboat.com>
Author: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Discussion: /messages/by-id/20260630173053.51.noahmisch@microsoft.com

Branch
------
REL_19_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/b820c623dd5090ef69b8b8151a0b152f5d976fed

Modified Files
--------------
src/backend/commands/propgraphcmds.c | 2 ++
.../regress/expected/create_property_graph.out | 37 +++++++++++++++++-----
src/test/regress/sql/create_property_graph.sql | 5 +++
3 files changed, 36 insertions(+), 8 deletions(-)