1 | v6.2.0 (2020-03-13)
|
2 | -------------------
|
3 | [new] Set default isolationLevel for all transactions ([#1005](https://github.com/tediousjs/node-mssql/pull/1005))
|
4 | [new] sql.Date now is coerced into a date object ([#1007](https://github.com/tediousjs/node-mssql/pull/1007))
|
5 | [fix] Bump acorn dependency for security fix
|
6 |
|
7 | v6.1.0 (2020-02-17)
|
8 | -------------------
|
9 | [new] Add `Request.template` helper for providing templated strings to queries ([#960](https://github.com/tediousjs/node-mssql/pull/960))
|
10 | [new] Repeat calls to `ConnectionPool.connect()` resolve ([#941](https://github.com/tediousjs/node-mssql/pull/941))
|
11 | [new] Stored procedure params are now logged to debug log ([#979](https://github.com/tediousjs/node-mssql/pull/979))
|
12 | [fix] Repeat calls to `mssql.connect()` will now resolve correctly ([#986](https://github.com/tediousjs/node-mssql/pull/986))
|
13 | [fix] Connections are encrypted by default as documented ([#977](https://github.com/tediousjs/node-mssql/pull/977))
|
14 | [fix] Tagged template literal queries with empty array values now work ([#990](https://github.com/tediousjs/node-mssql/pull/990))
|
15 |
|
16 | v6.0.1 (2019-11-15)
|
17 | -------------------
|
18 | [fix] Fix an issue with connection strings where usernames have url encoded values ([#945](https://github.com/tediousjs/node-mssql/pull/945)
|
19 |
|
20 | v6.0.0 (2019-11-05)
|
21 | -------------------
|
22 | [fix] Fixed bug when trying to bulk insert columns that were `NVarChar(MAX)` ([#901](https://github.com/tediousjs/node-mssql/pull/901))
|
23 | [fix] Fixed an issue where Object prototype pollution could cause errors ([#879](https://github.com/tediousjs/node-mssql/pull/879))
|
24 | [fix] Fixed an issue where Request.input didn't validate against 0 parameters being passed ([#885](https://github.com/tediousjs/node-mssql/pull/885))
|
25 | [new] Implement pause/resume for msnodesqlv8 driver ([#877](https://github.com/tediousjs/node-mssql/pull/877))
|
26 | [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))
|
27 | [new] Invalid isolation levels passed to transactions will now throw an error
|
28 | [new] Duplicate parameter names in queries/stored procedures will now throw an error
|
29 | [new] `replaceInput` and `replaceOutput` functions added to `Request` and `PreparedStatement` to facilitate replacing existing parameters
|
30 | [new] Calls to the global `connect` function will return the global connection if it exists
|
31 | [new] Bulk table inserts now attempt to coerce Date objects out of non Date values
|
32 | [change] Closing the global connection by reference will now cleanup the internally managed globalConnection
|
33 | [change] Upgraded tedious to v6 ([#818](https://github.com/tediousjs/node-mssql/pull/818) and [#933](https://github.com/tediousjs/node-mssql/pull/933))
|
34 | [change] Upgraded msnodesqlv8 support to v0.7 ([#877](https://github.com/tediousjs/node-mssql/pull/877))
|
35 | [change] Remove references to deprecated `TYPES.Null` from tedious
|
36 | [change] `options.encrypt` is now set to true by default
|
37 | [change] Upgraded `debug` dependency to v4
|
38 | [change] Config objects are cloned so that the original object is not modified
|
39 | [change] Replaced pool library (`generic-pool`) with `tarn.js` ([#808](https://github.com/tediousjs/node-mssql/pull/808))
|
40 | [removed] Backoff try strategy for creating connections removed, `tarn.js` built-in retry strategy used instead
|
41 |
|
42 | v5.1.1 (2020-03-13)
|
43 | -------------------
|
44 | [fix] Bump acorn dependency for security fix
|
45 |
|
46 | v5.1.0 (2019-04-17)
|
47 | -------------------
|
48 | [new] Add readOnlyIntent to connection string parser ([#853](https://github.com/tediousjs/node-mssql/pull/853))
|
49 |
|
50 | v5.0.6 (2019-04-17)
|
51 | -------------------
|
52 | [fix] Ensure callbacks don't block the event loop by executing them with `setImmediate` ([#855](https://github.com/tediousjs/node-mssql/pull/855))
|
53 |
|
54 | v5.0.5 (2019-03-28)
|
55 | -------------------
|
56 | [fix] Fix an issue where connections that error can deplete the pool ([#842](https://github.com/tediousjs/node-mssql/pull/842))
|
57 |
|
58 | v5.0.4 (2019-03-27)
|
59 | -------------------
|
60 | [fix] Fix a bug where msnodesqlv8 driver could execute callbacks twice ([#834](https://github.com/tediousjs/node-mssql/pull/834))
|
61 | [fix] npm audit fix on vulnerable dependencies
|
62 |
|
63 | v5.0.3 (2019-03-13)
|
64 | -------------------
|
65 | [fix] Fix a bug with streamed requests that start paused ([#833](https://github.com/tediousjs/node-mssql/pull/833))
|
66 |
|
67 | v5.0.2 (2019-03-09)
|
68 | -------------------
|
69 | [change] Remove references to deprecated `TYPES.Null` from tedious
|
70 |
|
71 | v5.0.1 (2019-03-09)
|
72 | -------------------
|
73 | [change] Config objects are cloned so that the original object is not modified
|
74 |
|
75 | v5.0.0 (2019-03-07)
|
76 | -------------------
|
77 | [new] Added pause / resume feature to streamed requests ([#775](https://github.com/tediousjs/node-mssql/pull/775))
|
78 | [new] Added options argument to bulk requests for compatibility with tedious driver
|
79 | [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)
|
80 | [change] Updated to latest Tedious 4.1.1
|
81 | [removed] Node.js < 6 is no longer supported
|
82 | [removed] Support dropped for deprecated tedious configuration values and types
|
83 |
|
84 | v4.3.8 (2020-03-13)
|
85 | -------------------
|
86 | [fix] Bump acorn dependency for security fix
|
87 |
|
88 | v4.3.7 (2019-03-29)
|
89 | -------------------
|
90 | [fix] Fix an issue where connections that error can deplete the pool ([#842](https://github.com/tediousjs/node-mssql/pull/842))
|
91 |
|
92 | v4.3.6 (2019-03-27)
|
93 | -------------------
|
94 | [fix] Fix a bug where msnodesqlv8 driver could execute callbacks twice ([#834](https://github.com/tediousjs/node-mssql/pull/834))
|
95 | [fix] Bump js-yaml dependency for security fix
|
96 |
|
97 | v4.3.5 (2019-03-09)
|
98 | -------------------
|
99 | [change] Remove references to deprecated `TYPES.Null` from tedious
|
100 |
|
101 | v4.3.4 (2019-03-09)
|
102 | -------------------
|
103 | [change] Config objects are cloned so that the original object is not modified
|
104 |
|
105 | v4.3.3 (2019-03-07)
|
106 | -------------------
|
107 | [change] Updated to latest generic-pool 3.6.1
|
108 |
|
109 | v4.3.0 (2018-11-20)
|
110 | -------------------
|
111 | [new] Add beforeConnect handler
|
112 | [change] Interpret connection timeout in seconds (not milliseconds)
|
113 |
|
114 | v4.2.3 (2018-11-03)
|
115 | -------------------
|
116 | [new] Add info event for execute function
|
117 | [fix] Fix JSON parsing with empty recordsets
|
118 | [new] Array / string literal template query preparation fixes
|
119 | [new] Passing encrypt option from mssql connection options to tedious options
|
120 | [change] Return the _poolDestroy promise before connecting again
|
121 |
|
122 | v4.2.2 (2018-10-17)
|
123 | -------------------
|
124 | [change] Updated to latest Tedious 2.7.1
|
125 |
|
126 | v4.2.1 (2018-08-05)
|
127 | -------------------
|
128 | [fix] Fix connections in the pool depleting due to unfulfilled Promises and timeouts
|
129 | [change] Updated to latest Tedious 2.6.4
|
130 |
|
131 | v4.2.0 (2018-07-05)
|
132 | -------------------
|
133 | [new] Added TVP support for msnodesqlv8 driver
|
134 | [new] Added support for information messages in msnodesqlv8 driver
|
135 | [new] Added support for request cancellation in msnodesqlv8 driver
|
136 | [fix] Fixed Tedious deprecation warnings
|
137 | [fix] Fixed ResourceRequest timed out error
|
138 | [fix] All query and batch methods now have the same interface
|
139 | [fix] Fixed msnodesqlv8 issue where the encrypt option was getting ignored
|
140 | [change] Updated to latest Tedious 2.3.1
|
141 |
|
142 | v4.1.0 (2017-09-29)
|
143 | -------------------
|
144 | [new] Adding support for the MultiSubnetFailover option in connection strings (Paul Kehrer)
|
145 | [new] Add request timeout support for msnodesqlv8 queries (Michael Parque)
|
146 | [fix] Fix type inference of non-integer numbers (Andrew Crites)
|
147 | [fix] Set acquireTimeout on generic pool (Karl Wiggisser)
|
148 |
|
149 | v4.0.4 (2017-04-25)
|
150 | -------------------
|
151 | [fix] Fix auto-closing of idle connections
|
152 |
|
153 | v4.0.3 (2017-04-25)
|
154 | -------------------
|
155 | [fix] Fixed broken CLI & debugging
|
156 |
|
157 | v4.0.2 (2017-04-19)
|
158 | -------------------
|
159 | [fix] Fixed broken JSON parser
|
160 |
|
161 | v4.0.1 (2017-04-02)
|
162 | -------------------
|
163 | [fix] Fixed stream in pipe mode
|
164 |
|
165 | v4.0.0 (2017-04-01)
|
166 | -------------------
|
167 | [new] Completly rewritten to ES6
|
168 | [new] Library is now compatible with Webpack
|
169 | [new] Library is ready for async/await
|
170 | [change] Removed support for < Node.js 4
|
171 | [change] Removed support for outdated node-tds and msnodesql drivers
|
172 | [change] Removed require('mssql/nofix') syntax
|
173 | [change] Removed verbose and debug mode
|
174 | [change] Removed 'driver' from options
|
175 | [change] Removed Transaction and Prepared Statement queues
|
176 | [change] Removed 'multiple' directive
|
177 | [change] Connection renamed to ConnectionPool
|
178 | [change] Updated to latest Tedious 2.0.0
|
179 |
|
180 | v3.3.0 (2016-05-06)
|
181 | -------------------
|
182 | [new] Added support for receiving informational messages
|
183 | [new] Added JSON support for msnodesql and msnodesqlv8 drivers
|
184 | [fix] Minor fixes in connection string parsing
|
185 |
|
186 | v3.2.1 (2016-04-16)
|
187 | -------------------
|
188 | [fix] Added PreparedStatement.lastRequest to access internal Request when using Promises
|
189 |
|
190 | v3.2.0 (2016-04-11)
|
191 | -------------------
|
192 | [new] Added experimental support for ES6 tagged template literals
|
193 | [new] Added support for Variant data type
|
194 | [change] Updated to latest Tedious 1.14.0
|
195 |
|
196 | v3.1.2 (2016-03-08)
|
197 | -------------------
|
198 | [fix] Correctly release connection after transaction error
|
199 |
|
200 | v3.1.1 (2016-02-21)
|
201 | -------------------
|
202 | [change] Minor internal changes because of connect-mssql module
|
203 |
|
204 | v3.1.0 (2016-02-13)
|
205 | -------------------
|
206 | [new] Added support for creating columns with primary keys in TVP Tables
|
207 |
|
208 | v3.0.1 (2016-02-04)
|
209 | -------------------
|
210 | [fix] Fix error causing app to crash when parsing json/xml from stored procedure
|
211 | [fix] Correctly check connection health after socket error
|
212 |
|
213 | v3.0.0 (2016-01-08)
|
214 | -------------------
|
215 | [new] Version bump because of breakinch change introduced in release 2.6
|
216 |
|
217 | v2.6.2 (2015-12-25) - unpublished from npm
|
218 | -------------------
|
219 | [new] Added support for receiving number of affected rows
|
220 | [new] Automatically concat chunks of FOR XML / FOR JSON recordset
|
221 | [fix] Correctly preserve domains
|
222 |
|
223 | v2.5.0 (2015-12-17)
|
224 | -------------------
|
225 | [new] Added support for new TDS driver msnodesqlv8
|
226 | [new] Support for configs formated as Connection String, Connection String URI
|
227 |
|
228 | v2.4.0 (2015-12-11)
|
229 | -------------------
|
230 | [new] Connection.connect, PreparedStatement.prepare and Transaction.begin now returns instance of itself as a first argument to Promise resolver.
|
231 | [fix] Correctly handle Socket Errors inside Requests (Jørgen Elgaard Larsen)
|
232 |
|
233 | v2.3.2 (2015-11-11)
|
234 | -------------------
|
235 | [change] Updated to latest Tedious 1.13.1
|
236 |
|
237 | v2.3.1 (2015-09-21)
|
238 | -------------------
|
239 | [fix] JSON fixes
|
240 |
|
241 | v2.3.0 (2015-09-20)
|
242 | -------------------
|
243 | [new] Experimental JSON support
|
244 |
|
245 | v2.2.1 (2015-09-19)
|
246 | -------------------
|
247 | [change] Updated to latest Tedious 1.12.3
|
248 | [fix] Promise not returns rowCount in bulk load (Ben Farr)
|
249 |
|
250 | v2.2.0 (2015-08-17)
|
251 | -------------------
|
252 | [new] Added column metadata identity, caseSensitive and readOnly (nino-porcino)
|
253 |
|
254 | v2.1.8 (2015-08-11)
|
255 | -------------------
|
256 | [change] Updated to latest Tedious 1.12.2
|
257 |
|
258 | v2.1.7 (2015-08-09)
|
259 | -------------------
|
260 | [change] Updated to latest Tedious 1.11.4
|
261 |
|
262 | v2.1.6 (2015-06-17)
|
263 | -------------------
|
264 | [change] Updated to latest Tedious 1.11.2
|
265 |
|
266 | v2.1.5 (2015-06-05)
|
267 | -------------------
|
268 | [fix] Correctly resolve database and schema name from table path.
|
269 |
|
270 | v2.1.4 (2015-06-05)
|
271 | -------------------
|
272 | [new] Better test coverage, automated integration tests.
|
273 | [fix] msnodesql: Manual transaction aborting.
|
274 | [fix] msnodesql: Tests.
|
275 |
|
276 | v2.1.3 (2015-05-03)
|
277 | -------------------
|
278 | [fix] msnodesql: Release connection to pool on query error (Farhan Khan)
|
279 |
|
280 | v2.1.2 (2015-03-28)
|
281 | -------------------
|
282 | [fix] Fix name parsing in Table constructor (David Mercer)
|
283 |
|
284 | v2.1.1 (2015-02-25)
|
285 | -------------------
|
286 | [fix] Fix Promise in Prepared Statement
|
287 |
|
288 | v2.1.0 (2015-02-20)
|
289 | -------------------
|
290 | [new] Detailed SQL errors
|
291 | [fix] Precise detection of column data types
|
292 |
|
293 | v2.0.0 (2015-02-17)
|
294 | -------------------
|
295 | [change] Updated to latest Tedious 1.10.0
|
296 | [new] Promises
|
297 | [new] Pipe request to object stream
|
298 | [new] Integrated type checks
|
299 | [new] CLI
|
300 | [fix] Transaction Abort Handling
|
301 | [fix] Allow rollback on transaction with queued requests
|
302 | [fix] Connection pool fixes
|
303 | [fix] Minor fixes
|
304 |
|
305 | v1.3.0 (2014-10-27)
|
306 | -------------------
|
307 | [change] Updated to latest Tedious 1.7.0
|
308 | [new] Tedious: Char and NChar types are now available as input parameters
|
309 |
|
310 | v1.2.1 (2014-10-07)
|
311 | -------------------
|
312 | [change] Updated to latest Tedious 1.5.3
|
313 |
|
314 | v1.2.0 (2014-08-26)
|
315 | -------------------
|
316 | [change] Updated to latest Tedious 1.4.0
|
317 | [new] Added support for bulk insert.
|
318 |
|
319 | v1.1.1 (2014-08-07)
|
320 | -------------------
|
321 | [new] Added column index to recordset metadata.
|
322 | [fix] Minor fixes in Tedious driver
|
323 |
|
324 | v1.1.0 (2014-07-13)
|
325 | -------------------
|
326 | [change] Updated to latest Tedious 1.1.0
|
327 | [new] Added support for domain logins (NTLM)
|
328 |
|
329 | v1.0.2 (2014-07-04)
|
330 | -------------------
|
331 | [new] Added support for input and output parameters in batch method.
|
332 | [new] Added checks for SQL injection in parameter names
|
333 |
|
334 | v1.0.1 (2014-07-04)
|
335 | -------------------
|
336 | [new] Added support for Streaming in Prepared Statements
|
337 |
|
338 | v1.0.0 (2014-07-04)
|
339 | -------------------
|
340 | [new] Start of semantic versioning, and commitment to stable API until 2.0.0
|
341 |
|
342 | v0.6.2 (2014-07-04)
|
343 | -------------------
|
344 | [new] Added batch() method to execute sql commands like "create procedure"
|
345 | [new] Cancel request in node-tds driver
|
346 | [fix] Fixed VarChar/NVarChar/VarBinary MAX in prepared statements
|
347 |
|
348 | v0.6.1 (2014-07-04)
|
349 | -------------------
|
350 | [change] TDS debugging simplified
|
351 |
|
352 | v0.6.0 (2014-07-03)
|
353 | -------------------
|
354 | [change] Updated to latest Tedious 1.0.0
|
355 | [new] Added support for Streaming
|
356 | [new] Added option to set request timeout (config.requestTimeout = 15000)
|
357 | [new] Errors documented
|
358 | [change] Connection timeout renamed from config.timeout to config.connectionTimeout
|
359 | [fix] Minor bug fixes
|
360 |
|
361 | v0.5.5 (2014-06-24)
|
362 | -------------------
|
363 | [fix] Failed login left open connection pool
|
364 |
|
365 | v0.5.4 (2014-06-15)
|
366 | -------------------
|
367 | [new] Multiple errors handling
|
368 |
|
369 | v0.5.3 (2014-04-04)
|
370 | -------------------
|
371 | [fix] Multiple recordsets in Prepared Statements
|
372 |
|
373 | v0.5.2 (2014-04-04)
|
374 | -------------------
|
375 | [new] Support for Prepared Statements
|
376 | [fix] Fixed order of output parameters
|
377 | [fix] Minor fixes in node-tds driver
|
378 |
|
379 | v0.5.1 (2014-04-01)
|
380 | -------------------
|
381 | [change] Updated to new Tedious 0.2.1
|
382 | [new] You can now easily setup type's length/scale (sql.VarChar(50))
|
383 | [new] Serialization of Geography and Geometry CLR types
|
384 | [new] Support for creating Table-Value Parameters (var tvp = new sql.Table())
|
385 | [new] Output parameters are now Input-Output and can handle initial value
|
386 | [new] Option to choose whether to pass/receive times in UTC or local time
|
387 | [new] Connecting to named instances simplified
|
388 | [change] Default SQL data type for JS String type is now NVarChar (was VarChar)
|
389 |
|
390 | v0.5.0 (2014-01-25)
|
391 | -------------------
|
392 | [new] You can now attach event listeners to Connection (connect, close), Transaction (begin, commit, rollback) and Request (row, recordset, done)
|
393 | [new] You can now set length of Char, NChar and Binary output parameters
|
394 | [new] You can now change default transaction isolation level
|
395 | [change] Errors are now splitted to three categories for better error handling - ConnectionError, TransactionError, ReqestError
|
396 | [new] Tedious: Binary and VarBinary types are now available as input and output parameters
|
397 | [new] Tedious: Image type is now available as input parameter
|
398 | [change] Tedious: Binary, VarBinary and Image types are now returned as buffer (was byte array)
|
399 | [change] Tedious: Transaction isolationLevel default is now READ_COMMITED (was READ_UNCOMMITED)
|
400 | [fix] Tedious: Fixed issue when zero value was casted as null when using BigInt as input parameter
|
401 | [fix] Tedious: Fixed issue when dates before 1900/01/01 in input parameters resulted in "Out of bounds" error
|
402 | [new] node-tds: UniqueIdentifier type in now available as input and output parameter
|
403 | [fix] node-tds: UniqueIdentifier type is now parsed correctly as string value (was buffer)
|
404 | [fix] node-tds: Text, NText, Char, NChar, VarChar and NVarChar input parameters has correct lengths
|
405 | [fix] node-tds: Fixed Error messages
|
406 | [fix] Msnodesql: Char, NChar, Xml, Text, NText and VarBinary types are now correctly functional as output parameters
|
407 |
|
408 | v0.4.5 (2014-01-23)
|
409 | -------------------
|
410 | [new] Added support for "co" flow controller via co-mssql module
|
411 |
|
412 | v0.4.4 (2014-01-22)
|
413 | -------------------
|
414 | [change] returnValue also accessible as property of recordsets
|
415 |
|
416 | v0.4.3 (2014-01-14)
|
417 | -------------------
|
418 | [fix] Even better network error handling in tedious
|
419 | [new] Module is compatible with Node.js 0.11
|
420 |
|
421 | v0.4.2 (2014-01-06)
|
422 | -------------------
|
423 | [new] Added connection timeout for node-tds
|
424 | [fix] Module now handle tedious network errors correctly
|
425 | [fix] Connection pool now destroy failed connections correctly
|
426 | [fix] Connection to instance name via tedious now works correctly
|
427 | [change] Option 'timeout' is now common option for all drivers (see documentation)
|
428 |
|
429 | v0.4.1 (2013-12-13)
|
430 | -------------------
|
431 | [fix] Filter empty recordsets when NOCOUNT is OFF
|
432 |
|
433 | v0.4.0 (2013-12-12)
|
434 | -------------------
|
435 | [new] Added support for transactions.
|
436 | [new] node-tds is now available as an optional TDS driver.
|
437 | [new] Documentation updated to CSDoc spec.
|
438 | [change] Tedious driver no longer use tedious-connection-pool for connection pooling
|
439 | [change] Msnodesql is now pooled
|
440 |
|
441 | v0.3.4 (2013-10-23)
|
442 | -------------------
|
443 | [new] Queries with input and output parameters.
|
444 |
|
445 | v0.3.3 (2013-10-23)
|
446 | -------------------
|
447 | [new] Test connection when tedious pool is created.
|
448 |
|
449 | v0.3.2 (2013-09-30)
|
450 | -------------------
|
451 | [new] Added support for multiple connections.
|
452 |
|
453 | v0.3.1 (2013-09-13)
|
454 | -------------------
|
455 | [fix] NaN values of input parameters are automatically converted to null.
|
456 |
|
457 | v0.3.0 (2013-09-08)
|
458 | -------------------
|
459 | [new] Documentation extended
|
460 | [new] Microsoft Driver for Node.js for SQL Server is now available as an optional TDS driver.
|
461 | [new] Metadata are now accesible trough recordset.columns property.
|
462 | [new] Support for multiple recordsets in query.
|
463 | [fix] SQL null values are now correctly casted as JS null.
|
464 | [change] Default SQL data type for JS Number is now sql.Int (was sql.BigInt).
|
465 |
|
466 | v0.2.5 (2013-09-05)
|
467 | -------------------
|
468 | [fix] Multiple columns with identical name in same recordset are now handled correctly.
|
469 |
|
470 | v0.2.4 (2013-08-15)
|
471 | -------------------
|
472 | [fix] Errors are now instance of Error.
|
473 | [fix] Empty recordsets fixed.
|
474 |
|
475 | v0.2.3 (2013-08-14)
|
476 | -------------------
|
477 | [new] Verbose mode for query.
|
478 |
|
479 | v0.2.2 (2013-08-11)
|
480 | -------------------
|
481 | [new] Verbose mode for stored procedure.
|
482 | [fix] Null values fixed.
|
483 |
|
484 | v0.2.0 (2013-08-10)
|
485 | -------------------
|
486 | [change] Project was renamed from xsp-mssql to node-mssql.
|
487 | [fix] Some minor bug fixes.
|
488 |
|
489 | v0.1.0 (2013-07-10)
|
490 | -------------------
|
491 | Initial release.
|