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

Constraints of local temporary tables aren't listed in INFORMATION_SCHEMA #3972

Closed
katzyn opened this issue Jan 20, 2024 · 0 comments · Fixed by #3974
Closed

Constraints of local temporary tables aren't listed in INFORMATION_SCHEMA #3972

katzyn opened this issue Jan 20, 2024 · 0 comments · Fixed by #3974

Comments

@katzyn
Copy link
Contributor

katzyn commented Jan 20, 2024

CREATE LOCAL TEMPORARY TABLE T1(ID BIGINT PRIMARY KEY);

SELECT TABLE_NAME, TABLE_TYPE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'PUBLIC';
> TABLE_NAME TABLE_TYPE
> ---------- ---------------
> T1         LOCAL TEMPORARY

SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS;
> No rows

SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE;
> No rows

SELECT TABLE_NAME, INDEX_TYPE_NAME FROM INFORMATION_SCHEMA.INDEXES;
> TABLE_NAME INDEX_TYPE_NAME
> ---------- ---------------
> T1         PRIMARY KEY
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant