Alias field only displays up to QUERY_LIMIT_DEFAULT many items

[holyris]

Describe the Bug

When saving an item as a copy, only 100 items of each relations are duplicated

To Reproduce

https://github.com/holyris/directus-copy-limit-bug
Everything is described in readme

Errors Shown

Nothing

What version of Directus are you using?

9.21.2

What version of Node.js are you using?

16.18.1

What database are you using?

postgres

What browser are you using?

Firefox

How are you deploying Directus?

docker-compose

[rijkvanzanten]

Linear: ENG-115

[DanielBiegler]

Note to future reader: The structure of the schema for a minimal example is

posts:
  - id
  - comments (o2m to comments)

comments:
  - id
  - post (m2o to posts)

And now if you have over 100 comments pointing to a post, the o2m field in said post will only show 100 comments.

---

I can confirm that on v10.6.2 we're only showing 100 items in the aliased o2m field, looking at the raw value I see the IDs up to 100 instead of 124:

[
    <! -- ... omitted ... -->
    98,
    99,
    100
]

Also second note just for documentation purpose: The hundred item limit might be related to the env-variable QUERY_LIMIT_DEFAULT see docs