summaryrefslogtreecommitdiffstats
path: root/app/models
diff options
context:
space:
mode:
authorGo MAEDA <maeda@farend.jp>2024-05-14 08:04:04 +0000
committerGo MAEDA <maeda@farend.jp>2024-05-14 08:04:04 +0000
commit250414c3539ecd31bbad0b6ae4f4cf94b2b1864e (patch)
treeec989935ae21735f2f3494ca1f5faeaa8917dd9c /app/models
parent3761510af8b373931bc2c92567ea1d00e99415a7 (diff)
downloadredmine-250414c3539ecd31bbad0b6ae4f4cf94b2b1864e.tar.gz
redmine-250414c3539ecd31bbad0b6ae4f4cf94b2b1864e.zip
Explicitly reference table name in Project#like scope to avoid ambiguity (#40691).
Patch by Vincent Robert (@Nanego). git-svn-id: https://svn.redmine.org/redmine/trunk@22830 e93f8b46-1217-0410-a6f0-8f06a7374b81
Diffstat (limited to 'app/models')
-rw-r--r--app/models/project.rb2
1 files changed, 1 insertions, 1 deletions
diff --git a/app/models/project.rb b/app/models/project.rb
index abac2a1f0..2b3280651 100644
--- a/app/models/project.rb
+++ b/app/models/project.rb
@@ -110,7 +110,7 @@ class Project < ApplicationRecord
scope :like, (lambda do |arg|
if arg.present?
pattern = "%#{sanitize_sql_like arg.to_s.strip}%"
- where("LOWER(identifier) LIKE LOWER(:p) ESCAPE :s OR LOWER(name) LIKE LOWER(:p) ESCAPE :s", :p => pattern, :s => '\\')
+ where("LOWER(#{Project.table_name}.identifier) LIKE LOWER(:p) ESCAPE :s OR LOWER(#{Project.table_name}.name) LIKE LOWER(:p) ESCAPE :s", :p => pattern, :s => '\\')
end
end)
scope :sorted, lambda {order(:lft)}