Michael Schoen
2007-Sep-17 06:26 UTC
Rails AR/Oracle Unit Test: [7498] failed (but getting better)
"bitsweat" has given AR/Oracle some love, but it''s still unhappy... http://dev.rubyonrails.org/changeset/7498 ------------------------------------------------------------------------ r7498 | bitsweat | 2007-09-16 23:15:58 -0700 (Sun, 16 Sep 2007) | 1 line Speed up and simplify query caching. ------------------------------------------------------------------------ U activerecord/test/query_cache_test.rb A activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb U activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb U activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb U activerecord/lib/active_record/connection_adapters/abstract_adapter.rb U activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb U activerecord/lib/active_record/connection_adapters/mysql_adapter.rb U activerecord/lib/active_record/connection_adapters/oracle_adapter.rb U activerecord/lib/active_record/connection_adapters/sqlserver_adapter.rb U activerecord/lib/active_record/connection_adapters/sybase_adapter.rb U activerecord/lib/active_record/connection_adapters/db2_adapter.rb U activerecord/lib/active_record/query_cache.rb U activerecord/lib/active_record.rb U activerecord/CHANGELOG U actionpack/lib/action_controller/caching.rb Updated to revision 7498. 1) Error: test_joins_dont_clobber_id(FinderTest): ActiveRecord::StatementInvalid: OCIError: ORA-00905: missing keyword: select * from (select raw_sql_.*, rownum raw_rnum_ from (SELECT companies.* FROM companies INNER JOIN companies AS clients ON clients.firm_id = companies.id WHERE (companies.id = 1) AND ( (companies.type = ''Firm'' ) ) ) raw_sql_ where rownum <= 1) where raw_rnum_ > 0 ./test/../lib/active_record/connection_adapters/abstract_adapter.rb:137:in `log'' ./test/../lib/active_record/connection_adapters/oracle_adapter.rb:214:in `execute_without_counting'' ./test/abstract_unit.rb:71:in `execute'' ./test/../lib/active_record/connection_adapters/oracle_adapter.rb:509:in `select'' ./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'' ./test/../lib/active_record/connection_adapters/abstract/query_cache.rb:55:in `select_all'' ./test/../lib/active_record/base.rb:436:in `find_by_sql'' ./test/../lib/active_record/base.rb:997:in `find_every'' ./test/../lib/active_record/base.rb:991:in `find_initial'' ./test/../lib/active_record/base.rb:426:in `find'' ./test/finder_test.rb:514:in `test_joins_dont_clobber_id'' /usr/pkg/ruby184/lib/ruby/gems/1.8/gems/mocha-0.5.1/lib/mocha/test_case_adapter.rb:19:in `run'' 2) Error: test_select_rows(FinderTest): NotImplementedError: select_rows is an abstract method ./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:34:in `select_rows'' ./test/finder_test.rb:567:in `test_select_rows'' /usr/pkg/ruby184/lib/ruby/gems/1.8/gems/mocha-0.5.1/lib/mocha/test_case_adapter.rb:19:in `run'' 3) Error: test_select_values(FinderTest): NotImplementedError: select_rows is an abstract method ./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:34:in `select_rows'' ./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:27:in `select_values'' ./test/finder_test.rb:558:in `test_select_values'' /usr/pkg/ruby184/lib/ruby/gems/1.8/gems/mocha-0.5.1/lib/mocha/test_case_adapter.rb:19:in `run'' 4) Failure: test_rename_column_with_sql_reserved_word(MigrationTest) [./test/migration_test.rb:415:in `test_rename_column_with_sql_reserved_word'' /usr/pkg/ruby184/lib/ruby/gems/1.8/gems/mocha-0.5.1/lib/mocha/test_case_adapter.rb:19:in `run'']: Exception raised: Class: <ActiveRecord::StatementInvalid> Message: <"OCIError: ORA-00904: : invalid identifier: ALTER TABLE people RENAME COLUMN first_name to group"> ---Backtrace--- ./test/../lib/active_record/connection_adapters/abstract_adapter.rb:137:in `log'' ./test/../lib/active_record/connection_adapters/oracle_adapter.rb:214:in `execute_without_counting'' ./test/abstract_unit.rb:71:in `execute'' ./test/../lib/active_record/connection_adapters/oracle_adapter.rb:395:in `rename_column'' ./test/migration_test.rb:415:in `test_rename_column_with_sql_reserved_word'' ./test/migration_test.rb:415:in `test_rename_column_with_sql_reserved_word'' /usr/pkg/ruby184/lib/ruby/gems/1.8/gems/mocha-0.5.1/lib/mocha/test_case_adapter.rb:19:in `run'' --------------- 5) Failure: test_cache_does_not_wrap_string_results_in_arrays(QueryCacheTest) [./test/query_cache_test.rb:51:in `test_cache_does_not_wrap_string_results_in_arrays'' ./test/../lib/active_record/connection_adapters/abstract/query_cache.rb:33:in `cache'' ./test/../lib/active_record/query_cache.rb:8:in `cache'' ./test/query_cache_test.rb:50:in `test_cache_does_not_wrap_string_results_in_arrays'' /usr/pkg/ruby184/lib/ruby/gems/1.8/gems/mocha-0.5.1/lib/mocha/test_case_adapter.rb:19:in `run'']: <2.0> expected to be an instance of <String> but was <Float>. 6) Error: test_arguments_line_up(SchemaDumperTest): NotImplementedError: select_rows is an abstract method ./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:34:in `select_rows'' ./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:27:in `select_values'' ./test/../lib/active_record/connection_adapters/oracle_adapter.rb:407:in `pk_and_sequence_for'' ./test/../lib/active_record/schema_dumper.rb:73:in `table'' ./test/../lib/active_record/schema_dumper.rb:63:in `tables'' ./test/../lib/active_record/schema_dumper.rb:54:in `tables'' ./test/../lib/active_record/schema_dumper.rb:23:in `dump'' ./test/../lib/active_record/schema_dumper.rb:17:in `dump'' ./test/schema_dumper_test.rb:11:in `standard_dump'' ./test/schema_dumper_test.rb:36:in `column_definition_lines'' ./test/schema_dumper_test.rb:55:in `test_arguments_line_up'' /usr/pkg/ruby184/lib/ruby/gems/1.8/gems/mocha-0.5.1/lib/mocha/test_case_adapter.rb:19:in `run'' 7) Error: test_no_dump_errors(SchemaDumperTest): NotImplementedError: select_rows is an abstract method ./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:34:in `select_rows'' ./test/../lib/active_record/connection_ad --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To post to this group, send email to rubyonrails-core@googlegroups.com To unsubscribe from this group, send email to rubyonrails-core-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en -~----------~----~----~----~------~----~------~--~---