Unable to view structure of Data Tables with uppercase character in the name (PostgreSQL DB)

[j-pillon]

Concerto Platform version

5.0.27

Expected behavior

View structure of Data Tables with PostgreSQL database.

Actual behavior

Unable to view the structure of Data Tables with an uppercase character in the name with PostgreSQL database.

Steps to reproduce the issue

1. Deployment with direct installation ("bare-metal")
   Environment :

• AlmaLinux 8.8
• Apache 2.4.37
• PHP-FPM 7.4.33
• R 4.3.1
• PostgreSQL 13.11

2. Import Concerto starter content

3. Connect and visit tab "Data Table", "Starter Content"

4. Edit Data Table with uppercase character (e.g. "translationDictionary", "assessmentItems", ...)

• DataTable Structure table is empty
• DataTable columnsCollectionAction route return an empty JSON
  http://<server>/admin/DataTable/<DataTable name>/columns/collection

5. Edit Data Table without uppercase character (e.g. "users", "sessions", ...)

• DataTable Structure table is filled
• DataTable columnsCollectionAction route return a filled JSON
  http://<server>/admin/DataTable/<DataTable name>/columns/collection

The problem come from character case of the DataTable identifier. The getListTableColumnsSQL function in Doctrine PostgreSqlPlatform class is case sensible.

Workaround

• Rename existing DataTable or name new DataTable with lowercase characters or snake_case.