Defect #19786
closed
'%' and '_' are treated as SQL wildcards in issue filter
Added by Go MAEDA over 9 years ago.
Updated about 3 years ago.
Description
Please see the following screenshot. "m_nag%r" matches "manager". Is this an expected behavior?
Files
- Related to Feature #13347: Filtering by issue subject with wildcard added
'%' works as wildcard for me, but '_' does not always work.
I was looking for the wildcard character and found your defect, please do not fix it :)
- Related to Feature #35073: Escape values in LIKE statements to prevent injection of placeholders (_ or %) added
- Status changed from New to Closed
- Resolution set to Fixed
Fixed by #35073.
In the upcoming Redmine 5.0, SQL wildcards will no longer be available, but multiple keywords AND search will be supported instead (#35764).
Also available in: Atom
PDF