Budibase / budibase

Low code platform for building business apps and workflows in minutes. Supports PostgreSQL, MySQL, MariaDB, MSSQL, MongoDB, Rest API, Docker, K8s, and more 🚀
https://budibase.com
Other
21.92k stars 1.52k forks source link

Make sure nullable can be updated and then re-fetched #13886

Closed mike12345567 closed 3 months ago

mike12345567 commented 3 months ago

Description

There was an issue with the DB table fetching that meant that once some properties were fetched into Budibase they could never be updated and fetched from the database - fixing this and writing a test for it.

Also updated the test case to be a bit easier to use/look at.

Addresses: https://linear.app/budibase/issue/BUDI-8258/many-to-many-mysql-relationship-giving-erroneous-ensure-non-key https://github.com/Budibase/budibase/issues/13701

linear[bot] commented 3 months ago

BUDI-8258 Many-to-many MySQL relationship giving erroneous "Ensure non-key columns are nullable or auto-generated" error