mssql_ecto
mssql_ecto copied to clipboard
findmypast-oss
Ecto adapter for Mssqlex
I would love to see support for the native MS-SQL `uniqueidentifier` datatype. ## Expected Behavior Mapping `:binary_id` to `uniqueidentifier` ## Current Behavior Currently data returned with a `uniqueidentifier` datatype raises...
### Problem: When a database table has a trigger attached to it, `insert/1` will fail because the adapter is not utilizing an `INTO` clause. This blog post from the SQL...
## Description An early beta version of the mssql_ecto migration to Ecto 3. This pull request should wait until the relevant mssqlex [pull request](https://github.com/findmypast-oss/mssqlex/pull/24) is complete and the dependencies in...
## Expected Behavior Prefixing one table with a `schema_prefix` should not affect any of its associated schemas. ## Current Behavior When prefixing a table with a non-default schema name, its...
Cannot run tests after swapping postgres to MS SQL. ## Expected Behavior Tests should run without issue. ## Current Behavior Tests are failing, saying: ``` 18:42:34.953 [error] GenServer #PID terminating...
## Expected Behavior Text types defined in a migration should be able to store strings of a length greater than 4000. ## Current Behavior When data of greater than length...
## Description This sql cannot execute in sqlserver 2008 `exec sp_executesql N'SELECT TOP @P1 a0."email" FROM "accounts" ORDER BY a0."id"',N'@P1 int',1`
## Expected Behavior Removing a column should remove only the column. If the removed column _is_ primary key, only then the constraint should be deleted. ## Current Behavior Migration that...
## Expected Behavior I'm using SQL Server 2016 Express, set to `SQL_Latin1_General_CP1_CI_AS` collation. When I save data on columns set to `nvarchar(max)` on SQL Server's side, they're properly saved, but...
