Bug #1127
Usernames are case sensitive in SQLite
| Status: | Closed | Start date: | 08/01/2010 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: | Tom Moore | % Done: | 100% |
|
| Category: | SQLite | |||
| Target version: | 1.6.1 | |||
| Reproducibility: | Always | Database Type: | SQLite | |
| Reported In MyBB Version: | 1.6.0 | Database Version: | 3.6.20 | |
| PHP Version: | SQA assignments: | |||
| Browser: |
Description
Usernames are case sensitive in SQLite. This is a bug in my view, as when you login on a MySQL based installation, you can type in your name in all lowercases. It's more of a consistency issue than anything else.
Associated revisions
Fixes Usernames are case sensitive in SQLite (fixes:1127)
Fixes Usernames are case sensitive in SQLite (fixes:1127)
History
#1 Updated by Tom Moore over 1 year ago
- Status changed from New to Assigned
- Assignee set to Tom Moore
- Target version set to 1.6.1
Preparing patch.
#2 Updated by Tom Moore over 1 year ago
- Status changed from Assigned to Resolved
- % Done changed from 0 to 100
Applied in changeset r5211.
#3 Updated by Ryan Gordon over 1 year ago
We can make this consistent by just using LOWER on all DBMS
#4 Updated by Tom Moore over 1 year ago
- Status changed from Resolved to Feedback
Hmm, I didn't want to disrupt the other DBMS as they don't have any issues. But no problem.
Preparing patch.
#5 Updated by Ryan Gordon over 1 year ago
That doesn't make sense though, MySQL should be behaving the same way (case-sensitive) without the LOWER
#6 Updated by Tom Moore over 1 year ago
Of course it does, but I just wanted to separate SQLite as only it had the problem. I really don't mind doing it for all 3.
#7 Updated by Tom Moore over 1 year ago
- Status changed from Feedback to Resolved
Applied in changeset r5218.
#8 Updated by Stefan T. over 1 year ago
- Status changed from Resolved to Closed