Issues running on MSSQL

[janpieterz]

We have noticed two issues so far:

activerecord-7.2.2.1/lib/active_record/insert_all.rb:179:in `ensure_valid_options_for_connection!': ActiveRecord::ConnectionAdapters::SQLServerAdapter does not support skipping duplicates (ArgumentError)

SolidQueue-1.1.2 Error in thread (0.0ms)  error: "ActiveRecord::StatementInvalid TinyTds::Error: ORDER BY items must appear in the select list if SELECT DISTINCT is specified

Happy to investigate at least an attempt to fix some of these. Would there be interest in merging in support?

[rosa]

Hey @janpieterz, MSSQL is not supported at the moment. and support for it is not planned, as it's not officially supported by Rails. However, I'd be happy to review a PR that addresses all problems, given that it's not overly complicated or affects the existing implementation for the other adapters.