From 7f0c49c58ab75bbd6b4dc44d47a8c4ab57db9d51 Mon Sep 17 00:00:00 2001
From: abcang <abcang1015@gmail.com>
Date: Sun, 25 Apr 2021 13:33:28 +0900
Subject: Improve tag search query (#16104)
---
spec/models/tag_spec.rb | 14 ++++++++++++++
1 file changed, 14 insertions(+)
(limited to 'spec')
diff --git a/spec/models/tag_spec.rb b/spec/models/tag_spec.rb
index df876593c..3949dbce5 100644
--- a/spec/models/tag_spec.rb
+++ b/spec/models/tag_spec.rb
@@ -96,6 +96,20 @@ RSpec.describe Tag, type: :model do
end
end
+ describe '.matches_name' do
+ it 'returns tags for multibyte case-insensitive names' do
+ upcase_string = 'abcABCａｂｃＡＢＣやゆよ'
+ downcase_string = 'abcabcａｂｃａｂｃやゆよ';
+
+ tag = Fabricate(:tag, name: downcase_string)
+ expect(Tag.matches_name(upcase_string)).to eq [tag]
+ end
+
+ it 'uses the LIKE operator' do
+ expect(Tag.matches_name('100%abc').to_sql).to eq %q[SELECT "tags".* FROM "tags" WHERE LOWER("tags"."name") LIKE LOWER('100\\%abc%')]
+ end
+ end
+
describe '.matching_name' do
it 'returns tags for multibyte case-insensitive names' do
upcase_string = 'abcABCａｂｃＡＢＣやゆよ'
--
cgit