-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql: pg_type_is_visible does not handle user-defined types #60008
Copy link
Copy link
Closed
Labels
A-sql-builtinsSQL built-in functions and semantics thereof.SQL built-in functions and semantics thereof.A-sql-datatypesSQL column types usable in table descriptors.SQL column types usable in table descriptors.A-tools-sqlalchemyC-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.S-3-wrong-metadataIssues causing erroneous metadata or monitoring stats to be returned.Issues causing erroneous metadata or monitoring stats to be returned.
Description
The following should return true, but it returns null.
root@:26257/defaultdb> create type mood as enum('Sad', 'Okk', 'Happy');
CREATE TYPE
root@:26257/defaultdb> select pg_type_is_visible(t.oid) from pg_type t where t.typname = 'mood';
pg_type_is_visible
----------------------
NULL
the pg_type_is_visible only checks for the hardcoded list of builtin types.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
A-sql-builtinsSQL built-in functions and semantics thereof.SQL built-in functions and semantics thereof.A-sql-datatypesSQL column types usable in table descriptors.SQL column types usable in table descriptors.A-tools-sqlalchemyC-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.S-3-wrong-metadataIssues causing erroneous metadata or monitoring stats to be returned.Issues causing erroneous metadata or monitoring stats to be returned.