This project is archived and is in readonly mode.
Error in UniquenessValidationTest

#3721
Only on running test_postgresql
  1) Error:
test_validate_uniqueness_with_limit_and_utf8(UniquenessValidationTest):
ActiveRecord::StatementInvalid: PGError: ERROR:  value too long for type character varying(5)
: INSERT INTO "events" ("title") VALUES (E'一二三四五') RETURNING "id"
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:206:in `rescue in log'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:196:in `log'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:552:in `execute'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/test/cases/helper.rb:42:in `execute_with_query_record'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:1036:in `select_raw'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:1023:in `select'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:62:in `select_all_with_query_cache'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:13:in `select_one'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:19:in `select_value'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:491:in `insert'
    /Users/andhapp/Projects/git-repository/andhapp-rails/vendor/gems/ruby/1.9.1/dirs/arel/lib/arel/engines/sql/engine.rb:18:in `create'
    /Users/andhapp/Projects/git-repository/andhapp-rails/vendor/gems/ruby/1.9.1/dirs/arel/lib/arel/algebra/relations/writes.rb:20:in `call'
    /Users/andhapp/Projects/git-repository/andhapp-rails/vendor/gems/ruby/1.9.1/dirs/arel/lib/arel/session.rb:32:in `create'
    /Users/andhapp/Projects/git-repository/andhapp-rails/vendor/gems/ruby/1.9.1/dirs/arel/lib/arel/algebra/relations/relation.rb:64:in `insert'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/relation.rb:159:in `method_missing'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/base.rb:2498:in `create'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/timestamp.rb:55:in `create_with_timestamps'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/callbacks.rb:268:in `block in create_with_callbacks'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activesupport/lib/active_support/callbacks.rb:427:in `_run_create_callbacks'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/callbacks.rb:267:in `create_with_callbacks'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/base.rb:2474:in `create_or_update'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/callbacks.rb:261:in `block in create_or_update_with_callbacks'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activesupport/lib/active_support/callbacks.rb:427:in `_run_save_callbacks'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/callbacks.rb:260:in `create_or_update_with_callbacks'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/base.rb:2156:in `save'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/validations.rb:47:in `save_with_validation'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/attribute_methods/dirty.rb:19:in `save_with_dirty'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/transactions.rb:229:in `block in with_transaction_returning_status'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:136:in `transaction'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/transactions.rb:182:in `transaction'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/transactions.rb:228:in `with_transaction_returning_status'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/transactions.rb:196:in `block in save_with_transactions'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/transactions.rb:208:in `rollback_active_record_state!'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/transactions.rb:196:in `save_with_transactions'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/base.rb:764:in `create'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/test/cases/validations/uniqueness_validation_test.rb:248:in `block in test_validate_uniqueness_with_limit_and_utf8'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/lib/active_record/test_case.rb:60:in `with_kcode'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activerecord/test/cases/validations/uniqueness_validation_test.rb:246:in `test_validate_uniqueness_with_limit_and_utf8'
    /Users/andhapp/Projects/git-repository/andhapp-rails/vendor/gems/ruby/1.9.1/gems/mocha-0.9.8/lib/mocha/integration/mini_test/version_131_and_above.rb:26:in `run'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activesupport/lib/active_support/testing/setup_and_teardown.rb:32:in `block in run'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activesupport/lib/active_support/callbacks.rb:432:in `_run_setup_callbacks'
    /Users/andhapp/Projects/git-repository/andhapp-rails/activesupport/lib/active_support/testing/setup_and_teardown.rb:31:in `run'

2194 tests, 7648 assertions, 0 failures, 1 errors, 0 skips
Reported by Anuj Dutta · January 17th, 2010 @ 06:53 AM
Activity

Anuj Dutta
This ticket is invalid as the database must be created with utf-8 encoding. Here's the solution:
```
CREATE DATABASE activerecord_unittest template=template0 encoding='utf-8';
CREATE DATABASE activerecord_unittest2 template=template0 encoding='utf-8'; 
```
Related ticket:
https://rails.lighthouseapp.com/projects/16213-rails-guides/tickets...
January 18th, 2010 @ 11:02 AM
Rizwan Reza
- State changed from new to invalid
January 20th, 2010 @ 10:34 AM