ActiveRecord::ConnectionAdapters::SQLServerAdapter does not support upsert

[felzend]

Issue

Trying to use an upsert operation on my model, but it's showing an error telling this adapter has no implementation for that.

Expected behavior

Upsert operation working with no exceptions.

Actual behavior

Throwing an exception:

ActiveRecord::ConnectionAdapters::SQLServerAdapter does not support upsert

raise ArgumentError, "#{connection.class} does not support upsert"

How to reproduce

Simply calling

Details

• Rails version: 7.0.4.3
• SQL Server adapter version: 7.0.1.0
• TinyTDS version: 2.1.5
• FreeTDS details:

SQL SERVER 16.0.4003.1 - Developer Edition

[aidanharan]

The adapter doesn't support upsert as Microsoft SQL Server doesn't natively support it either. There were investigations in #859 to see if upsert could be supported using MERGE but they have been unsuccessful.

[Michoels]

Is there no way to implement this in SQL Server?

upsert is a valuable feature and is required for supporting Solid Cache (See #1122)