Contents

# frozen_string_literal: true

class ActiveSet
  module Filtering
    module ActiveRecord
      module QueryColumn
        def query_column
          return @query_column if defined? @query_column

          @query_column = if must_cast_numerical_column?
                            column_cast_as_char
                          else
                            arel_column
                          end
        end

        private

        def column_cast_as_char
          # In order to use LIKE, we must CAST the numeric column as a CHAR column.
          # NOTE: this is can be quite inefficient, as it forces the DB engine to perform that cast on all rows.
          # https://www.ryadel.com/en/like-operator-equivalent-integer-numeric-columns-sql-t-sql-database/
          Arel::Nodes::NamedFunction.new('CAST', [arel_column.as('CHAR')])
        end

        def must_cast_numerical_column?
          # The LIKE operator can't be used if the column hosts numeric types.
          return false unless arel_type.presence_in(%i[integer float])

          arel_operator.to_s.downcase.include?('match')
        end
      end
    end
  end
end

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
actionset-0.11.0	lib/active_set/filtering/active_record/query_column.rb
actionset-0.10.0	lib/active_set/filtering/active_record/query_column.rb
actionset-0.9.2	lib/active_set/filtering/active_record/query_column.rb