Columns of type Ontology and Ontology_Array handle quotes differently

[hslh]

Have you checked if this issue already exists?

• yes

Molgenis EMX2 version

v11.40.2, v23

Description

Uploading data to the catalogue with values in triple double quotes, e.g. """Adult (18+ years)""" is fine for columns of type Ontology_Array, but fails for type Ontology, with error:

Import failed: Upsert into table 'Subpopulation counts' failed: Transaction failed: insert or update on table "Subpopulation counts" violates foreign key constraint "Subpopulation counts.age group REFERENCES Age groups". Details: Key (age group)=("Adult (18+ years)") is not present in table "Age groups".

Reproduction steps

1. Go to 'https://emx2.dev.molgenis.org/'
2. Create a schema with template 'DATA_CATALOGUE' with example data
3. Upload Subpopulations.csv (attached) to that schema, see that it imports successfully even though it contains the value """Adult (18+ years)""" for column 'age group' of type Ontology_Array
   Subpopulations.csv
4. Upload Subpopulation counts.csv (attached) to the same schema, see that the import fails on the value """Adult (18+ years)""" for column 'age group' of type Ontology
   Subpopulation counts.csv

Expected behaviour

I expect the upload to succeed in both cases, or at least behave in the same way in both cases.

System configuration

MacOS Sequoia, Firefox v133