Normalizes attribute does not work as expected

[kmdtmyk]

This model uses ActiveRecord::Base.normalizes feature it's from rails version 7.1.

https://api.rubyonrails.org/classes/ActiveRecord/Normalization/ClassMethods.html#method-i-normalizes

class Book < ApplicationRecord
  # Convert full-width characters to half-width
  normalizes :title, with: ->(value){
    value.tr('Ａ-Ｚａ-ｚ', 'A-Za-z')
  }

  search_scope :search do
    attributes :title
  end
end

Book.create(title: 'ＡＢＣＤＥ') # full-width
=> #<Book id: 1, title: "ABCDE"> # converted to half-width

Book.search('ＡＢＣ').to_sql
=> "SELECT * FROM books WHERE title ILIKE '%ABC%'" # expected
=> "SELECT * FROM books WHERE title ILIKE '%ＡＢＣ%'" # actual

I tried to create a pull request. But it was too difficult for me. 😢

[mrkamel]

hi, thanks for reporting. I'll look into it, but cant give any ETA yet