Open Bug 410115 Opened 18 years ago Updated 18 years ago

[PostgreSQL] Querying for a commenter is case-sensitive (make Search.pm case-insensitive)

Categories

(Bugzilla :: Query/Bug List, defect)

Product:
Bugzilla
Component:
Query/Bug List
Version:
3.0.2
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

()

People

(Reporter: LpSolit, Unassigned)

References

Details

I was looking for bugs where I wrote the word "Selenium" in a comment. Using boolean charts, I typed "commenter" "is equals to" "lpsolit@gmail.com" and got an empty list. Writing "LpSolit@gmail.com" instead returned the expected list with 46 bugs in it (not on b.m.o). Search.pm should be case-insensitive when talking about login names as we did in bug 285695 for other parts of the code.
For what it's worth, there theoretically is a solution for case-insensitive searching in general in PostgreSQL. You can create your own text types. There was a project that did this called "citext", but it doesn't exist anymore. The code still exists, but it only fixes "text" types, and we'd also need to fix varchar types.
You need to log in before you can comment on or make changes to this bug.