Tracker: Bugs

5 email addresses should be case-insensitive - ID: 1655608
Last Update: Settings changed ( sits )

Looking at "Topic Information" for metrics, I noticed that I get two entries for the same e-mail address. Here is an example:

User Codestriker Time
bogusmagee@my.company.com 60
kilroy@my.company.com 5
kilroy@My.Company.com 5
(unknown user) 36
106 106

The total includes both entries of 5 minutes. Did kilroy actually spend 10 minutes looking at the review? Or, did he spend 5 minutes that is being reported twice?

Since the case of e-mail addresses is irrelevant, both in the username and the domain, I think the correct approach would be to store the e-mail address in the database as all lowercase.

Reproduce:
Add a user as a reviewer using a mixed-case version of the username or domain. Then, browse the topic from a browser where the user's e-mail is a all-lowercase version of the same address. You should see two different entries in the metrics.

David Carson ( dccarson ) - 2007-02-08 14:36:57 PST

5

Closed

Fixed

Nobody/Anonymous

None

None

Public


Comments ( 3 )

Date: 2007-08-17 21:34:51 PDT
Sender: sitsProject Admin


As far as I can see - the search of email addresses is already
case-insensitive, so I am closing this off.

Can you give a specific example where it wasn't working? Perhaps you
needed to add wildcards to your query?

In my experiments, the searches were case insensitive.

If it is not working for you, what database are you using?

Date: 2007-08-17 21:22:07 PDT
Sender: sitsProject Admin


I believe the metrics issue is fixed now and committed to CVS.

Date: 2007-08-15 10:50:37 PDT
Sender: dccarson


The case-sensitivity of usernames also causes a problem when using the
search facility. If I want to search for all topics authored by kilroy, I
don't want to have to know what case was used by the author when he created
the topic.

Attached File

No Files Currently Attached

Changes ( 3 )

Field Old Value Date By
resolution_id None 2007-08-17 21:43:01 PDT sits
status_id Open 2007-08-17 21:34:51 PDT sits
close_date - 2007-08-17 21:34:51 PDT sits