package mssql

2.2.0 (2021-02-24)

Fixed

• Row.datetime and Row.datetime_exn now work correctly for the DATETIME2 type
• Queries should be slightly less likely to return errors due to previous queries not being cleaned up properly.

2.1.0 (2020-05-12)

Fixed

• Fix execute_pipe's exception handling. Previously, exceptions could cause the pipe to close and appear to finish successfully. Now, the pipe will be left open and an exception will be thrown.
• Correctly parser SQL queries containing single quotes in comments. Previously, a $ parameter surrounded by comments containing quotes could fail to be replaced and would be treated as a literal currency value.
• Fix hang if execute_map's ~f throws an exception. This caused caused by f being executed in a different Async context, so the exception wouldn't be caught by the correct context.
• Ensure result sets can't be skipped when using execute_pipe. This makes us finish reading the previous result set before continuing to the next one.
• Cancel query results immediately after an exception instead of waiting for the next query. This can prevent holding onto resources for an excessive amount of time.

2.0.3 (2020-05-08)

Fixed

• Fixed test build when using Core v0.13

2.0.2 (2020-05-07)

Fixed

• Add missing odoc dependency
• Skip tests if environment variables are not set

2.0.1 (2020-05-06)

Fixed

• Don't build the test folder in release mode (only when running tests)

2.0 (2020-05-06)

Added

• Streaming execute_ helpers: execute_map, execute_iter, execute_fold, and execute_pipe.
• Param.Array now supports lists, which is useful for IN ($1) clauses.

Changed

• Make connect's port argument optional
• Support Core v0.13
• Result sets that don't contain row data aren't returned. For example, INSERT ...; SELECT ... now returns one result set instead of two.

Fixed

• Correctly use port when provided

• Various upstream fixes in ocaml-freetds

  • Exceptions shouldn't break the connection handle
  • Runtime lock released during queries
• Logging always occurs in an Async context
• Logging occurs in the same Async context as the caller and not a random one
• We depend on Async_extra

Removed

• Mssql.Test. This module was for testing and shouldn't have been part of the public API. We recommend adding a module like this to your own code if you want it.
• Semi-broken connection pool (Mssql.Pool) removed. Doing this safely requires setting the RESETCONNECTION bit, which doesn't seem to be possible in FreeTDS.

1.1 (2019-01-29)

• Switch build command from jbuilder to dune

1.0 (2019-01-28)

Initial release