test for checking Active Record Like query with backslash.

script.rb

begin
  require 'bundler/inline'
rescue LoadError => e
  $stderr.puts 'Bundler version 1.10 or later is required. Please update your Bundler'
  raise e
end

gemfile(true) do
  source 'https://rubygems.org'
  # Activate the gem you are reporting the issue against.
  gem 'activerecord', '4.2.0'
  gem 'sqlite3'
end

require 'active_record'
require 'minitest/autorun'
require 'logger'

# Ensure backward compatibility with Minitest 4
Minitest::Test = MiniTest::Unit::TestCase unless defined?(Minitest::Test)

# This connection will do for database-independent bug reports.
ActiveRecord::Base.establish_connection(adapter: 'sqlite3', database: ':memory:')
ActiveRecord::Base.logger = Logger.new(STDOUT)

ActiveRecord::Schema.define do
  create_table :posts, force: true do |t|
  end

  create_table :comments, force: true do |t|
    t.integer :post_id
    t.string :descr
  end
end

class Post < ActiveRecord::Base
  has_many :comments
end

class Comment < ActiveRecord::Base
	belongs_to :post
end

class BugTest < Minitest::Test
  def test_association_stuff
    post = Post.create!
    c1 =  Comment.create!(:descr => 'abc', :post_id => post.id)
    c2 = Comment.create!(:descr => "abc\\\\231", :post_id => post.id)
    c3 = Comment.create!(:descr => "abc\\\\red", :post_id => post.id)
    puts c1.descr,c2.descr,c3.descr

    n1 = Comment.where("descr LIKE 'abc'")
    n2 = Comment.where("descr LIKE '%\\\\%'")

    puts "n1"
    puts n1.pluck('descr')
    puts "n2"
    puts n2.pluck('descr')

    o1 = Comment.where('descr LIKE ?', "abc")
    o2 = Comment.where('descr LIKE ?', "%\\\\%")

    puts "o1"
    puts o1.pluck('descr')
    puts "o2"
    puts o2.pluck('descr')
  end
end