Test Case - Inconsistent Typecasting of Time into Date

test_case_typecasting_of_date.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', '5.0.0.rc1'
  gem 'sqlite3'
  gem 'byebug'
end

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

# 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|
    t.date     "date"
  end
end

class Post < ActiveRecord::Base; end

class BugTest < Minitest::Test
  def date_value
    Time.new(2016,05,11,19,0,0,'-05:00')
  end

  def setup
    # INSERT INTO "posts" ("date") VALUES (?)  [["date", Wed, 11 May 2016]]
    Post.create(date: date_value)
  end

  def test_time_values_in_where_clause
    assert_equal 1, Post.where(date: date_value).count
  end

  def test_time_values_in_find_by_clause
    assert_equal Post.first, Post.find_by(date: date_value)
  end
end