drop tables doesn't delete native table files.

[universalmind303]

Description

files are not dropped when tables are dropped.
likely related to #1855

> \open ./db
> create table t1 (a int, b int);
try_insert_table_namespace
Table created
> insert into t1 values (1, 2);
Inserted 1 row
> select * from t1;
┌───────┬───────┐
│     a │     b │
│    ── │    ── │
│ Int32 │ Int32 │
╞═══════╪═══════╡
│     1 │     2 │
└───────┴───────┘
> drop table t1;
Table(s) dropped
> Ctrl+D
glaredb  ❯ ls db/databases/00000000-0000-0000-0000-000000000000/tables/                                                                                                                       10/02/2023 04:14:11 PM
╭───┬────────────────────────────────────────────────────────────────┬──────┬───────┬──────────────╮
│ # │                              name                              │ type │ size  │   modified   │
├───┼────────────────────────────────────────────────────────────────┼──────┼───────┼──────────────┤
│ 0 │ db/databases/00000000-0000-0000-0000-000000000000/tables/20000 │ dir  │ 128 B │ a minute ago │
╰───┴────────────────────────────────────────────────────────────────┴──────┴───────┴──────────────╯

[scsmithr]

Is there anything inside that directory? We have #1411 open for not deleting the directory itself though (only for local, s3/gcs work as expected I believe).

[universalmind303]

it doesn't delete any of the files