diff options
| author | Joseph Palermo <pair+jpalermo@pivotallabs.com> | 2011-10-09 04:38:36 -0700 |
|---|---|---|
| committer | Jeremy Kemper <jeremy@bitsweat.net> | 2011-10-09 13:14:07 -0700 |
| commit | c90e5ce779dbf9bd0ee53b68aee9fde2997be123 (patch) | |
| tree | 669dc5ffd58bce787a1aeb89c38d53b13a9bea28 /activerecord/test/schema | |
| parent | 8f8fd4f3aacf252aa0330798590988cc5fe39ba7 (diff) | |
| download | rails-c90e5ce779dbf9bd0ee53b68aee9fde2997be123.tar.gz rails-c90e5ce779dbf9bd0ee53b68aee9fde2997be123.tar.bz2 rails-c90e5ce779dbf9bd0ee53b68aee9fde2997be123.zip | |
Only use LOWER for mysql case insensitive uniqueness check when column has a case sensitive collation.
Diffstat (limited to 'activerecord/test/schema')
| -rw-r--r-- | activerecord/test/schema/mysql2_specific_schema.rb | 13 | ||||
| -rw-r--r-- | activerecord/test/schema/mysql_specific_schema.rb | 11 |
2 files changed, 23 insertions, 1 deletions
diff --git a/activerecord/test/schema/mysql2_specific_schema.rb b/activerecord/test/schema/mysql2_specific_schema.rb index c78d99f4af..ab2c7ccc10 100644 --- a/activerecord/test/schema/mysql2_specific_schema.rb +++ b/activerecord/test/schema/mysql2_specific_schema.rb @@ -21,4 +21,15 @@ BEGIN END SQL -end + ActiveRecord::Base.connection.execute <<-SQL +DROP TABLE IF EXISTS collation_tests; +SQL + + ActiveRecord::Base.connection.execute <<-SQL +CREATE TABLE collation_tests ( + string_cs_column VARCHAR(1) COLLATE utf8_bin, + string_ci_column VARCHAR(1) COLLATE utf8_general_ci +) CHARACTER SET utf8 COLLATE utf8_general_ci +SQL + +end
\ No newline at end of file diff --git a/activerecord/test/schema/mysql_specific_schema.rb b/activerecord/test/schema/mysql_specific_schema.rb index 30e1c5a167..a0adfe3752 100644 --- a/activerecord/test/schema/mysql_specific_schema.rb +++ b/activerecord/test/schema/mysql_specific_schema.rb @@ -32,4 +32,15 @@ BEGIN END SQL + ActiveRecord::Base.connection.execute <<-SQL +DROP TABLE IF EXISTS collation_tests; +SQL + + ActiveRecord::Base.connection.execute <<-SQL +CREATE TABLE collation_tests ( + string_cs_column VARCHAR(1) COLLATE utf8_bin, + string_ci_column VARCHAR(1) COLLATE utf8_general_ci +) CHARACTER SET utf8 COLLATE utf8_general_ci +SQL + end |