Skip to content

bug: missing typinput in pg_catalog.pg_type #11689

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
Tracked by #10347 ...
fuyufjh opened this issue Aug 15, 2023 · 1 comment · Fixed by #12272
Closed
Tracked by #10347 ...

bug: missing typinput in pg_catalog.pg_type #11689

fuyufjh opened this issue Aug 15, 2023 · 1 comment · Fixed by #12272
Labels
type/bug Something isn't working
Milestone

Comments

@fuyufjh
Copy link
Collaborator

fuyufjh commented Aug 15, 2023

Describe the bug

The following query was sent by DataGrip:

SELECT
    typinput = 'pg_catalog.array_in' :: regproc AS is_array,
    typtype,
    typname,
    pg_type.oid
FROM
    pg_catalog.pg_type
    LEFT JOIN (
        SELECT
            ns.oid AS nspoid,
            ns.nspname,
            r.r
        FROM
            pg_namespace AS ns
            JOIN (
                SELECT
                    s.r,
                    (current_schemas(false)) [s.r] AS nspname
                FROM
                    generate_series(1, array_upper(current_schemas(false), 1)) AS s(r)
            ) AS r USING (nspname)
    ) AS sp ON sp.nspoid = typnamespace
WHERE
    pg_type.oid = 1
ORDER BY
    sp.r,
    pg_type.oid DESC

Error message/log

ERROR:  QueryError: Bind error: failed to bind expression: typinput = CAST('pg_catalog.array_in' AS regproc)

Caused by:
  Item not found: Invalid column: typinput

To Reproduce

No response

Expected behavior

No response

How did you deploy RisingWave?

No response

The version of RisingWave

No response

Additional context

https://www.postgresql.org/docs/current/catalog-pg-type.html

@fuyufjh fuyufjh added the type/bug Something isn't working label Aug 15, 2023
@github-actions github-actions bot added this to the release-1.2 milestone Aug 15, 2023
@neverchanje
Copy link
Contributor

Metabase issues basically the same query to retrieve interval and jsonb data.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants