Values with trailing whitespace

[will-moore]

Searching for Genes with trailing whitespace found a single value:

[wmoore@prod111-omeroreadwrite ~]$ /opt/omero/server/OMERO.server/bin/omero hql "select mv.value from MapAnnotation m join m.mapValue as mv where mv.value like '% ' and m.ns='openmicroscopy.org/mapr/gene'"
 # | Col1   
---+--------
 0 | KRT19  
(1 row)

This is the only study (idr0114) where this value contains whitespace.

https://idr.openmicroscopy.org/search/?key=Gene+Symbol&value=krt19&operator=contains

Checking map values for 1 of the 5 images, shows the same issue for "Antibody": "CK19 "
https://idr.openmicroscopy.org/webclient/api/annotations/?type=map&image=13461960

This is also the only value found with trailing whitespace for Antibody:

[wmoore@prod111-omeroreadwrite ~]$ /opt/omero/server/OMERO.server/bin/omero hql "select mv.value from MapAnnotation m join m.mapValue as mv where mv.value like '% ' and m.ns='openmicroscopy.org/mapr/antibody'"
Using session for demo@localhost:4064. Idle timeout: 10 min. Current group: Public
 # | Col1  
---+-------
 0 | CK19  
(1 row)