0012760: Manage User page filter is case sensitive for some database backends - MantisBT

ID	Project	Category	View Status	Date Submitted	Last Update

0012760	mantisbt	administration	public	2011-02-10 10:52	2011-04-05 14:23

Reporter	schoppi71	Assigned To	dhx
Priority	normal	Severity	minor	Reproducibility	always
Status	closed	Resolution	fixed
Product Version	1.2.4
Target Version	1.2.5	Fixed in Version	1.2.5

Summary	0012760: Manage User page filter is case sensitive for some database backends
Description	Manage User page provides a filter for the first letter of the user name. This filter doesn't work if the database in casesensitive. SQL: SELECT * FROM mantis_user_table WHERE (username like 'A%') ORDER BY username ASC There should be an WHERE (UPPER(username) like 'A%') in the SQL script.
Tags	patch

MantisBT: master a3f376d1 2011-02-26 04:14 Schoppi Committer: dhx Details Diff	Fix 0012760: Case sensitivity of filter on manage user page The Manage User page provides a filter for the first letter of usernames. This filter doesn't work if the database is case sensitive. Signed-off-by: David Hicks <hickseydr@optusnet.com.au>	Affected Issues 0012760
	mod - manage_user_page.php	Diff File
MantisBT: master-1.2.x 5fc8d776 2011-02-26 04:14 Schoppi Committer: dhx Details Diff	Fix 0012760: Case sensitivity of filter on manage user page The Manage User page provides a filter for the first letter of usernames. This filter doesn't work if the database is case sensitive. Signed-off-by: David Hicks <hickseydr@optusnet.com.au>	Affected Issues 0012760
	mod - manage_user_page.php	Diff File

dhx 2011-02-26 04:20 reporter ~0028300	Thanks Andreas, I have committed your patch.