Neither SHOW TABLES nor SHOW ALL TABLES show temporary views #7663
Description
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