-
Type: Bug Report
-
Status: Closed
-
Priority: Minor
-
Resolution: no change required
-
Affects Version/s: 5.0.0
-
Fix Version/s: 5.0.2
-
Component/s: Optimization
-
Labels:None
-
External issue URL:
-
External issue ID:246
-
Copy Issue Key:
-
Patch Instructions:
We have index on Phrase column, which is good. Phrases are loaded using this database query:
SELECT PhraseId, Translation
FROM Phrase
WHERE (LanguageId = 1) AND (UPPER(Phrase) = 'lu_SamplePhrase')
In mentioned above query phrase column value is uppercased and then compared to phrase name to be loaded. In this case, according to MySQL documentation, index is not used.
- child of
-
INP-263 Add Case-Insensitive Field to Phrases table for storing Labels
- Closed