Project:Teleport
Version:6.x-1.x-dev
Component:Code
Category:bug report
Priority:normal
Assigned:incidentist
Status:closed (fixed)

Issue Summary

I think the LOWER in the alias query buys us a little compared to the performance hit it costs (no index is used). The other LOWER instances are more valuable.

Comments

#1

Assigned to:Anonymous» incidentist

I turned "LOWER(dst)" into "dst" but kept the "LOWER('%%%s%%')". I think that removes the performance hit, since the alias index can be used, while still reducing capitalization issues.

#2

Status:active» fixed

#3

Status:fixed» closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.