🐛 Bug: Getting undefined Bindings error when making a column primary key and adding data

nocodb / nocodb

🔥 🔥 🔥 Open Source Airtable Alternative

https://nocodb.com

GNU Affero General Public License v3.0

43.63k stars 3.03k forks source link

🐛 Bug: Getting undefined Bindings error when making a column primary key and adding data #4729

Open PrasanthKumar77 opened 1 year ago

PrasanthKumar77 commented 1 year ago

Please confirm if bug report does NOT exists already ?

[X] I confirm there is no existing issue for this

Steps to reproduce ?

create a table with defaults
add a new field with not null and primary key selected
add value in that row

Desired Behavior

values should be added properly

Project Details

Node: v16.17.1 Arch: x64 Platform: linux Docker: true Database: mysql2 ProjectOnRootDB: true RootDB: mysql2 PackageVersion: 0.100.2

Attachements

AlexandreBonneau commented 1 year ago

On my end I saw this bug too, but it's worse than it seems at first: 1/ You get the error message, and can imagine nothing has been saved 2/ Your row has been saved... 3/ ...but while you were typing the row has been saved multiple times, just with a slightly different value in the cell you were typing in

and lastly: 4/ The duplicated rows does not respect the primary key constraint since they are duplicated as well

see: