**Describe the bug**
Dropping an UNLOGGED table does not delete the BATs associated with that table, neither from the BBP.dir file, nor from the file system.

**To Reproduce**
CREATE UNLOGGED TABLE foo (x int);
INSERT INTO foo VALUES (1);
SELECT * FROM sys.storage('sys','foo'); -- so we can see which BATs we're talking about
DROP TABLE foo;

Then wait for WAL rotation and check the BBP.dir file for the BAT reported by sys.storage.

**Expected behavior**
The BATs should be removed.

**Screenshots**
If applicable, add screenshots to help explain your problem.

**Software versions**
Dec2023-SP3

UNLOGGED tables don't get cleaned up properly when DROPped.
This is a GitHub Issue
repo:MonetDB
owner:MonetDB
Title : UNLOGGED tables don't get cleaned up properly when DROPped.
Issue date:

--- start body ---
**Describe the bug**
Dropping an UNLOGGED table does not delete the BATs associated with that table, neither from the BBP.dir file, nor from the file system.

**To Reproduce**
CREATE UNLOGGED TABLE foo (x int);
INSERT INTO foo VALUES (1);
SELECT * FROM sys.storage('sys','foo'); -- so we can see which BATs we're talking about
DROP TABLE foo;

Then wait for WAL rotation and check the BBP.dir file for the BAT reported by sys.storage.

**Expected behavior**
The BATs should be removed.

**Screenshots**
If applicable, add screenshots to help explain your problem.

**Software versions**
Dec2023-SP3

--- end body ---
