ducklake icon indicating copy to clipboard operation
ducklake copied to clipboard

PRAGMA table_info on VIEW returns 0 rows

Open ukclivecox opened this issue 6 months ago • 0 comments

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.

ukclivecox avatar Jun 28 '25 13:06 ukclivecox