8000 Neither SHOW TABLES nor SHOW ALL TABLES show temporary views · Issue #7663 · duckdb/duckdb · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

Neither SHOW TABLES nor SHOW ALL TABLES show temporary views #7663

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.

Sign up for GitHub

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

Jump to bottom
Closed
2 tasks done
Mytherin opened this issue May 24, 2023 · 0 comments · Fixed by #7680
Closed
2 tasks done

Neither SHOW TABLES nor SHOW ALL TABLES show temporary views #7663

Mytherin opened this issue May 24, 2023 · 0 comments · Fixed by #7680

Comments

@Mytherin
Copy link
Collaborator

What happens?

We made some changes to SHOW TABLES/SHOW ALL TABLES, and it seems those have caused the schema search path to no longer be correctly respected.

To Reproduce

D create temporary view v1 as select 42;
D show tables;
┌─────────┐
│  name   │
│ varchar │
├─────────┤
│ 0 rows  │
└─────────┘
D show all tables;
┌──────────┬─────────┬────────────┬──────────────┬──────────────┬───────────┐
│ database │ schema  │ table_name │ column_names │ column_types │ temporary │
│ varchar  │ varchar │  varchar   │  varchar[]   │  varchar[]   │  boolean  │
├───────────────────────────────────────────────────────────────────────────┤
│                                  0 rows                                   │
└───────────────────────────────────────────────────────────────────────────┘

OS:

MacOS

DuckDB Version:

latest

DuckDB Client:

CLI

Full Name:

Mark Raasveldt

Affiliation:

DuckDB Labs

Have you tried this on the latest master branch?

  • I agree

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

  • I agree
Mytherin added a commit to Mytherin/duckdb that referenced this issue May 25, 2023
@Mytherin
Fix duckdb#7663 - add in_search_path function, and correctly show tem…
9cfe05d 
…porary tables and others in SHOW TABLES and SHOW ALL TABLES
@Mytherin Mytherin added the ODBC label May 25, 2023
@Mytherin Mytherin mentioned this issue May 25, 2023
Merged
Mytherin added a commit that referenced this issue May 27, 2023
@Mytherin
Merge pull request #7680 from Mytherin/showtables
9e89e66 
Fix #7663 - add in_search_path function, correctly show temporary views in SHOW TABLES, and show views in SHOW ALL TABLES
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
1 participant
@Mytherin
0