Skip to content

Instantly share code, notes, and snippets.

@nevans
Created November 20, 2008 19:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nevans/27158 to your computer and use it in GitHub Desktop.
Save nevans/27158 to your computer and use it in GitHub Desktop.
use master
drop database activerecord_unittest
drop database activerecord_unittest2
go
create database activerecord_unittest
go
create database activerecord_unittest2
go
use activerecord_unittest
go
exec sp_grantdbaccess 'rails'
go
grant BACKUP DATABASE, BACKUP LOG,
CREATE DEFAULT, CREATE FUNCTION,
CREATE PROCEDURE, CREATE RULE,
CREATE TABLE, CREATE VIEW to rails
go
use activerecord_unittest2
go
exec sp_grantdbaccess 'rails'
go
grant BACKUP DATABASE, BACKUP LOG,
CREATE DEFAULT, CREATE FUNCTION,
CREATE PROCEDURE, CREATE RULE,
CREATE TABLE, CREATE VIEW to rails
go
[virtualbox_tunnelled]
host = localhost
port = 1433
tds version = 8.0
[activerecord_unittest]
Driver=TDS
Description=VMware DB
Trace=No
Servername=virtualbox_tunnelled
Database=activerecord_unittest
[activerecord_unittest2]
Driver=TDS
Description=VMware DB
Trace=No
Servername=virtualbox_tunnelled
Database=activerecord_unittest2
== (nevans@nevans-laptop) [Thu Nov 20]-(14:16:37) ==
~/src/rails_and_sqlserver-adapter/plugins/adapters/rails-sqlserver-adapter $ rake test_sqlserver_odbc
(in /home/nevans/src/rails_and_sqlserver-adapter/plugins/adapters/rails-sqlserver-adapter)
/usr/bin/ruby1.8 -Ilib:test:test/connections/native_sqlserver_odbc:../../../rails/activerecord/test/ "/home/nevans/.gems/gems/rake-0.8.3/lib/rake/rake_test_loader.rb" "test/cases/aaaa_create_tables_test_sqlserver.rb" "test/cases/adapter_test_sqlserver.rb" "test/cases/basics_test_sqlserver.rb" "test/cases/calculations_test_sqlserver.rb" "test/cases/column_test_sqlserver.rb" "test/cases/connection_test_sqlserver.rb" "test/cases/eager_association_test_sqlserver.rb" "test/cases/inheritance_test_sqlserver.rb" "test/cases/migration_test_sqlserver.rb" "test/cases/offset_and_limit_test_sqlserver.rb" "test/cases/pessimistic_locking_test_sqlserver.rb" "test/cases/query_cache_test_sqlserver.rb" "test/cases/schema_dumper_test_sqlserver.rb" "test/cases/specific_schema_test_sqlserver.rb" "../../../rails/activerecord/test/cases/aaa_create_tables_test.rb" "../../../rails/activerecord/test/cases/adapter_test.rb" "../../../rails/activerecord/test/cases/aggregations_test.rb" "../../../rails/activerecord/test/cases/ar_schema_test.rb" "../../../rails/activerecord/test/cases/associations/belongs_to_associations_test.rb" "../../../rails/activerecord/test/cases/associations/callbacks_test.rb" "../../../rails/activerecord/test/cases/associations/cascaded_eager_loading_test.rb" "../../../rails/activerecord/test/cases/associations/eager_load_includes_full_sti_class_test.rb" "../../../rails/activerecord/test/cases/associations/eager_load_nested_include_test.rb" "../../../rails/activerecord/test/cases/associations/eager_singularization_test.rb" "../../../rails/activerecord/test/cases/associations/eager_test.rb" "../../../rails/activerecord/test/cases/associations/extension_test.rb" "../../../rails/activerecord/test/cases/associations/has_and_belongs_to_many_associations_test.rb" "../../../rails/activerecord/test/cases/associations/has_many_associations_test.rb" "../../../rails/activerecord/test/cases/associations/has_many_through_associations_test.rb" "../../../rails/activerecord/test/cases/associations/has_one_associations_test.rb" "../../../rails/activerecord/test/cases/associations/has_one_through_associations_test.rb" "../../../rails/activerecord/test/cases/associations/inner_join_association_test.rb" "../../../rails/activerecord/test/cases/associations/join_model_test.rb" "../../../rails/activerecord/test/cases/associations_test.rb" "../../../rails/activerecord/test/cases/attribute_methods_test.rb" "../../../rails/activerecord/test/cases/base_test.rb" "../../../rails/activerecord/test/cases/binary_test.rb" "../../../rails/activerecord/test/cases/calculations_test.rb" "../../../rails/activerecord/test/cases/callbacks_observers_test.rb" "../../../rails/activerecord/test/cases/callbacks_test.rb" "../../../rails/activerecord/test/cases/class_inheritable_attributes_test.rb" "../../../rails/activerecord/test/cases/column_alias_test.rb" "../../../rails/activerecord/test/cases/column_definition_test.rb" "../../../rails/activerecord/test/cases/database_statements_test.rb" "../../../rails/activerecord/test/cases/date_time_test.rb" "../../../rails/activerecord/test/cases/defaults_test.rb" "../../../rails/activerecord/test/cases/deprecated_finder_test.rb" "../../../rails/activerecord/test/cases/dirty_test.rb" "../../../rails/activerecord/test/cases/finder_respond_to_test.rb" "../../../rails/activerecord/test/cases/finder_test.rb" "../../../rails/activerecord/test/cases/fixtures_test.rb" "../../../rails/activerecord/test/cases/i18n_test.rb" "../../../rails/activerecord/test/cases/inheritance_test.rb" "../../../rails/activerecord/test/cases/invalid_date_test.rb" "../../../rails/activerecord/test/cases/json_serialization_test.rb" "../../../rails/activerecord/test/cases/lifecycle_test.rb" "../../../rails/activerecord/test/cases/locking_test.rb" "../../../rails/activerecord/test/cases/method_scoping_test.rb" "../../../rails/activerecord/test/cases/migration_test.rb" "../../../rails/activerecord/test/cases/mixin_test.rb" "../../../rails/activerecord/test/cases/modules_test.rb" "../../../rails/activerecord/test/cases/multiple_db_test.rb" "../../../rails/activerecord/test/cases/named_scope_test.rb" "../../../rails/activerecord/test/cases/pk_test.rb" "../../../rails/activerecord/test/cases/pooled_connections_test.rb" "../../../rails/activerecord/test/cases/query_cache_test.rb" "../../../rails/activerecord/test/cases/readonly_test.rb" "../../../rails/activerecord/test/cases/reflection_test.rb" "../../../rails/activerecord/test/cases/reload_models_test.rb" "../../../rails/activerecord/test/cases/sanitize_test.rb" "../../../rails/activerecord/test/cases/schema_dumper_test.rb" "../../../rails/activerecord/test/cases/serialization_test.rb" "../../../rails/activerecord/test/cases/transactions_test.rb" "../../../rails/activerecord/test/cases/unconnected_test.rb" "../../../rails/activerecord/test/cases/validations_i18n_test.rb" "../../../rails/activerecord/test/cases/validations_test.rb" "../../../rails/activerecord/test/cases/xml_serialization_test.rb"
Using native SQLServer via ODBC
* DEFERRED: For abstract behavior with different language should do a date insertion when language is german.
Loaded suite /home/nevans/.gems/gems/rake-0.8.3/lib/rake/rake_test_loader
Started
.................................................................................................................................................................F....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................F..................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................E.EE................E..............E........................E.E.E.......................
Finished in 180.061601 seconds.
1) Failure:
test: When disableing referential integrity should NOT ALLOW by default the deletion of a referenced parent. (AdapterTestSqlserver)
[./test/cases/adapter_test_sqlserver.rb:310:in `__bind_1227208646_86655'
/home/nevans/.gems/gems/thoughtbot-shoulda-2.0.5/lib/shoulda/context.rb:254:in `call'
/home/nevans/.gems/gems/thoughtbot-shoulda-2.0.5/lib/shoulda/context.rb:254:in `test: When disableing referential integrity should NOT ALLOW by default the deletion of a referenced parent. '
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:96:in `__send__'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:96:in `run']:
<ActiveRecord::StatementInvalid> exception expected but none was thrown.
2) Failure:
test_dependence_with_transaction_support_on_failure(HasManyAssociationsTest)
[../../../rails/activerecord/test/cases/associations/has_many_associations_test.rb:766:in `test_dependence_with_transaction_support_on_failure'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:96:in `__send__'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:96:in `run']:
<2> expected but was
<1>.
3) Error:
test_optionally_validates_length_of_using_within_on_create_utf8(ValidationsTest):
ActiveRecord::StatementInvalid: DBI::DatabaseError: S1000 (2402) [unixODBC][FreeTDS][SQL Server]Error converting characters into server's character set. Some character(s) could not be converted: INSERT INTO [topics] ([title], [author_name], [approved], [bonus_time], [replies_count], [type], [content], [parent_id], [author_email_address], [written_on], [last_read]) VALUES('一二三四五六七八九', NULL, 1, NULL, 0, NULL, 'whatever', NULL, 'test@test.com', '2008-11-20 14:20:18.587', NULL)
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract_adapter.rb:188:in `log'
./lib/active_record/connection_adapters/sqlserver_adapter.rb:615:in `raw_execute'
./lib/active_record/connection_adapters/sqlserver_adapter.rb:287:in `execute_without_query_record'
../../../rails/activerecord/test/cases/helper.rb:39:in `execute'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/database_statements.rb:171:in `insert_sql'
./lib/active_record/connection_adapters/sqlserver_adapter.rb:605:in `insert_sql'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/database_statements.rb:44:in `insert_without_query_dirty'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/query_cache.rb:18:in `insert'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:2747:in `create_without_callbacks'
../../../rails/activerecord/test/cases/../../lib/active_record/callbacks.rb:237:in `create_without_timestamps'
../../../rails/activerecord/test/cases/../../lib/active_record/timestamp.rb:29:in `create'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:2713:in `create_or_update_without_callbacks'
../../../rails/activerecord/test/cases/../../lib/active_record/callbacks.rb:222:in `create_or_update'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:2397:in `save_without_validation'
../../../rails/activerecord/test/cases/../../lib/active_record/validations.rb:1009:in `save_without_dirty'
../../../rails/activerecord/test/cases/../../lib/active_record/dirty.rb:79:in `save_without_transactions'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:179:in `send'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:179:in `with_transaction_returning_status'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/database_statements.rb:66:in `transaction'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:129:in `transaction'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:138:in `transaction'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:178:in `with_transaction_returning_status'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:146:in `save'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:158:in `rollback_active_record_state!'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:146:in `save'
../../../rails/activerecord/test/cases/validations_test.rb:1043:in `test_optionally_validates_length_of_using_within_on_create_utf8'
../../../rails/activerecord/test/cases/validations_test.rb:1403:in `with_kcode'
../../../rails/activerecord/test/cases/validations_test.rb:1034:in `test_optionally_validates_length_of_using_within_on_create_utf8'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:96:in `__send__'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:96:in `run'
4) Error:
test_optionally_validates_length_of_using_within_on_update_utf8(ValidationsTest):
ActiveRecord::StatementInvalid: DBI::DatabaseError: S1000 (2402) [unixODBC][FreeTDS][SQL Server]Error converting characters into server's character set. Some character(s) could not be converted: INSERT INTO [topics] ([title], [author_name], [approved], [bonus_time], [replies_count], [type], [content], [parent_id], [author_email_address], [written_on], [last_read]) VALUES('一二三4', NULL, 1, NULL, 0, NULL, 'whatever', NULL, 'test@test.com', '2008-11-20 14:20:18.605', NULL)
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract_adapter.rb:188:in `log'
./lib/active_record/connection_adapters/sqlserver_adapter.rb:615:in `raw_execute'
./lib/active_record/connection_adapters/sqlserver_adapter.rb:287:in `execute_without_query_record'
../../../rails/activerecord/test/cases/helper.rb:39:in `execute'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/database_statements.rb:171:in `insert_sql'
./lib/active_record/connection_adapters/sqlserver_adapter.rb:605:in `insert_sql'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/database_statements.rb:44:in `insert_without_query_dirty'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/query_cache.rb:18:in `insert'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:2747:in `create_without_callbacks'
../../../rails/activerecord/test/cases/../../lib/active_record/callbacks.rb:237:in `create_without_timestamps'
../../../rails/activerecord/test/cases/../../lib/active_record/timestamp.rb:29:in `create'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:2713:in `create_or_update_without_callbacks'
../../../rails/activerecord/test/cases/../../lib/active_record/callbacks.rb:222:in `create_or_update'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:2397:in `save_without_validation'
../../../rails/activerecord/test/cases/../../lib/active_record/validations.rb:1009:in `save_without_dirty'
../../../rails/activerecord/test/cases/../../lib/active_record/dirty.rb:79:in `save_without_transactions'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:179:in `send'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:179:in `with_transaction_returning_status'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/database_statements.rb:66:in `transaction'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:129:in `transaction'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:138:in `transaction'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:178:in `with_transaction_returning_status'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:146:in `save'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:158:in `rollback_active_record_state!'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:146:in `save'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:697:in `create'
../../../rails/activerecord/test/cases/validations_test.rb:1060:in `test_optionally_validates_length_of_using_within_on_update_utf8'
../../../rails/activerecord/test/cases/validations_test.rb:1403:in `with_kcode'
../../../rails/activerecord/test/cases/validations_test.rb:1057:in `test_optionally_validates_length_of_using_within_on_update_utf8'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:96:in `__send__'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:96:in `run'
5) Error:
test_optionally_validates_length_of_using_within_utf8(ValidationsTest):
ActiveRecord::StatementInvalid: DBI::DatabaseError: S1000 (2402) [unixODBC][FreeTDS][SQL Server]Error converting characters into server's character set. Some character(s) could not be converted: INSERT INTO [topics] ([title], [author_name], [approved], [bonus_time], [replies_count], [type], [content], [parent_id], [author_email_address], [written_on], [last_read]) VALUES('一二三四五', NULL, 1, NULL, 0, NULL, NULL, NULL, 'test@test.com', '2008-11-20 14:20:18.611', NULL)
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract_adapter.rb:188:in `log'
./lib/active_record/connection_adapters/sqlserver_adapter.rb:615:in `raw_execute'
./lib/active_record/connection_adapters/sqlserver_adapter.rb:287:in `execute_without_query_record'
../../../rails/activerecord/test/cases/helper.rb:39:in `execute'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/database_statements.rb:171:in `insert_sql'
./lib/active_record/connection_adapters/sqlserver_adapter.rb:605:in `insert_sql'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/database_statements.rb:44:in `insert_without_query_dirty'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/query_cache.rb:18:in `insert'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:2747:in `create_without_callbacks'
../../../rails/activerecord/test/cases/../../lib/active_record/callbacks.rb:237:in `create_without_timestamps'
../../../rails/activerecord/test/cases/../../lib/active_record/timestamp.rb:29:in `create'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:2713:in `create_or_update_without_callbacks'
../../../rails/activerecord/test/cases/../../lib/active_record/callbacks.rb:222:in `create_or_update'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:2397:in `save_without_validation'
../../../rails/activerecord/test/cases/../../lib/active_record/validations.rb:1009:in `save_without_dirty'
../../../rails/activerecord/test/cases/../../lib/active_record/dirty.rb:79:in `save_without_transactions'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:179:in `send'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:179:in `with_transaction_returning_status'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/database_statements.rb:66:in `transaction'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:129:in `transaction'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:138:in `transaction'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:178:in `with_transaction_returning_status'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:146:in `save'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:158:in `rollback_active_record_state!'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:146:in `save'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:697:in `create'
../../../rails/activerecord/test/cases/validations_test.rb:1022:in `test_optionally_validates_length_of_using_within_utf8'
../../../rails/activerecord/test/cases/validations_test.rb:1403:in `with_kcode'
../../../rails/activerecord/test/cases/validations_test.rb:1019:in `test_optionally_validates_length_of_using_within_utf8'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:96:in `__send__'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:96:in `run'
6) Error:
test_validate_case_insensitive_uniqueness(ValidationsTest):
ActiveRecord::StatementInvalid: DBI::DatabaseError: S1000 (2402) [unixODBC][FreeTDS][SQL Server]Error converting characters into server's character set. Some character(s) could not be converted: SELECT TOP 1 [topics].id FROM [topics] WHERE (LOWER([topics].[title]) COLLATE Latin1_General_CS_AS = 'я тоже уникальный!')
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract_adapter.rb:188:in `log'
./lib/active_record/connection_adapters/sqlserver_adapter.rb:615:in `raw_execute'
./lib/active_record/connection_adapters/sqlserver_adapter.rb:638:in `raw_select_without_query_record'
./test/cases/sqlserver_helper.rb:68:in `raw_select'
./lib/active_record/connection_adapters/sqlserver_adapter.rb:593:in `select'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/query_cache.rb:62:in `select_all'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:659:in `exists?'
../../../rails/activerecord/test/cases/../../lib/active_record/validations.rb:758:in `validates_uniqueness_of'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:2007:in `with_scope'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:2015:in `with_exclusive_scope'
../../../rails/activerecord/test/cases/../../lib/active_record/validations.rb:757:in `validates_uniqueness_of'
../../../rails/activerecord/test/cases/../../lib/active_record/validations.rb:400:in `validates_each'
../../../rails/activerecord/test/cases/../../lib/active_record/validations.rb:397:in `each'
../../../rails/activerecord/test/cases/../../lib/active_record/validations.rb:397:in `validates_each'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/callbacks.rb:182:in `call'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/callbacks.rb:182:in `evaluate_method'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/callbacks.rb:166:in `call'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/callbacks.rb:90:in `run'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/callbacks.rb:90:in `each'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/callbacks.rb:90:in `send'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/callbacks.rb:90:in `run'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/callbacks.rb:277:in `run_callbacks'
../../../rails/activerecord/test/cases/../../lib/active_record/validations.rb:1029:in `valid_without_callbacks?'
../../../rails/activerecord/test/cases/../../lib/active_record/callbacks.rb:286:in `valid?'
../../../rails/activerecord/test/cases/../../lib/active_record/validations.rb:1008:in `save_without_dirty'
../../../rails/activerecord/test/cases/../../lib/active_record/dirty.rb:79:in `save_without_transactions'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:179:in `send'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:179:in `with_transaction_returning_status'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/database_statements.rb:66:in `transaction'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:129:in `transaction'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:138:in `transaction'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:178:in `with_transaction_returning_status'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:146:in `save'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:158:in `rollback_active_record_state!'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:146:in `save'
../../../rails/activerecord/test/cases/validations_test.rb:464:in `test_validate_case_insensitive_uniqueness'
../../../rails/activerecord/test/cases/validations_test.rb:1403:in `with_kcode'
../../../rails/activerecord/test/cases/validations_test.rb:462:in `test_validate_case_insensitive_uniqueness'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:96:in `__send__'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:96:in `run'
7) Error:
test_validates_acceptance_of_as_database_column(ValidationsTest):
ActiveRecord::MissingAttributeError: missing attribute: parent_id
../../../rails/activerecord/test/cases/../../lib/active_record/validations.rb:746:in `send'
../../../rails/activerecord/test/cases/../../lib/active_record/validations.rb:746:in `validates_uniqueness_of'
../../../rails/activerecord/test/cases/../../lib/active_record/validations.rb:745:in `map'
../../../rails/activerecord/test/cases/../../lib/active_record/validations.rb:745:in `validates_uniqueness_of'
../../../rails/activerecord/test/cases/../../lib/active_record/validations.rb:400:in `validates_each'
../../../rails/activerecord/test/cases/../../lib/active_record/validations.rb:397:in `each'
../../../rails/activerecord/test/cases/../../lib/active_record/validations.rb:397:in `validates_each'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/callbacks.rb:182:in `call'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/callbacks.rb:182:in `evaluate_method'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/callbacks.rb:166:in `call'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/callbacks.rb:90:in `run'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/callbacks.rb:90:in `each'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/callbacks.rb:90:in `send'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/callbacks.rb:90:in `run'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/callbacks.rb:277:in `run_callbacks'
../../../rails/activerecord/test/cases/../../lib/active_record/validations.rb:1029:in `valid_without_callbacks?'
../../../rails/activerecord/test/cases/../../lib/active_record/callbacks.rb:286:in `valid?'
../../../rails/activerecord/test/cases/../../lib/active_record/validations.rb:1008:in `save_without_dirty'
../../../rails/activerecord/test/cases/../../lib/active_record/dirty.rb:79:in `save_without_transactions'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:179:in `send'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:179:in `with_transaction_returning_status'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/database_statements.rb:66:in `transaction'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:129:in `transaction'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:138:in `transaction'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:178:in `with_transaction_returning_status'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:146:in `save'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:158:in `rollback_active_record_state!'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:146:in `save'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:697:in `create'
../../../rails/activerecord/test/cases/validations_test.rb:318:in `test_validates_acceptance_of_as_database_column'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:96:in `__send__'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:96:in `run'
8) Error:
test_validates_length_of_using_is_utf8(ValidationsTest):
ActiveRecord::StatementInvalid: DBI::DatabaseError: S1000 (2402) [unixODBC][FreeTDS][SQL Server]Error converting characters into server's character set. Some character(s) could not be converted: INSERT INTO [topics] ([title], [author_name], [approved], [bonus_time], [replies_count], [type], [content], [parent_id], [author_email_address], [written_on], [last_read]) VALUES('一二345', NULL, 1, NULL, 0, NULL, 'whatever', NULL, 'test@test.com', '2008-11-20 14:20:20.067', NULL)
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract_adapter.rb:188:in `log'
./lib/active_record/connection_adapters/sqlserver_adapter.rb:615:in `raw_execute'
./lib/active_record/connection_adapters/sqlserver_adapter.rb:287:in `execute_without_query_record'
../../../rails/activerecord/test/cases/helper.rb:39:in `execute'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/database_statements.rb:171:in `insert_sql'
./lib/active_record/connection_adapters/sqlserver_adapter.rb:605:in `insert_sql'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/database_statements.rb:44:in `insert_without_query_dirty'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/query_cache.rb:18:in `insert'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:2747:in `create_without_callbacks'
../../../rails/activerecord/test/cases/../../lib/active_record/callbacks.rb:237:in `create_without_timestamps'
../../../rails/activerecord/test/cases/../../lib/active_record/timestamp.rb:29:in `create'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:2713:in `create_or_update_without_callbacks'
../../../rails/activerecord/test/cases/../../lib/active_record/callbacks.rb:222:in `create_or_update'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:2397:in `save_without_validation'
../../../rails/activerecord/test/cases/../../lib/active_record/validations.rb:1009:in `save_without_dirty'
../../../rails/activerecord/test/cases/../../lib/active_record/dirty.rb:79:in `save_without_transactions'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:179:in `send'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:179:in `with_transaction_returning_status'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/database_statements.rb:66:in `transaction'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:129:in `transaction'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:138:in `transaction'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:178:in `with_transaction_returning_status'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:146:in `save'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:158:in `rollback_active_record_state!'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:146:in `save'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:697:in `create'
../../../rails/activerecord/test/cases/validations_test.rb:1082:in `test_validates_length_of_using_is_utf8'
../../../rails/activerecord/test/cases/validations_test.rb:1403:in `with_kcode'
../../../rails/activerecord/test/cases/validations_test.rb:1079:in `test_validates_length_of_using_is_utf8'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:96:in `__send__'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:96:in `run'
9) Error:
test_validates_length_of_using_maximum_utf8(ValidationsTest):
ActiveRecord::StatementInvalid: DBI::DatabaseError: S1000 (2402) [unixODBC][FreeTDS][SQL Server]Error converting characters into server's character set. Some character(s) could not be converted: INSERT INTO [topics] ([title], [author_name], [approved], [bonus_time], [replies_count], [type], [content], [parent_id], [author_email_address], [written_on], [last_read]) VALUES('一二三四五', NULL, 1, NULL, 0, NULL, 'whatever', NULL, 'test@test.com', '2008-11-20 14:20:20.093', NULL)
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract_adapter.rb:188:in `log'
./lib/active_record/connection_adapters/sqlserver_adapter.rb:615:in `raw_execute'
./lib/active_record/connection_adapters/sqlserver_adapter.rb:287:in `execute_without_query_record'
../../../rails/activerecord/test/cases/helper.rb:39:in `execute'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/database_statements.rb:171:in `insert_sql'
./lib/active_record/connection_adapters/sqlserver_adapter.rb:605:in `insert_sql'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/database_statements.rb:44:in `insert_without_query_dirty'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/query_cache.rb:18:in `insert'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:2747:in `create_without_callbacks'
../../../rails/activerecord/test/cases/../../lib/active_record/callbacks.rb:237:in `create_without_timestamps'
../../../rails/activerecord/test/cases/../../lib/active_record/timestamp.rb:29:in `create'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:2713:in `create_or_update_without_callbacks'
../../../rails/activerecord/test/cases/../../lib/active_record/callbacks.rb:222:in `create_or_update'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:2397:in `save_without_validation'
../../../rails/activerecord/test/cases/../../lib/active_record/validations.rb:1009:in `save_without_dirty'
../../../rails/activerecord/test/cases/../../lib/active_record/dirty.rb:79:in `save_without_transactions'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:179:in `send'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:179:in `with_transaction_returning_status'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/database_statements.rb:66:in `transaction'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:129:in `transaction'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:138:in `transaction'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:178:in `with_transaction_returning_status'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:146:in `save'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:158:in `rollback_active_record_state!'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:146:in `save'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:697:in `create'
../../../rails/activerecord/test/cases/validations_test.rb:994:in `test_validates_length_of_using_maximum_utf8'
../../../rails/activerecord/test/cases/validations_test.rb:1403:in `with_kcode'
../../../rails/activerecord/test/cases/validations_test.rb:991:in `test_validates_length_of_using_maximum_utf8'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:96:in `__send__'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:96:in `run'
10) Error:
test_validates_length_of_using_minimum_utf8(ValidationsTest):
ActiveRecord::StatementInvalid: DBI::DatabaseError: S1000 (2402) [unixODBC][FreeTDS][SQL Server]Error converting characters into server's character set. Some character(s) could not be converted: INSERT INTO [topics] ([title], [author_name], [approved], [bonus_time], [replies_count], [type], [content], [parent_id], [author_email_address], [written_on], [last_read]) VALUES('一二三四五', NULL, 1, NULL, 0, NULL, 'whatever', NULL, 'test@test.com', '2008-11-20 14:20:20.110', NULL)
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract_adapter.rb:188:in `log'
./lib/active_record/connection_adapters/sqlserver_adapter.rb:615:in `raw_execute'
./lib/active_record/connection_adapters/sqlserver_adapter.rb:287:in `execute_without_query_record'
../../../rails/activerecord/test/cases/helper.rb:39:in `execute'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/database_statements.rb:171:in `insert_sql'
./lib/active_record/connection_adapters/sqlserver_adapter.rb:605:in `insert_sql'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/database_statements.rb:44:in `insert_without_query_dirty'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/query_cache.rb:18:in `insert'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:2747:in `create_without_callbacks'
../../../rails/activerecord/test/cases/../../lib/active_record/callbacks.rb:237:in `create_without_timestamps'
../../../rails/activerecord/test/cases/../../lib/active_record/timestamp.rb:29:in `create'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:2713:in `create_or_update_without_callbacks'
../../../rails/activerecord/test/cases/../../lib/active_record/callbacks.rb:222:in `create_or_update'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:2397:in `save_without_validation'
../../../rails/activerecord/test/cases/../../lib/active_record/validations.rb:1009:in `save_without_dirty'
../../../rails/activerecord/test/cases/../../lib/active_record/dirty.rb:79:in `save_without_transactions'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:179:in `send'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:179:in `with_transaction_returning_status'
../../../rails/activerecord/test/cases/../../lib/active_record/connection_adapters/abstract/database_statements.rb:66:in `transaction'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:129:in `transaction'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:138:in `transaction'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:178:in `with_transaction_returning_status'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:146:in `save'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:158:in `rollback_active_record_state!'
../../../rails/activerecord/test/cases/../../lib/active_record/transactions.rb:146:in `save'
../../../rails/activerecord/test/cases/../../lib/active_record/base.rb:697:in `create'
../../../rails/activerecord/test/cases/validations_test.rb:980:in `test_validates_length_of_using_minimum_utf8'
../../../rails/activerecord/test/cases/validations_test.rb:1403:in `with_kcode'
../../../rails/activerecord/test/cases/validations_test.rb:977:in `test_validates_length_of_using_minimum_utf8'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:96:in `__send__'
../../../rails/activerecord/test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:96:in `run'
1857 tests, 6953 assertions, 2 failures, 8 errors
rake aborted!
Command failed with status (1): [/usr/bin/ruby1.8 -Ilib:test:test/connectio...]
(See full trace by running task with --trace)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment