Skip to content
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

Postger copatibility - DBeaver schema query fails #2387

Open
ideoma opened this issue Aug 2, 2022 · 1 comment
Open

Postger copatibility - DBeaver schema query fails #2387

ideoma opened this issue Aug 2, 2022 · 1 comment
Labels
Compatibility Compatibility with third-party tools and services SQL Issues or changes relating to SQL execution

Comments

@ideoma
Copy link
Collaborator

ideoma commented Aug 2, 2022

Describe the bug

No response

To reproduce

SELECT t.oid,t.*,c.relkind,format_type(nullif(t.typbasetype, 0), t.typtypmod) as base_type_name, d.description
FROM pg_catalog.pg_type t
LEFT OUTER JOIN pg_catalog.pg_type et ON et.oid=t.typelem 
LEFT OUTER JOIN pg_catalog.pg_class c ON c.oid=t.typrelid
LEFT OUTER JOIN pg_catalog.pg_description d ON t.oid=d.objoid
WHERE t.typname IS NOT NULL
AND (c.relkind IS NULL OR c.relkind = 'c') AND (et.typcategory IS NULL OR et.typcategory <> 'C')

Expected Behavior

Should pass.

Fails with
Duplicate column [name=oid] and if t.oid removed fails with Invalid column: et.typcategory

Environment

- **QuestDB version**:6.4.3

Additional context

No response

@ideoma ideoma added SQL Issues or changes relating to SQL execution Compatibility Compatibility with third-party tools and services labels Aug 2, 2022
@ideoma
Copy link
Collaborator Author

ideoma commented Aug 2, 2022

Became a problem after #2093

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Compatibility Compatibility with third-party tools and services SQL Issues or changes relating to SQL execution
Projects
None yet
Development

No branches or pull requests

1 participant