ducklake
ducklake copied to clipboard
PRAGMA table_info on VIEW returns 0 rows
Is PRAGMA table_info meant to work as it does in duckdb for views in ducklake?
create view db.main.myview as select 1;
D select * from db.main.myview;
┌───────┐
│ 1 │
│ int32 │
├───────┤
│ 1 │
└───────┘
D pragma table_info(db.main.myview);
┌───────┬─────────┬─────────┬─────────┬────────────┬─────────┐
│ cid │ name │ type │ notnull │ dflt_value │ pk │
│ int32 │ varchar │ varchar │ boolean │ varchar │ boolean │
├───────┴─────────┴─────────┴─────────┴────────────┴─────────┤
│ 0 rows │
└────────────────────────────────────────────────────────────┘
run on duckdb 1.3.1 with ducklake nightly on day of issue.