Hi,
Baserow 1.33.4.
I tried to use the update feature via CSV file import and found a few unexpected results:
If the imported table does not include all the columns in the target table in baserow the values missing from the imported CSV are just deleted in the baserow table.
this seems a bit related to:
This does show up in the import preview - but is barely visible for larger tables, so will often lead to data loss in practice.
A similar data loss happens for values in single and multi select columns, which are not present in the baserow table. In other words - new select options are not added on import/upsert and there is no information presented to the user that the values were not imported. Even worse - legitimate values for those items are deleted from baserow if there are any for the affected rows/columns.
Additionally:
A few members of my team reported that they encountered a case where the updated rows were just deleted from the baserow table entirely. I have not been able to reproduce this with a sample table I can share, though.