Project

General

Profile

Actions

Defect #27122

closed

Filter for version name should be case-insensitive

Added by Nastya Fedorova about 7 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Project settings
Target version:
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Fixed
Affected version:

Description

Search for version name does not work for case sensitive names


Files

Actions #1

Updated by Anonymous about 7 years ago

  • File photo_2017-09-01_22-08-39.jpg added
Actions #2

Updated by Holger Just about 7 years ago

There is a database-agnostic helper method for a case-insensititive LIKE. You should be able to just use this:

where([Redmine::Database.like("Version.table_name}.name", '?'), pattern])

MySQL is case-insensitive by default. Searching on Postgres should work with this method. As for the other supported databases: I'm not fully sure whether they do the right thing there. If they don't show the correct behavior then the Redmine::Database.like method should be fixed.

Actions #3

Updated by Mischa The Evil about 7 years ago

  • File deleted (photo_2017-09-01_22-08-39.jpg)
Actions #4

Updated by Toshi MARUYAMA about 7 years ago

  • Category changed from Search engine to Roadmap
  • Target version set to 4.1.0
Actions #5

Updated by Mizuki ISHIKAWA over 6 years ago

Attach the patch that added the test to the code written by Holger Just ( #27122#note-2 ).

Actions #8

Updated by Go MAEDA over 6 years ago

  • Tracker changed from Patch to Defect
  • Subject changed from Case insensitive filter for version name to Filter for version name should be case-insensitive
  • Category changed from Roadmap to Project settings
  • Target version changed from 4.1.0 to 3.4.6

This is a defect rather than a feature. I am setting target version to 3.4.6.

Actions #9

Updated by Go MAEDA over 6 years ago

  • Status changed from New to Resolved
  • Assignee set to Go MAEDA
Actions #10

Updated by Go MAEDA over 6 years ago

  • Status changed from Resolved to Closed
  • Resolution set to Fixed

Committed. Thank you all for detecting and fixing this issue.

Actions

Also available in: Atom PDF