aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorYasuo Honda <yasuo.honda@gmail.com>2011-10-19 15:56:25 -0400
committerYasuo Honda <yasuo.honda@gmail.com>2011-10-19 15:56:25 -0400
commit5bc23e4fb503e038c8e24a3a58d4eb1c323e94c8 (patch)
tree1bc7bc861e5eec2da924417a0370d87594e00d36
parent4a4927f753d7f41c0903ab3adfb73be8490c382e (diff)
downloadrails-5bc23e4fb503e038c8e24a3a58d4eb1c323e94c8.tar.gz
rails-5bc23e4fb503e038c8e24a3a58d4eb1c323e94c8.tar.bz2
rails-5bc23e4fb503e038c8e24a3a58d4eb1c323e94c8.zip
Fix ORA-00932 error when trying to insert 0 to DATE type columns.
-rw-r--r--activerecord/test/cases/migration_test.rb2
1 files changed, 1 insertions, 1 deletions
diff --git a/activerecord/test/cases/migration_test.rb b/activerecord/test/cases/migration_test.rb
index b3f1785f44..47ab5d5f9d 100644
--- a/activerecord/test/cases/migration_test.rb
+++ b/activerecord/test/cases/migration_test.rb
@@ -471,7 +471,7 @@ if ActiveRecord::Base.connection.supports_migrations?
# Do a manual insertion
if current_adapter?(:OracleAdapter)
- Person.connection.execute "insert into people (id, wealth, created_at, updated_at) values (people_seq.nextval, 12345678901234567890.0123456789, 0, 0)"
+ Person.connection.execute "insert into people (id, wealth, created_at, updated_at) values (people_seq.nextval, 12345678901234567890.0123456789, sysdate, sysdate)"
elsif current_adapter?(:OpenBaseAdapter) || (current_adapter?(:MysqlAdapter) && Mysql.client_version < 50003) #before mysql 5.0.3 decimals stored as strings
Person.connection.execute "insert into people (wealth, created_at, updated_at) values ('12345678901234567890.0123456789', 0, 0)"
elsif current_adapter?(:PostgreSQLAdapter)