forked from tediousjs/node-mssql
-
Notifications
You must be signed in to change notification settings - Fork 0
/
CHANGELOG.txt
389 lines (318 loc) · 12.3 KB
/
CHANGELOG.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
v5.0.0 (2018-??-??)
-------------------
[change] Updated to latest Tedious 4.1.1
[change] Node.js < 6 is no longer supported
[change] Support dropped for deprecated tedious configuration values and types
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.