🐛 Bug: Many-to-many relationships are not deleted when deleting a record

[jd7h]

Please confirm if bug report does NOT exist already ?

• I confirm there is no existing issue for this

Steps to reproduce ?

1. Create a record with a many-to-many relationship
2. Delete the record
3. Create a new record. This new record will have the same id as the record we just deleted. The new record will have the same many-to-many relationship as the old, deleted record with the same id.

Desired Behavior

The many-to-many relationships of a record should also be deleted when we delete the record.

Project Details

Node: v20.11.1
Arch: x64
Platform: linux
Docker: true
RootDB: sqlite3
PackageVersion: 0.205.1

Attachments

Creating a record:

Deleting the record via the UI:

Creating a new record with the same ID:

New record has the same many-to-many relationships as the old deleted record:

[dstala]

issue noticed with sqlite root-db. no seen with pg as root db

[yorickvP]

sqlite3 needs PRAGMA foreign_keys=on; after every database open for foreign key constraints / ON DELETE CASCADE to work. Maybe that would help?