🐛 Bug: Setting any incorrect column name, resulting in erroneous deletion of data

[starmisszhang]

Please confirm if bug report does NOT exists already ?

• I confirm there is no existing issue for this

Steps to reproduce ?

REST APIs
Bulk delete with conditions

There is a timestamp column in the database. When I tried conditional deletion, I accidentally entered the column name incorrectly, which caused the data to be accidentally deleted,

where=(111timestamp,eq,1694257034)
输入错误的列名为:111timestamp

Desired Behavior

This problem has brought a lot of troubles, and I hope to be able to handle it

Project Details

NocoDB used as docker : true

Attachments

[wingkwong]

similar to #6081 but in DELETE.

[dstala]

@pranavxc i believe we ignore incorrect filters with incorrect field name, leading to this behaviour. let us fix this to return error instead.