From 6e167d38e25186419ef26e9755ba6f4e3f709722 Mon Sep 17 00:00:00 2001 From: Andrew White Date: Wed, 2 Nov 2016 16:49:18 +0000 Subject: Fix raising uniqueness constraints in newer versions of SQLite Versions 3.8.2 and later of SQLite changed the formatting of the error messages returned when a uniqueness constraint was violated. --- .../lib/active_record/connection_adapters/sqlite_adapter.rb | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb b/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb index 455560aa55..f3a47ba80a 100644 --- a/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb +++ b/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb @@ -571,7 +571,11 @@ module ActiveRecord def translate_exception(exception, message) case exception.message - when /column(s)? .* (is|are) not unique/ + # SQLite 3.8.2 returns a newly formatted error message: + # UNIQUE constraint failed: *table_name*.*column_name* + # Older versions of SQLite return: + # column *column_name* is not unique + when /column(s)? .* (is|are) not unique/, /UNIQUE constraint failed: .*/ RecordNotUnique.new(message, exception) else super -- cgit v1.2.3