sql: pg_function_is_visible fails for UDFs #94953
Description
Found while working on #88061.
Describe the problem
pg_function_is_visible() fails for the OID of UDFs.
To Reproduce
> CREATE FUNCTION myfunc(val INT) RETURNS INT CALLED ON NULL INPUT LANGUAGE SQL AS $$ SELECT val $$;
> select pg_function_is_visible(oid) from pg_proc where proname='myfunc';
ERROR: function 100105 does not exist: function undefined
SQLSTATE: 42883Expected behavior
All the OID values in pg_proc are valid inputs to pg_function_is_visible.
cc @rafiss @mgartner @chengxiong-ruan for triage.
Jira issue: CRDB-23241
Epic: CRDB-23454
Metadata
Metadata
Assignees
Labels
Related to the schema descriptors collection and the catalog API in general.Semantic compatibility with PostgreSQLUDFs and Stored ProceduresVirtual tables - pg_catalog, information_schema etcCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.SQL Foundations Team (formerly SQL Schema + SQL Sessions)