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
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/57f93af36f02a2559b005491d9fb0da660e32850

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(-)