spec/adapters/sqlite_spec.rb in sequel-4.4.0 vs spec/adapters/sqlite_spec.rb in sequel-4.5.0

@@ -638,6 +638,13 @@
     proc {@db.transaction_mode = :invalid}.should raise_error(Sequel::Error)
 
     @db.transaction_mode.should == :immediate
     proc {@db.transaction(:mode => :invalid) {}}.should raise_error(Sequel::Error)
   end
+
+  specify "should keep unique constraints when copying tables" do
+    @db.alter_table(:test2){add_unique_constraint :name}
+    @db.alter_table(:test2){drop_column :value}
+    @db[:test2].insert(:name=>'a')
+    proc{@db[:test2].insert(:name=>'a')}.should raise_error(Sequel::ConstraintViolation)
+  end
 end