Defect #25867

Assignable users should respect database collation

Added by Pavel Rosický about 2 years ago. Updated 8 months ago.

Status:NewStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Database
Target version:Candidate for next major release
Resolution: Affected version:

Description

mysql collation: utf8_general_ci
['a','u','č'] should be sorted as ['a','č','u'] but because of ruby sort it's reordered back as ['a','u','č']

  def assignable_users
    users = project.assignable_users(tracker).to_a
    users << author if author && author.active?
    if assigned_to_id_was.present? && assignee = Principal.find_by_id(assigned_to_id_was)
      users << assignee
    end

    users.uniq.sort
  end

I can provide a patch, are you interested or is it desired behaviour?

Environment (not important, all redmine versions and databases are affected):
  Redmine version                3.3.3.devel.16557
  Ruby version                   2.1.5-p273 (2014-11-13) [x64-mingw32]
  Rails version                  4.2.8
  Environment                    production
  Database adapter               Mysql2
SCM:
  Subversion                     1.9.5
  Git                            2.11.0
  Filesystem
Redmine plugins:
  no plugin installed

issue_test.rb.patch Magnifier (883 Bytes) Pavel Rosický, 2017-05-18 21:57

issue.rb.patch Magnifier (1.16 KB) Pavel Rosický, 2017-05-18 21:57

History

#1 Updated by Pavel Rosický about 2 years ago

#2 Updated by Pavel Rosický 12 months ago

It's been a year and the problem is still reproducible.

#3 Updated by Go MAEDA 8 months ago

  • Target version set to Candidate for next major release

Also available in: Atom PDF