Skip to content

Instantly share code, notes, and snippets.

@metaskills
Created April 24, 2011 23:53
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 metaskills/939990 to your computer and use it in GitHub Desktop.
Save metaskills/939990 to your computer and use it in GitHub Desktop.
1) Error:
test_validate_case_insensitive_uniqueness(UniquenessValidationTest):
ActiveRecord::StatementInvalid: TinyTds::Error: Expression type int is invalid for COLLATE clause.: SELECT TOP (1) 1 FROM [topics] WHERE [topics].[parent_id] = 2 COLLATE Latin1_General_CS_AS_WS
/Users/kencollins/Repositories/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:345:in `each'
/Users/kencollins/Repositories/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:345:in `handle_to_names_and_values_dblib'
/Users/kencollins/Repositories/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:331:in `handle_to_names_and_values'
/Users/kencollins/Repositories/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:298:in `block in raw_select'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:222:in `block in log'
/Users/kencollins/Repositories/rails/activesupport/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:217:in `log'
/Users/kencollins/Repositories/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:295:in `raw_select'
/Users/kencollins/Repositories/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:25:in `exec_query'
/Users/kencollins/Repositories/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:213:in `select'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:10:in `select_all'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:54:in `select_all'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:23:in `select_one'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:29:in `select_value'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/relation/finder_methods.rb:197:in `exists?'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/validations/uniqueness.rb:33:in `validate_each'
/Users/kencollins/Repositories/rails/activemodel/lib/active_model/validator.rb:153:in `block in validate'
/Users/kencollins/Repositories/rails/activemodel/lib/active_model/validator.rb:150:in `each'
/Users/kencollins/Repositories/rails/activemodel/lib/active_model/validator.rb:150:in `validate'
/Users/kencollins/Repositories/rails/activesupport/lib/active_support/callbacks.rb:302:in `_callback_before_6073'
/Users/kencollins/Repositories/rails/activesupport/lib/active_support/callbacks.rb:395:in `_run_validate_callbacks'
/Users/kencollins/Repositories/rails/activesupport/lib/active_support/callbacks.rb:81:in `run_callbacks'
/Users/kencollins/Repositories/rails/activemodel/lib/active_model/validations.rb:212:in `run_validations!'
/Users/kencollins/Repositories/rails/activemodel/lib/active_model/validations/callbacks.rb:53:in `block in run_validations!'
/Users/kencollins/Repositories/rails/activesupport/lib/active_support/callbacks.rb:399:in `_run_validation_callbacks'
/Users/kencollins/Repositories/rails/activesupport/lib/active_support/callbacks.rb:81:in `run_callbacks'
/Users/kencollins/Repositories/rails/activemodel/lib/active_model/validations/callbacks.rb:53:in `run_validations!'
/Users/kencollins/Repositories/rails/activemodel/lib/active_model/validations.rb:179:in `valid?'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/validations.rb:69:in `valid?'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/validations.rb:77:in `perform_validations'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/validations.rb:50:in `save'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/attribute_methods/dirty.rb:22:in `save'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/transactions.rb:241:in `block (2 levels) in save'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/transactions.rb:295:in `block in with_transaction_returning_status'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:177:in `transaction'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/transactions.rb:208:in `transaction'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/transactions.rb:293:in `with_transaction_returning_status'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/transactions.rb:241:in `block in save'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/transactions.rb:252:in `rollback_active_record_state!'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/transactions.rb:240:in `save'
/Users/kencollins/Repositories/rails/activerecord/test/cases/validations/uniqueness_validation_test.rb:126:in `test_validate_case_insensitive_uniqueness'
/Users/kencollins/.rvm/gems/ruby-1.9.2-p180@sqlserver/gems/mocha-0.9.8/lib/mocha/integration/mini_test/version_131_and_above.rb:26:in `run'
/Users/kencollins/Repositories/rails/activesupport/lib/active_support/testing/setup_and_teardown.rb:35:in `block in run'
/Users/kencollins/Repositories/rails/activesupport/lib/active_support/callbacks.rb:408:in `_run_setup_callbacks'
/Users/kencollins/Repositories/rails/activesupport/lib/active_support/callbacks.rb:81:in `run_callbacks'
/Users/kencollins/Repositories/rails/activesupport/lib/active_support/testing/setup_and_teardown.rb:34:in `run'
2) Error:
test_validate_uniqueness_with_non_standard_table_names(UniquenessValidationTest):
ActiveRecord::StatementInvalid: TinyTds::Error: Expression type int is invalid for COLLATE clause.: SELECT TOP (1) 1 FROM [warehouse-things] WHERE [warehouse-things].[value] = 1000 COLLATE Latin1_General_CS_AS_WS
/Users/kencollins/Repositories/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:345:in `each'
/Users/kencollins/Repositories/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:345:in `handle_to_names_and_values_dblib'
/Users/kencollins/Repositories/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:331:in `handle_to_names_and_values'
/Users/kencollins/Repositories/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:298:in `block in raw_select'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:222:in `block in log'
/Users/kencollins/Repositories/rails/activesupport/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:217:in `log'
/Users/kencollins/Repositories/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:295:in `raw_select'
/Users/kencollins/Repositories/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:25:in `exec_query'
/Users/kencollins/Repositories/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:213:in `select'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:10:in `select_all'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:54:in `select_all'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:23:in `select_one'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:29:in `select_value'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/relation/finder_methods.rb:197:in `exists?'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/validations/uniqueness.rb:33:in `validate_each'
/Users/kencollins/Repositories/rails/activemodel/lib/active_model/validator.rb:153:in `block in validate'
/Users/kencollins/Repositories/rails/activemodel/lib/active_model/validator.rb:150:in `each'
/Users/kencollins/Repositories/rails/activemodel/lib/active_model/validator.rb:150:in `validate'
/Users/kencollins/Repositories/rails/activesupport/lib/active_support/callbacks.rb:302:in `_callback_before_5095'
/Users/kencollins/Repositories/rails/activesupport/lib/active_support/callbacks.rb:395:in `_run_validate_callbacks'
/Users/kencollins/Repositories/rails/activesupport/lib/active_support/callbacks.rb:81:in `run_callbacks'
/Users/kencollins/Repositories/rails/activemodel/lib/active_model/validations.rb:212:in `run_validations!'
/Users/kencollins/Repositories/rails/activemodel/lib/active_model/validations/callbacks.rb:53:in `block in run_validations!'
/Users/kencollins/Repositories/rails/activesupport/lib/active_support/callbacks.rb:390:in `_run_validation_callbacks'
/Users/kencollins/Repositories/rails/activesupport/lib/active_support/callbacks.rb:81:in `run_callbacks'
/Users/kencollins/Repositories/rails/activemodel/lib/active_model/validations/callbacks.rb:53:in `run_validations!'
/Users/kencollins/Repositories/rails/activemodel/lib/active_model/validations.rb:179:in `valid?'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/validations.rb:69:in `valid?'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/validations.rb:77:in `perform_validations'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/validations.rb:50:in `save'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/attribute_methods/dirty.rb:22:in `save'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/transactions.rb:241:in `block (2 levels) in save'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/transactions.rb:295:in `block in with_transaction_returning_status'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:177:in `transaction'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/transactions.rb:208:in `transaction'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/transactions.rb:293:in `with_transaction_returning_status'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/transactions.rb:241:in `block in save'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/transactions.rb:252:in `rollback_active_record_state!'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/transactions.rb:240:in `save'
/Users/kencollins/Repositories/rails/activerecord/lib/active_record/base.rb:500:in `create'
/Users/kencollins/Repositories/rails/activerecord/test/cases/validations/uniqueness_validation_test.rb:199:in `test_validate_uniqueness_with_non_standard_table_names'
/Users/kencollins/.rvm/gems/ruby-1.9.2-p180@sqlserver/gems/mocha-0.9.8/lib/mocha/integration/mini_test/version_131_and_above.rb:26:in `run'
/Users/kencollins/Repositories/rails/activesupport/lib/active_support/testing/setup_and_teardown.rb:35:in `block in run'
/Users/kencollins/Repositories/rails/activesupport/lib/active_support/callbacks.rb:408:in `_run_setup_callbacks'
/Users/kencollins/Repositories/rails/activesupport/lib/active_support/callbacks.rb:81:in `run_callbacks'
/Users/kencollins/Repositories/rails/activesupport/lib/active_support/testing/setup_and_teardown.rb:34:in `run'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment