Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Ensure non-key columns are nullable or auto-generated error (reoccurance) #15270

Open
qa-wolf bot opened this issue Dec 31, 2024 · 1 comment
Open

Ensure non-key columns are nullable or auto-generated error (reoccurance) #15270

qa-wolf bot opened this issue Dec 31, 2024 · 1 comment
Labels
bug Something isn't working

Comments

@qa-wolf
Copy link

qa-wolf bot commented Dec 31, 2024

Steps to reproduce:

  1. Log into budibase
  2. Create a new app
  3. Create a table for the app
  4. Connect to MySQL
  5. Bring in your tables from MySQL
  6. Go to define relationships
  7. When inputted the following information into the table observe "Ensure non-key columns are nullable or auto-generated error"
  • Many rows in departments
  • Too many rows in employees
  • Through: dept_emp
  • Foreign Key (departments): dept_no
  • Foreign Key (employees): emp_no
    Expected: Able to define relationships successfully.
    Actual: Unable to define relationships and receive "Ensure non-key columns are nullable or auto-generated error"

Video (https://www.loom.com/share/ef773b799b12455c950928f89ccd2a77?sid=e9cfaa09-dcfe-4a79-8182-3dd5b95b02a9)

@qa-wolf qa-wolf bot added the bug Something isn't working label Dec 31, 2024
Copy link

linear bot commented Dec 31, 2024

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

0 participants