From 4157f5d172830df07b44a66d4096d152e068dc4a Mon Sep 17 00:00:00 2001 From: Ryuta Kamizono Date: Wed, 17 Dec 2014 16:01:28 +0900 Subject: Format the datetime string according to the precision of the datetime field. Incompatible to rounding behavior between MySQL 5.6 and earlier. In 5.5, when you insert `2014-08-17 12:30:00.999999` the fractional part is ignored. In 5.6, it's rounded to `2014-08-17 12:30:01`: http://bugs.mysql.com/bug.php?id=68760 --- activerecord/test/cases/adapters/mysql/datetime_test.rb | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) (limited to 'activerecord/test/cases/adapters/mysql/datetime_test.rb') diff --git a/activerecord/test/cases/adapters/mysql/datetime_test.rb b/activerecord/test/cases/adapters/mysql/datetime_test.rb index 1705fecce0..fadca1fcf4 100644 --- a/activerecord/test/cases/adapters/mysql/datetime_test.rb +++ b/activerecord/test/cases/adapters/mysql/datetime_test.rb @@ -2,6 +2,9 @@ require 'cases/helper' if mysql_56? class DateTimeTest < ActiveRecord::TestCase + self.use_transactional_fixtures = false + + class Foo < ActiveRecord::Base; end def test_default_datetime_precision ActiveRecord::Base.connection.create_table(:foos, force: true) @@ -50,6 +53,20 @@ if mysql_56? assert_equal 4, mysql_datetime_precision('foos', 'updated_at') end + def test_formatting_datetime_according_to_precision + ActiveRecord::Base.connection.create_table(:foos, force: true) do |t| + t.datetime :created_at, precision: 0 + t.datetime :updated_at, precision: 4 + end + date = ::Time.utc(2014, 8, 17, 12, 30, 0, 999999) + Foo.create!(created_at: date, updated_at: date) + assert foo = Foo.find_by(created_at: date) + assert_equal date.to_s, foo.created_at.to_s + assert_equal date.to_s, foo.updated_at.to_s + assert_equal 000000, foo.created_at.usec + assert_equal 999900, foo.updated_at.usec + end + private def mysql_datetime_precision(table_name, column_name) -- cgit v1.2.3