In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!

Dependency Graph

[ View Issue ] [ Relation Graph ] [ Vertical ]

Viewing Issue Simple Details
ID	Category	Type	Reproducibility	Date Submitted	Last Update
0000246	[In-Portal CMS] Optimization	bug report	always	2009-08-26 04:06	2009-09-23 12:25

Reporter	alex	View Status	public
Assigned To	alex
Priority	normal	Resolution	fixed
Status	closed

Summary	0000246: Database index not used, when quering phrases by name
Description	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.
Additional Information