Synchronize stereotype bug when name contains a single quote

[Guillaume]

Hi,

I have an MDG with a stereotype which name contains a single quote e.g. "that's my test"
Having updated the tagged values definition, I made an attempt to synchronize it both from a script (Repository.CustomCommand("Repository", "SynchProfile", ...), or manually using the toolbox (right click > sync stereotype).
The query sent by EA doesn't handle single quote and generates an error message. I found the following query from the DBError file:
Select Object_ID, Description from (t_xref inner join t_object on t_xref.Client = t_object.ea_guid) where (t_xref.Name = 'Stereotypes') and (t_object.Object_Type <> 'Package') and (t_xref.Description LIKE '%Name=that's my test;%')

It would work if the single quote would be escaped by doubling it e.g.
Select Object_ID, Description from (t_xref inner join t_object on t_xref.Client = t_object.ea_guid) where (t_xref.Name = 'Stereotypes') and (t_object.Object_Type <> 'Package') and (t_xref.Description LIKE '%Name=that''s my test;%')

[Geert Bellekens]

Hi Guillaume,

Probably not the best idea to have single quotes in your taggged value names.
I can imagine wreaking havoc in other places as well.

If I was you I would change the tagged value name to avoid the single quotes.

Geert

[Guillaume]

Hi Geert,

The single quote is used in the stereotype name but I will indeed consider with my client removing it, especially as we can maintain it in the metatype.
However I think it should be fixed in EA.

Thanks

[Geert Bellekens]

However I think it should be fixed in EA.

You are absolutely right about that. It's a bug and should be fixed.

Geert