pgsql: Resolve unknown-type literals in property expressions
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(-)