Problem with links when deleting

Grid-View
1

Hello! Iā€™m facing this problem. In a table there is a field link to another table in M2M format. After deleting a record in the table and then adding a new one, the links that were in the deleted record reappear in the new one. Thus it turns out that to delete a record in the table correctly, you must first delete all the links in this record and only then delete the record. This problem occurs exactly with M2M links, with all other links it is normal. It is very inconvenient. Is this really how it should work? I have recorded a video, but unfortunately I cannot attach it.

2

Can you share your base information? Are you trying it in Cloud or self hosted environment?

3

Good day. Self hosted.

4

Copy your base information here. FAQs | NocoDB

5

I tried it in app.nocodb.com (uses PG), it worked fine. Just wondering if its something to do with other NC_DB options (MySQL or SQLite)

6

Reproducible with SQLite as root DB. Created an issue here

7

Node: v20.15.1
Arch: x64
Platform: linux
Docker: true
RootDB: sqlite3
PackageVersion: 0.257.2

8

Thank you. Can you tell me then how can I change the root db in my self host solution

9