Corresponding Field is not working for system collections "directus_files"

[ncxx23]

Describe the Bug

I try to create "Multiple Files" relation field and set up corresponding field (m2m) in directus_files collection

This field is created but if you open that corresponding field you see it is don't have any relations and look corrupted.
and after this moment any action with directus_files causes an error, and the current files are no longer available (they visible but show error when you click on it)

To Reproduce

Create "Multiple files" field with corresponding m2m field.

Errors Shown

{
  "errors": [
    {
      "message": "select \"directus_files\".\"id\", \"directus_files\".\"storage\", \"directus_files\".\"filename_disk\", \"directus_files\".\"filename_download\", \"directus_files\".\"title\", \"directus_files\".\"type\", \"directus_files\".\"folder\", \"directus_files\".\"uploaded_by\", \"directus_files\".\"uploaded_on\", \"directus_files\".\"modified_by\", \"directus_files\".\"modified_on\", \"directus_files\".\"charset\", \"directus_files\".\"filesize\", \"directus_files\".\"width\", \"directus_files\".\"height\", \"directus_files\".\"duration\", \"directus_files\".\"embed\", \"directus_files\".\"description\", \"directus_files\".\"location\", \"directus_files\".\"tags\", \"directus_files\".\"metadata\", \"directus_files\".\"candidates_test\" from \"directus_files\" where \"directus_files\".\"id\" = $1 order by \"directus_files\".\"id\" asc limit $2 - column directus_files.candidates_test does not exist",
      "extensions": {
        "code": "INTERNAL_SERVER_ERROR"
      }
    }
  ]
}

What version of Directus are you using?

9.22.4

What version of Node.js are you using?

18.13.0

What database are you using?

Postgres: 15.1

What browser are you using?

Crome

How are you deploying Directus?

Docker

[github-actions]

Linear: ENG-627

[ponanin]

I can confirm, reproduced, version 9.22.3 in Docker

[ncxx23]

Do you have permissions configured so that you can't edit the directus_files collection or something similar?

Yeah, I have full permissions (admin role), I can create fields in system collections.
Creating the "Multiple Files" field does not even offer a choice of collection, it automatically creates a link to that system collection "directus_files"
I tried to reproduce this bug on 3 different directus instances - it reproduces everywhere.

Screen.Recording.2023-02-03.mov

[Nitwel]

Yea, I overlooked that you wrote that the error occurs when interacting with it. I read it as it would error on creating. 👍