Details
-
Bug
-
Resolution: Unresolved
-
Low
-
None
-
7.13.6
-
7.13
-
3
-
Severity 3 - Minor
-
Description
Issue Summary
If the lower_user_name is changed to only numeric value, JQL query with WAS operator doesn't return expected results
Environment
7.13.6
Steps to Reproduce
- Create a user with numeric only username or Rename a user from text to numeric viz., abrajtxhd to 45671234
- Assign some issue(s) to 45671234
- Run assignee was 43387518
select * from app_user where lower_user_name like '%45671234%' or user_key like '%45671234%';
id | user_key | lower_user_name |
---|---|---|
10382 | abrajtxhd | 45671234 |
Expected Results
JQL filter returns current and old issues with assignee 43387518
Actual Results
Workaround
The workaround is to use double-quote or single quote around the numeric username to get the expected results: