Make tag upgrade procedure for MySQL case insensitive
-----------------------------------------------------
Key: NXP-6802
URL: https://jira.nuxeo.com/browse/NXP-6802
Project: Nuxeo Enterprise Platform
Issue Type: Bug
Components: Core SQL Storage, Tagging
Affects Versions: 5.4.1
Environment: MySQL
Reporter: Thierry Martins
Priority: Major
Fix For: 5.4.2
The procedure to upgrade existing tags checks if the old tag service was
already used with the query
{code:sql}SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME =
'NXP_TAGGING' AND TABLE_SCHEMA = SCHEMA();{code}
But we don't know if tables will be created with lower or upper case. Therefore
we need to use a LIKE clause in the query:
{code:sql}SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE
'NXP_TAGGING' AND TABLE_SCHEMA = SCHEMA();{code}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
