search

nocodb / nocodb

🔥 🔥 🔥 Open Source Airtable Alternative
https://nocodb.com
GNU Affero General Public License v3.0
49.54k stars 3.38k forks source link

🐛 Bug: external db- cascade on delete & links with composite pk #9583

Open dstala opened 1 month ago

dstala commented 1 month ago

Please confirm that the bug report does not already exist

Steps to reproduce

Screenshot 2024-10-03 at 9 45 14 AM

Desired Behavior

no error

Project Details

255.2

Attachments

No response

woodmin commented 1 month ago

I just encountered more issues with this (2nd) bug: it appears I tried to create links between tables with composite keys 3 times and it seemed it failed. But it actually created 3 columns in one of the tables, that I noticed right now. They show up as uidt:foregnKey columns, and are impossible to delete. When I try to delete I get 'Support for foreign keys not implemented' error. Also there is are junction tables created for each of the columns (typical NCDB format nc_clz____nc_m2m_ddg7a7ehtu or similar), but they are empty.