UNPKG

18.8 kBPlain TextView Raw
1v6.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
7v6.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
16v6.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
20v6.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
42v5.1.1 (2020-03-13)
43-------------------
44[fix] Bump acorn dependency for security fix
45
46v5.1.0 (2019-04-17)
47-------------------
48[new] Add readOnlyIntent to connection string parser ([#853](https://github.com/tediousjs/node-mssql/pull/853))
49
50v5.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
54v5.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
58v5.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
63v5.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
67v5.0.2 (2019-03-09)
68-------------------
69[change] Remove references to deprecated `TYPES.Null` from tedious
70
71v5.0.1 (2019-03-09)
72-------------------
73[change] Config objects are cloned so that the original object is not modified
74
75v5.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
84v4.3.8 (2020-03-13)
85-------------------
86[fix] Bump acorn dependency for security fix
87
88v4.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
92v4.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
97v4.3.5 (2019-03-09)
98-------------------
99[change] Remove references to deprecated `TYPES.Null` from tedious
100
101v4.3.4 (2019-03-09)
102-------------------
103[change] Config objects are cloned so that the original object is not modified
104
105v4.3.3 (2019-03-07)
106-------------------
107[change] Updated to latest generic-pool 3.6.1
108
109v4.3.0 (2018-11-20)
110-------------------
111[new] Add beforeConnect handler
112[change] Interpret connection timeout in seconds (not milliseconds)
113
114v4.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
122v4.2.2 (2018-10-17)
123-------------------
124[change] Updated to latest Tedious 2.7.1
125
126v4.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
131v4.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
142v4.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
149v4.0.4 (2017-04-25)
150-------------------
151[fix] Fix auto-closing of idle connections
152
153v4.0.3 (2017-04-25)
154-------------------
155[fix] Fixed broken CLI & debugging
156
157v4.0.2 (2017-04-19)
158-------------------
159[fix] Fixed broken JSON parser
160
161v4.0.1 (2017-04-02)
162-------------------
163[fix] Fixed stream in pipe mode
164
165v4.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
180v3.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
186v3.2.1 (2016-04-16)
187-------------------
188[fix] Added PreparedStatement.lastRequest to access internal Request when using Promises
189
190v3.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
196v3.1.2 (2016-03-08)
197-------------------
198[fix] Correctly release connection after transaction error
199
200v3.1.1 (2016-02-21)
201-------------------
202[change] Minor internal changes because of connect-mssql module
203
204v3.1.0 (2016-02-13)
205-------------------
206[new] Added support for creating columns with primary keys in TVP Tables
207
208v3.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
213v3.0.0 (2016-01-08)
214-------------------
215[new] Version bump because of breakinch change introduced in release 2.6
216
217v2.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
223v2.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
228v2.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
233v2.3.2 (2015-11-11)
234-------------------
235[change] Updated to latest Tedious 1.13.1
236
237v2.3.1 (2015-09-21)
238-------------------
239[fix] JSON fixes
240
241v2.3.0 (2015-09-20)
242-------------------
243[new] Experimental JSON support
244
245v2.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
250v2.2.0 (2015-08-17)
251-------------------
252[new] Added column metadata identity, caseSensitive and readOnly (nino-porcino)
253
254v2.1.8 (2015-08-11)
255-------------------
256[change] Updated to latest Tedious 1.12.2
257
258v2.1.7 (2015-08-09)
259-------------------
260[change] Updated to latest Tedious 1.11.4
261
262v2.1.6 (2015-06-17)
263-------------------
264[change] Updated to latest Tedious 1.11.2
265
266v2.1.5 (2015-06-05)
267-------------------
268[fix] Correctly resolve database and schema name from table path.
269
270v2.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
276v2.1.3 (2015-05-03)
277-------------------
278[fix] msnodesql: Release connection to pool on query error (Farhan Khan)
279
280v2.1.2 (2015-03-28)
281-------------------
282[fix] Fix name parsing in Table constructor (David Mercer)
283
284v2.1.1 (2015-02-25)
285-------------------
286[fix] Fix Promise in Prepared Statement
287
288v2.1.0 (2015-02-20)
289-------------------
290[new] Detailed SQL errors
291[fix] Precise detection of column data types
292
293v2.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
305v1.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
310v1.2.1 (2014-10-07)
311-------------------
312[change] Updated to latest Tedious 1.5.3
313
314v1.2.0 (2014-08-26)
315-------------------
316[change] Updated to latest Tedious 1.4.0
317[new] Added support for bulk insert.
318
319v1.1.1 (2014-08-07)
320-------------------
321[new] Added column index to recordset metadata.
322[fix] Minor fixes in Tedious driver
323
324v1.1.0 (2014-07-13)
325-------------------
326[change] Updated to latest Tedious 1.1.0
327[new] Added support for domain logins (NTLM)
328
329v1.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
334v1.0.1 (2014-07-04)
335-------------------
336[new] Added support for Streaming in Prepared Statements
337
338v1.0.0 (2014-07-04)
339-------------------
340[new] Start of semantic versioning, and commitment to stable API until 2.0.0
341
342v0.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
348v0.6.1 (2014-07-04)
349-------------------
350[change] TDS debugging simplified
351
352v0.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
361v0.5.5 (2014-06-24)
362-------------------
363[fix] Failed login left open connection pool
364
365v0.5.4 (2014-06-15)
366-------------------
367[new] Multiple errors handling
368
369v0.5.3 (2014-04-04)
370-------------------
371[fix] Multiple recordsets in Prepared Statements
372
373v0.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
379v0.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
390v0.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
408v0.4.5 (2014-01-23)
409-------------------
410[new] Added support for "co" flow controller via co-mssql module
411
412v0.4.4 (2014-01-22)
413-------------------
414[change] returnValue also accessible as property of recordsets
415
416v0.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
421v0.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
429v0.4.1 (2013-12-13)
430-------------------
431[fix] Filter empty recordsets when NOCOUNT is OFF
432
433v0.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
441v0.3.4 (2013-10-23)
442-------------------
443[new] Queries with input and output parameters.
444
445v0.3.3 (2013-10-23)
446-------------------
447[new] Test connection when tedious pool is created.
448
449v0.3.2 (2013-09-30)
450-------------------
451[new] Added support for multiple connections.
452
453v0.3.1 (2013-09-13)
454-------------------
455[fix] NaN values of input parameters are automatically converted to null.
456
457v0.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
466v0.2.5 (2013-09-05)
467-------------------
468[fix] Multiple columns with identical name in same recordset are now handled correctly.
469
470v0.2.4 (2013-08-15)
471-------------------
472[fix] Errors are now instance of Error.
473[fix] Empty recordsets fixed.
474
475v0.2.3 (2013-08-14)
476-------------------
477[new] Verbose mode for query.
478
479v0.2.2 (2013-08-11)
480-------------------
481[new] Verbose mode for stored procedure.
482[fix] Null values fixed.
483
484v0.2.0 (2013-08-10)
485-------------------
486[change] Project was renamed from xsp-mssql to node-mssql.
487[fix] Some minor bug fixes.
488
489v0.1.0 (2013-07-10)
490-------------------
491Initial release.