| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429 |
- v6.0.0 (2019-0?-??)
- -------------------
- [new] Added `healthy` flag to the pool to help determine if the pool is safe to use or not ([#816](https://github.com/tediousjs/node-mssql/pull/816))
- [new] Invalid isolation levels passed to transactions will now throw an error
- [new] Duplicate parameter names in queries/stored procedures will now throw an error
- [new] `replaceInput` and `replaceOutput` functions added to `Request` and `PreparedStatement` to facilitate replacing existing parameters
- [new] Calls to the global `connect` function will return the global connection if it exists
- [new] Bulk table inserts now attempt to coerce Date objects out of non Date values
- [change] Closing the global connection by reference will now cleanup the internally managed globalConnection
- [change] Upgraded tedious to v6 ([#818](https://github.com/tediousjs/node-mssql/pull/818))
- [change] Remove references to deprecated `TYPES.Null` from tedious
- [change] `options.encrypt` is now set to true by default
- [change] Upgraded `debug` dependency to v4
- [change] Config objects are cloned so that the original object is not modified
- [change] Replaced pool library (`generic-pool`) with `tarn.js` ([#808](https://github.com/tediousjs/node-mssql/pull/808))
- [removed] Backoff try strategy for creating connections removed, `tarn.js` built-in retry strategy used instead
- v5.0.2 (2019-03-09)
- -------------------
- [change] Remove references to deprecated `TYPES.Null` from tedious
- v5.0.1 (2019-03-09)
- -------------------
- [change] Config objects are cloned so that the original object is not modified
- v5.0.0 (2019-03-07)
- -------------------
- [new] Added pause / resume feature to streamed requests ([#775](https://github.com/tediousjs/node-mssql/pull/775))
- [new] Added options argument to bulk requests for compatibility with tedious driver
- [new] Added a backoff retry strategy for failed connection creation to mitigate issue with `generic-pool` connection creation logic ([#806](https://github.com/tediousjs/node-mssql/pull/806)
- [change] Updated to latest Tedious 4.1.1
- [removed] Node.js < 6 is no longer supported
- [removed] Support dropped for deprecated tedious configuration values and types
- v4.3.5 (2019-03-09)
- -------------------
- [change] Remove references to deprecated `TYPES.Null` from tedious
- v4.3.4 (2019-03-09)
- -------------------
- [change] Config objects are cloned so that the original object is not modified
- v4.3.3 (2019-03-07)
- -------------------
- [change] Updated to latest generic-pool 3.6.1
- v4.3.0 (2018-11-20)
- -------------------
- [new] Add beforeConnect handler
- [change] Interpret connection timeout in seconds (not milliseconds)
- v4.2.3 (2018-11-03)
- -------------------
- [new] Add info event for execute function
- [fix] Fix JSON parsing with empty recordsets
- [new] Array / string literal template query preparation fixes
- [new] Passing encrypt option from mssql connection options to tedious options
- [change] Return the _poolDestroy promise before connecting again
- v4.2.2 (2018-10-17)
- -------------------
- [change] Updated to latest Tedious 2.7.1
- v4.2.1 (2018-08-05)
- -------------------
- [fix] Fix connections in the pool depleting due to unfulfilled Promises and timeouts
- [change] Updated to latest Tedious 2.6.4
- v4.2.0 (2018-07-05)
- -------------------
- [new] Added TVP support for msnodesqlv8 driver
- [new] Added support for information messages in msnodesqlv8 driver
- [new] Added support for request cancellation in msnodesqlv8 driver
- [fix] Fixed Tedious deprecation warnings
- [fix] Fixed ResourceRequest timed out error
- [fix] All query and batch methods now have the same interface
- [fix] Fixed msnodesqlv8 issue where the encrypt option was getting ignored
- [change] Updated to latest Tedious 2.3.1
- v4.1.0 (2017-09-29)
- -------------------
- [new] Adding support for the MultiSubnetFailover option in connection strings (Paul Kehrer)
- [new] Add request timeout support for msnodesqlv8 queries (Michael Parque)
- [fix] Fix type inference of non-integer numbers (Andrew Crites)
- [fix] Set acquireTimeout on generic pool (Karl Wiggisser)
- v4.0.4 (2017-04-25)
- -------------------
- [fix] Fix auto-closing of idle connections
- v4.0.3 (2017-04-25)
- -------------------
- [fix] Fixed broken CLI & debugging
- v4.0.2 (2017-04-19)
- -------------------
- [fix] Fixed broken JSON parser
- v4.0.1 (2017-04-02)
- -------------------
- [fix] Fixed stream in pipe mode
- v4.0.0 (2017-04-01)
- -------------------
- [new] Completly rewritten to ES6
- [new] Library is now compatible with Webpack
- [new] Library is ready for async/await
- [change] Removed support for < Node.js 4
- [change] Removed support for outdated node-tds and msnodesql drivers
- [change] Removed require('mssql/nofix') syntax
- [change] Removed verbose and debug mode
- [change] Removed 'driver' from options
- [change] Removed Transaction and Prepared Statement queues
- [change] Removed 'multiple' directive
- [change] Connection renamed to ConnectionPool
- [change] Updated to latest Tedious 2.0.0
- v3.3.0 (2016-05-06)
- -------------------
- [new] Added support for receiving informational messages
- [new] Added JSON support for msnodesql and msnodesqlv8 drivers
- [fix] Minor fixes in connection string parsing
- v3.2.1 (2016-04-16)
- -------------------
- [fix] Added PreparedStatement.lastRequest to access internal Request when using Promises
- v3.2.0 (2016-04-11)
- -------------------
- [new] Added experimental support for ES6 tagged template literals
- [new] Added support for Variant data type
- [change] Updated to latest Tedious 1.14.0
- v3.1.2 (2016-03-08)
- -------------------
- [fix] Correctly release connection after transaction error
- v3.1.1 (2016-02-21)
- -------------------
- [change] Minor internal changes because of connect-mssql module
- v3.1.0 (2016-02-13)
- -------------------
- [new] Added support for creating columns with primary keys in TVP Tables
- v3.0.1 (2016-02-04)
- -------------------
- [fix] Fix error causing app to crash when parsing json/xml from stored procedure
- [fix] Correctly check connection health after socket error
- v3.0.0 (2016-01-08)
- -------------------
- [new] Version bump because of breakinch change introduced in release 2.6
- v2.6.2 (2015-12-25) - unpublished from npm
- -------------------
- [new] Added support for receiving number of affected rows
- [new] Automatically concat chunks of FOR XML / FOR JSON recordset
- [fix] Correctly preserve domains
- v2.5.0 (2015-12-17)
- -------------------
- [new] Added support for new TDS driver msnodesqlv8
- [new] Support for configs formated as Connection String, Connection String URI
- v2.4.0 (2015-12-11)
- -------------------
- [new] Connection.connect, PreparedStatement.prepare and Transaction.begin now returns instance of itself as a first argument to Promise resolver.
- [fix] Correctly handle Socket Errors inside Requests (Jørgen Elgaard Larsen)
- v2.3.2 (2015-11-11)
- -------------------
- [change] Updated to latest Tedious 1.13.1
- v2.3.1 (2015-09-21)
- -------------------
- [fix] JSON fixes
- v2.3.0 (2015-09-20)
- -------------------
- [new] Experimental JSON support
- v2.2.1 (2015-09-19)
- -------------------
- [change] Updated to latest Tedious 1.12.3
- [fix] Promise not returns rowCount in bulk load (Ben Farr)
- v2.2.0 (2015-08-17)
- -------------------
- [new] Added column metadata identity, caseSensitive and readOnly (nino-porcino)
- v2.1.8 (2015-08-11)
- -------------------
- [change] Updated to latest Tedious 1.12.2
- v2.1.7 (2015-08-09)
- -------------------
- [change] Updated to latest Tedious 1.11.4
- v2.1.6 (2015-06-17)
- -------------------
- [change] Updated to latest Tedious 1.11.2
- v2.1.5 (2015-06-05)
- -------------------
- [fix] Correctly resolve database and schema name from table path.
- v2.1.4 (2015-06-05)
- -------------------
- [new] Better test coverage, automated integration tests.
- [fix] msnodesql: Manual transaction aborting.
- [fix] msnodesql: Tests.
- v2.1.3 (2015-05-03)
- -------------------
- [fix] msnodesql: Release connection to pool on query error (Farhan Khan)
- v2.1.2 (2015-03-28)
- -------------------
- [fix] Fix name parsing in Table constructor (David Mercer)
- v2.1.1 (2015-02-25)
- -------------------
- [fix] Fix Promise in Prepared Statement
- v2.1.0 (2015-02-20)
- -------------------
- [new] Detailed SQL errors
- [fix] Precise detection of column data types
- v2.0.0 (2015-02-17)
- -------------------
- [change] Updated to latest Tedious 1.10.0
- [new] Promises
- [new] Pipe request to object stream
- [new] Integrated type checks
- [new] CLI
- [fix] Transaction Abort Handling
- [fix] Allow rollback on transaction with queued requests
- [fix] Connection pool fixes
- [fix] Minor fixes
- v1.3.0 (2014-10-27)
- -------------------
- [change] Updated to latest Tedious 1.7.0
- [new] Tedious: Char and NChar types are now available as input parameters
- v1.2.1 (2014-10-07)
- -------------------
- [change] Updated to latest Tedious 1.5.3
- v1.2.0 (2014-08-26)
- -------------------
- [change] Updated to latest Tedious 1.4.0
- [new] Added support for bulk insert.
- v1.1.1 (2014-08-07)
- -------------------
- [new] Added column index to recordset metadata.
- [fix] Minor fixes in Tedious driver
- v1.1.0 (2014-07-13)
- -------------------
- [change] Updated to latest Tedious 1.1.0
- [new] Added support for domain logins (NTLM)
- v1.0.2 (2014-07-04)
- -------------------
- [new] Added support for input and output parameters in batch method.
- [new] Added checks for SQL injection in parameter names
- v1.0.1 (2014-07-04)
- -------------------
- [new] Added support for Streaming in Prepared Statements
- v1.0.0 (2014-07-04)
- -------------------
- [new] Start of semantic versioning, and commitment to stable API until 2.0.0
- v0.6.2 (2014-07-04)
- -------------------
- [new] Added batch() method to execute sql commands like "create procedure"
- [new] Cancel request in node-tds driver
- [fix] Fixed VarChar/NVarChar/VarBinary MAX in prepared statements
- v0.6.1 (2014-07-04)
- -------------------
- [change] TDS debugging simplified
- v0.6.0 (2014-07-03)
- -------------------
- [change] Updated to latest Tedious 1.0.0
- [new] Added support for Streaming
- [new] Added option to set request timeout (config.requestTimeout = 15000)
- [new] Errors documented
- [change] Connection timeout renamed from config.timeout to config.connectionTimeout
- [fix] Minor bug fixes
- v0.5.5 (2014-06-24)
- -------------------
- [fix] Failed login left open connection pool
- v0.5.4 (2014-06-15)
- -------------------
- [new] Multiple errors handling
- v0.5.3 (2014-04-04)
- -------------------
- [fix] Multiple recordsets in Prepared Statements
- v0.5.2 (2014-04-04)
- -------------------
- [new] Support for Prepared Statements
- [fix] Fixed order of output parameters
- [fix] Minor fixes in node-tds driver
- v0.5.1 (2014-04-01)
- -------------------
- [change] Updated to new Tedious 0.2.1
- [new] You can now easily setup type's length/scale (sql.VarChar(50))
- [new] Serialization of Geography and Geometry CLR types
- [new] Support for creating Table-Value Parameters (var tvp = new sql.Table())
- [new] Output parameters are now Input-Output and can handle initial value
- [new] Option to choose whether to pass/receive times in UTC or local time
- [new] Connecting to named instances simplified
- [change] Default SQL data type for JS String type is now NVarChar (was VarChar)
- v0.5.0 (2014-01-25)
- -------------------
- [new] You can now attach event listeners to Connection (connect, close), Transaction (begin, commit, rollback) and Request (row, recordset, done)
- [new] You can now set length of Char, NChar and Binary output parameters
- [new] You can now change default transaction isolation level
- [change] Errors are now splitted to three categories for better error handling - ConnectionError, TransactionError, ReqestError
- [new] Tedious: Binary and VarBinary types are now available as input and output parameters
- [new] Tedious: Image type is now available as input parameter
- [change] Tedious: Binary, VarBinary and Image types are now returned as buffer (was byte array)
- [change] Tedious: Transaction isolationLevel default is now READ_COMMITED (was READ_UNCOMMITED)
- [fix] Tedious: Fixed issue when zero value was casted as null when using BigInt as input parameter
- [fix] Tedious: Fixed issue when dates before 1900/01/01 in input parameters resulted in "Out of bounds" error
- [new] node-tds: UniqueIdentifier type in now available as input and output parameter
- [fix] node-tds: UniqueIdentifier type is now parsed correctly as string value (was buffer)
- [fix] node-tds: Text, NText, Char, NChar, VarChar and NVarChar input parameters has correct lengths
- [fix] node-tds: Fixed Error messages
- [fix] Msnodesql: Char, NChar, Xml, Text, NText and VarBinary types are now correctly functional as output parameters
- v0.4.5 (2014-01-23)
- -------------------
- [new] Added support for "co" flow controller via co-mssql module
- v0.4.4 (2014-01-22)
- -------------------
- [change] returnValue also accessible as property of recordsets
- v0.4.3 (2014-01-14)
- -------------------
- [fix] Even better network error handling in tedious
- [new] Module is compatible with Node.js 0.11
- v0.4.2 (2014-01-06)
- -------------------
- [new] Added connection timeout for node-tds
- [fix] Module now handle tedious network errors correctly
- [fix] Connection pool now destroy failed connections correctly
- [fix] Connection to instance name via tedious now works correctly
- [change] Option 'timeout' is now common option for all drivers (see documentation)
- v0.4.1 (2013-12-13)
- -------------------
- [fix] Filter empty recordsets when NOCOUNT is OFF
- v0.4.0 (2013-12-12)
- -------------------
- [new] Added support for transactions.
- [new] node-tds is now available as an optional TDS driver.
- [new] Documentation updated to CSDoc spec.
- [change] Tedious driver no longer use tedious-connection-pool for connection pooling
- [change] Msnodesql is now pooled
- v0.3.4 (2013-10-23)
- -------------------
- [new] Queries with input and output parameters.
- v0.3.3 (2013-10-23)
- -------------------
- [new] Test connection when tedious pool is created.
- v0.3.2 (2013-09-30)
- -------------------
- [new] Added support for multiple connections.
- v0.3.1 (2013-09-13)
- -------------------
- [fix] NaN values of input parameters are automatically converted to null.
- v0.3.0 (2013-09-08)
- -------------------
- [new] Documentation extended
- [new] Microsoft Driver for Node.js for SQL Server is now available as an optional TDS driver.
- [new] Metadata are now accesible trough recordset.columns property.
- [new] Support for multiple recordsets in query.
- [fix] SQL null values are now correctly casted as JS null.
- [change] Default SQL data type for JS Number is now sql.Int (was sql.BigInt).
- v0.2.5 (2013-09-05)
- -------------------
- [fix] Multiple columns with identical name in same recordset are now handled correctly.
- v0.2.4 (2013-08-15)
- -------------------
- [fix] Errors are now instance of Error.
- [fix] Empty recordsets fixed.
- v0.2.3 (2013-08-14)
- -------------------
- [new] Verbose mode for query.
- v0.2.2 (2013-08-11)
- -------------------
- [new] Verbose mode for stored procedure.
- [fix] Null values fixed.
- v0.2.0 (2013-08-10)
- -------------------
- [change] Project was renamed from xsp-mssql to node-mssql.
- [fix] Some minor bug fixes.
- v0.1.0 (2013-07-10)
- -------------------
- Initial release.
|