mysql_create_table_engine.rb

# frozen_string_literal: true

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"

  git_source(:github) { |repo| "https://github.com/#{repo}.git" }

  gem "rails", github: "rails/rails"
  gem "arel", github: "rails/arel"
  gem "mysql2"
end

require "active_record"
require "minitest/autorun"
require "logger"

LOG_FILE_PATH = "mysql_create_table_engine.log"

# This connection will do for database-independent bug reports.
ActiveRecord::Base.establish_connection(adapter: "mysql2", database: "test", username: "root", password: "")
ActiveRecord::Base.logger = Logger.new(LOG_FILE_PATH)

class CreateUsers < ActiveRecord::Migration[5.2]
  def change
    create_table :users, options: "DEFAULT CHARSET=utf8" do |t|
      t.string :name
      t.string :email
    end
  end
end

class CreateProducts < ActiveRecord::Migration[5.2]
  def change
    create_table :products do |t|
      t.string :name
      t.integer :price
    end
  end
end

class BugTest < Minitest::Test
  def test_create_table_loses_engine_info
    create_users_migration = CreateUsers.new
    create_users_migration.change

    logged_info = File.read(LOG_FILE_PATH)
    assert !logged_info.include?("ENGINE")

    create_users_migration = CreateProducts.new
    create_users_migration.change

    logged_info = File.read(LOG_FILE_PATH)
    assert logged_info.include?("ENGINE")

    File.delete(LOG_FILE_PATH)
  end
end