Project

General

Profile

Actions
Copy link

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.

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

0%

Estimated time:
Resolution:
Fixed
Affected version:
3.0.2

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
Copy link
 #2

Updated by Go MAEDA over 5 years ago

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

Updated by Stéphane Frath over 5 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
Copy link
 #4

Updated by Go MAEDA over 3 years ago

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

Updated by Go MAEDA about 3 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
Copy link

Also available in: Atom PDF