Michael Schoen
2006-Jul-06 05:51 UTC
Rails AR/Oracle Unit Test: [4508] failed (but getting better)
"bitsweat" has given AR/Oracle some love, but it''s still
unhappy...
http://dev.rubyonrails.org/changeset/4508
------------------------------------------------------------------------
r4508 | bitsweat | 2006-06-28 18:13:55 -0700 (Wed, 28 Jun 2006) | 3 lines
r4720@asus: jeremy | 2006-06-28 18:12:57 -0700
Don''t be such a hardass. References #5497.
------------------------------------------------------------------------
U activerecord/lib/active_record/fixtures.rb
U .
Updated to revision 4508.
1) Failure:
test_to_xml(BasicsTest) [./test/base_test.rb:1245]:
<false> is not true.
2) Error:
test_add_column_not_null_with_default(MigrationTest):
ActiveRecord::StatementInvalid: OCIError: ORA-01400: cannot insert NULL into
("ARUNIT"."TESTINGS"."ID"): insert into testings
(foo) values (''hello'')
./test/../lib/active_record/connection_adapters/abstract_adapter.rb:120:in
`log''
./test/../lib/active_record/connection_adapters/oracle_adapter.rb:277:in
`execute''
./test/migration_test.rb:176:in
`test_add_column_not_null_with_default''
3) Failure:
test_sane_find_with_lock(PessimisticLockingTest) [./test/locking_test.rb:90]:
Exception raised:
Class: <ActiveRecord::StatementInvalid>
Message: <"OCIError: ORA-02014: cannot select FOR UPDATE from view with
DISTINCT, GROUP BY, etc.: select * from (select raw_sql_.*, rownum raw_rnum_
from (SELECT * FROM people WHERE (people.id = 1) ) raw_sql_ where rownum <=
1) where raw_rnum_ > 0 FOR UPDATE">
---Backtrace---
./test/../lib/active_record/connection_adapters/abstract_adapter.rb:120:in
`log''
./test/../lib/active_record/connection_adapters/oracle_adapter.rb:277:in
`execute''
./test/../lib/active_record/connection_adapters/oracle_adapter.rb:477:in
`select''
./test/../lib/active_record/connection_adapters/oracle_adapter.rb:268:in
`select_all''
./test/../lib/active_record/base.rb:422:in `find_by_sql''
./test/../lib/active_record/base.rb:956:in `find_every''
./test/../lib/active_record/base.rb:950:in `find_initial''
./test/../lib/active_record/base.rb:984:in `find_one''
./test/../lib/active_record/base.rb:973:in `find_from_ids''
./test/../lib/active_record/base.rb:414:in `find''
./test/locking_test.rb:93:in `test_sane_find_with_lock''
./test/../lib/active_record/base.rb:905:in `with_scope''
./test/locking_test.rb:92:in `test_sane_find_with_lock''
./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:51:in
`transaction''
./test/../lib/active_record/transactions.rb:86:in `transaction''
./test/locking_test.rb:91:in `test_sane_find_with_lock''
./test/locking_test.rb:90:in `test_sane_find_with_lock''
---------------
4) Failure:
test_sane_lock_method(PessimisticLockingTest) [./test/locking_test.rb:101]:
Exception raised:
Class: <ActiveRecord::StatementInvalid>
Message: <"OCIError: ORA-02014: cannot select FOR UPDATE from view with
DISTINCT, GROUP BY, etc.: select * from (select raw_sql_.*, rownum raw_rnum_
from (SELECT * FROM people WHERE (people.id = 1) ) raw_sql_ where rownum <=
1) where raw_rnum_ > 0 FOR UPDATE">
---Backtrace---
./test/../lib/active_record/connection_adapters/abstract_adapter.rb:120:in
`log''
./test/../lib/active_record/connection_adapters/oracle_adapter.rb:277:in
`execute''
./test/../lib/active_record/connection_adapters/oracle_adapter.rb:477:in
`select''
./test/../lib/active_record/connection_adapters/oracle_adapter.rb:268:in
`select_all''
./test/../lib/active_record/base.rb:422:in `find_by_sql''
./test/../lib/active_record/base.rb:956:in `find_every''
./test/../lib/active_record/base.rb:950:in `find_initial''
./test/../lib/active_record/base.rb:984:in `find_one''
./test/../lib/active_record/base.rb:973:in `find_from_ids''
./test/../lib/active_record/base.rb:414:in `find''
./test/../lib/active_record/base.rb:1561:in `reload''
./test/../lib/active_record/locking/pessimistic.rb:72:in `lock!''
./test/locking_test.rb:105:in `test_sane_lock_method''
./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:51:in
`transaction''
./test/../lib/active_record/transactions.rb:86:in `transaction''
./test/locking_test.rb:102:in `test_sane_lock_method''
./test/locking_test.rb:101:in `test_sane_lock_method''
---------------
903 tests, 3173 assertions, 3 failures, 1 errors
rake aborted!
Command failed with status (1): [/usr/pkg/ruby184/bin/ruby -Ilib:test:test/...]
(See full trace by running task with --trace)