activerecord-sqlserver-adapter
activerecord-sqlserver-adapter copied to clipboard
SQL Server Adapter For Rails
First i must say i'm not sure where exactly the error happens. Maybe it's the adapter or maybe it's ActiveRecord's serializer logic. I've encountered this error on Rails 4.2 as...
With the announcement of [`rails/solid_cache`](https://github.com/rails/solid_cache) at RailsWorld 2023, I wanted to see if it would work with activerecord-sqlserver-adapter... a few findings: ## Usage of unique index on varbinary column https://github.com/rails/solid_cache/blob/main/db/migrate/20230724121448_create_solid_cache_entries.rb#L8...
ActiveRecord::StatementInvalid (TinyTds::Error: Type DT_BooleanFalse is not a defined system type.)
## Issue I'm trying to query a DB which has some custom types, I've not seen before, one column has the type `TD_BooleanFalse`, when querying the db, the following error...
## Issue I have a Rails app which uses tables that are spread across several schemas. The main tables are in `dbo`, but some tables are in `external`, `sales`, etc....
## Issue You can't specify compatibility_level in the db config ## Expected behavior You should be able to do this ## Actual behavior If I add `compatibility_level: 130` in database.yml,...
## Issue binary(n) is loaded from schema/migrations always as binary(1) ## Expected behavior It should be created as binary(n) in the db, (e.g. binary(2), binary(8) etc) ## Actual behavior For...
## Issue When using optimizer hints, SQL Server expects the `ORDER` clause to come before the `OPTION` clause, as shown [in the official docs](https://learn.microsoft.com/en-us/sql/t-sql/queries/select-transact-sql?view=sql-server-ver16#syntax-for-sql-server-and-azure-sql-database). When combining `optimizer_hints` and any query...