Project

General

Profile

Actions

Defect #19786

closed

'%' and '_' are treated as SQL wildcards in issue filter

Added by Go MAEDA almost 9 years ago. Updated over 2 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Issues
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Fixed
Affected version:

Description

Please see the following screenshot. "m_nag%r" matches "manager". Is this an expected behavior?


Files

issue-filter-screenshot.png (55.2 KB) issue-filter-screenshot.png Go MAEDA, 2015-05-08 06:30

Related issues

Related to Redmine - Feature #13347: Filtering by issue subject with wildcardNew

Actions
Related to Redmine - Feature #35073: Escape values in LIKE statements to prevent injection of placeholders (_ or %)ClosedMarius BĂLTEANU

Actions
Actions #2

Updated by Go MAEDA over 4 years ago

  • Related to Feature #13347: Filtering by issue subject with wildcard added
Actions #3

Updated by Stéphane Frath over 4 years ago

'%' 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 :)

Actions #4

Updated by Go MAEDA almost 3 years ago

  • Related to Feature #35073: Escape values in LIKE statements to prevent injection of placeholders (_ or %) added
Actions #5

Updated by Go MAEDA over 2 years ago

  • 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).

Actions

Also available in: Atom PDF