Timestamps are coalescing to strings causing a fixture insert to fail
---------------------------------------------------------------------
Key: JRUBY-2322
URL: http://jira.codehaus.org/browse/JRUBY-2322
Project: JRuby
Issue Type: Bug
Components: ActiveRecord-JDBC
Affects Versions: JRuby 1.1RC3
Environment: Mac OS X 10.5.2
Oracle 10G
Rails 2.0.2
Reporter: Rob Christie
Attachments: patch.txt
Tests that previously worked with 1.0.3 and activerecord-jdbc 0.7 are now
failing.
I have narrowed down the issue to ::JdbcSpec::Oracle#quote(value,column). It
seems to be treating columns like created_at and updated_at like Strings
instead of as timestamps. When the test attempts to load the fixture, it treats
the date/time as a string. Perhaps it's my initial value that is no longer
being coalesced to a Time object.
{noformat}
9) Error:
test_should_not_remember_me(DashboardControllerTest):
ActiveRecord::StatementInvalid: ActiveRecord::ActiveRecordError: ORA-01861:
literal does not match format string
: INSERT INTO seop_users (salt, created_at, id, email, login, updated_at,
crypted_password) VALUES ('7e3041ebc2fc05a40c60028e2c4901a81035d3cd',
'2008-03-25 01:15:45', 2, '[EMAIL PROTECTED]', 'aaron', '2008-03-25 01:15:45',
'00742970dc9e6319f8019fd54864d3ea740f04b1')
/Users/rchristie/dev/seops/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:150:in
`log'
/usr/local/jruby-1.1RC3/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.8/lib/active_record/connection_adapters/jdbc_adapter.rb:520:in
`execute'
/Users/rchristie/dev/seops/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:140:in
`insert_fixture'
/Users/rchristie/dev/seops/vendor/rails/activerecord/lib/active_record/fixtures.rb:633:in
`insert_fixtures'
/Users/rchristie/dev/seops/vendor/rails/activerecord/lib/active_record/fixtures.rb:568:in
`each'
/Users/rchristie/dev/seops/vendor/rails/activerecord/lib/active_record/fixtures.rb:568:in
`insert_fixtures'
/Users/rchristie/dev/seops/vendor/rails/activerecord/lib/active_record/fixtures.rb:516:in
`create_fixtures'
/Users/rchristie/dev/seops/vendor/rails/activerecord/lib/active_record/fixtures.rb:516:in
`each'
/Users/rchristie/dev/seops/vendor/rails/activerecord/lib/active_record/fixtures.rb:516:in
`create_fixtures'
/Users/rchristie/dev/seops/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:66:in
`transaction'
/Users/rchristie/dev/seops/vendor/rails/activerecord/lib/active_record/fixtures.rb:514:in
`create_fixtures'
/Users/rchristie/dev/seops/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:77:in
`disable_referential_integrity'
/Users/rchristie/dev/seops/vendor/rails/activerecord/lib/active_record/fixtures.rb:505:in
`create_fixtures'
/Users/rchristie/dev/seops/vendor/rails/activerecord/lib/active_record/base.rb:1198:in
`silence'
/Users/rchristie/dev/seops/vendor/rails/activerecord/lib/active_record/fixtures.rb:504:in
`create_fixtures'
/Users/rchristie/dev/seops/vendor/rails/activerecord/lib/active_record/fixtures.rb:1002:in
`load_fixtures'
/Users/rchristie/dev/seops/vendor/rails/activerecord/lib/active_record/fixtures.rb:936:in
`setup_with_fixtures'
/Users/rchristie/dev/seops/vendor/rails/activerecord/lib/active_record/fixtures.rb:980:in
`full_setup'
{noformat}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
