Michael Schoen
2007-Sep-16 03:38 UTC
Rails AR/Oracle Unit Test: [7497] failed (getting worse)
"bitsweat" has kicked AR/Oracle while it was down... http://dev.rubyonrails.org/changeset/7497 ------------------------------------------------------------------------ r7497 | bitsweat | 2007-09-15 20:32:47 -0700 (Sat, 15 Sep 2007) | 1 line connection.select_rows ''sql'' returns an array (rows) of arrays (field values). Closes #2329. ------------------------------------------------------------------------ U activerecord/test/finder_test.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/postgresql_adapter.rb U activerecord/lib/active_record/connection_adapters/mysql_adapter.rb U activerecord/lib/active_record/connection_adapters/sqlserver_adapter.rb U activerecord/lib/active_record/connection_adapters/db2_adapter.rb U activerecord/CHANGELOG Updated to revision 7497. 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:135: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:514:in `select'' ./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:7: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) Failure: test_select_rows(FinderTest) [./test/finder_test.rb:566: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'']: <[["1", nil, nil, "37signals"], ["2", "1", "2", "Summit"], ["3", "1", "1", "Microsoft"]]> expected but was <nil>. 3) Error: test_select_values(FinderTest): NoMethodError: undefined method `map'' for nil:NilClass ./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:135: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:400: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:71:in `test_cache_does_not_wrap_string_results_in_arrays'' ./test/../lib/active_record/query_cache.rb:107:in `cache'' ./test/query_cache_test.rb:70: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) Failure: test_no_dump_errors(SchemaDumperTest) [./test/schema_dumper_test.rb:64:in `test_no_dump_errors'' /usr/pkg/ruby184/lib/ruby/gems/1.8/gems/mocha-0.5.1/lib/mocha/test_case_adapter.rb:19:in `run'']: </\# Could not dump table/> expected to not match <"# This file is autogenerated. Instead of editing this file, please use the\n# migrations feature of ActiveRecord to incrementally modify your database, and\n# then regenerate this schema definition.\n\nActiveRecord::Schema.define(:version => 0) do\n\n# Could not dump table \"accounts\" because of following NoMethodError\n# undefined method `map'' for nil:NilClass\n\n# Could not dump table \"author_addresses\" because of following NoMethodError\n# undefined method `map'' for nil:NilClass\n\n# Could not dump table \"author_favorites\" because of following NoMethodError\n# undefined method `map'' for nil:NilClass\n\n# Could not dump table \"authors\" because of following NoMethodError\n# undefined method `map'' for nil:NilClass\n\n# Could not dump table \"auto_id_tests\" because of foll owing NoMethodError\n# undefined method `map'' for nil:NilClass\n\n# Could not dump table \"binaries\" because of following NoMethodError\n# undefined method `map'' for nil:NilClass\n\n# ! Could not dump table \"booleantests\" because of following NoMethodError\n# undefined method `map'' for nil:NilClass\n\n# Could not dump table \"categories\" because of following NoMethodError\n# undefined method `map'' for nil:NilClass\n\n# Could not dump table \"categories_posts\" because of following NoMethodError\n# undefined method `map'' for nil:NilCla --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---