Export csv returns more than results equal to limit

[u12206050]

Describe the Bug

When exporting a large list with +10000 items, and applying a filter I see the results should be 6000, I then set the limit to 10000 (just in case) and export.

Since the list is so large it doesn't allow me to download directly so it gets stored in assets. Upon downloading the csv file I notice it is filled with 9999 results and not 6000.

Upon further investigation I find there are quite a number of duplicates present, and that it also happens without a filter.

To Reproduce

On a large set of items, select export and filter items the items to be less than all the items.

Set the limit to 2x what it says the number of results are.

Now download the file and check the amount of results. For the example above here is the amount of lines in the csv

Errors Shown

No response

What version of Directus are you using?

9.11.1

What version of Node.js are you using?

16.4.0

What database are you using?

mysql 8 and Postgres 13

What browser are you using?

edge

How are you deploying Directus?

Locally & GCP

[Jeyakumarrathnaselvi]

Yes i noticed the same issue recently