[BUDI-7552] CSV import messes up auto generated Auto ID column.

[ConorWebb96]

Checklist

• I have searched budibase discussions and github issues to check if my issue already exists

Hosting

• Self
  • Method: docker compose
  • Budibase Version: 2.10.10
  • App Version: 2.10.10

Describe the bug
When importing a CSV that has an Auto ID column into an internal Budibase table with a auto generated Auto ID column. The columns don't have awareness of what the last Auto ID is.

For example if i imported a CSV into a new table were there hasn't been any rows created. The next manually created rows Auto ID would be 1 instead of continuing from wherever the import CSV rows left off.

To Reproduce
Steps to reproduce the behavior:

1. Create a Budibase internal db data source.
2. Create relevant columns related to the CSV below
3. Import CSV attached below
4. Add another row after CSV import
5. See issue with Auto ID columns.

Expected behavior
If a CSV includes an Auto ID column, it should then generate any new manually created rows + 1 of the last row. For example if the CSV imports 6 rows with related Auto Ids that add to 6, when creating the next row manually it should become 7.

Screenshots

CSV Export
export.csv

_BUDI-7553