Change Log

v1.14.0 2016-04-10

#350 Add Variant data type support (Patrik Simek)
#376 Fix parsing of SQL collations (Patrik Simek)
#361 Align to code style used in Node 4+. (Arthur Schreiber)

v1.13.2 2015-12-31

#340 Fix for nvarchar(max) columns on sql 2005. (Jonas Budelmann)

v1.13.1 2015-10-28

#336 Fix issues with DateTime2 parameters. (Arthur Schreiber)

v1.13.0 2015-10-27

#308 Fix token and received packet debug output. (Arthur Schreiber)
#290 Convert codebase from CoffeeScript to ES2016. (Arthur Schreiber)
#322 Fix for binary data being truncated on insert. (Bruno Jouhier)
#330 Forward socket errors to request callbacks. (ashelley and Arthur Schreiber)

v1.12.3 2015-09-07

#309 Don't overwrite configuration with routing data. (Arthur Schreiber)
#310 Send correct servername in Login7 after rerouting. (Arthur Schreiber)

v1.12.2 2015-08-11

#297 Fix for Windows Domain Authentication no longer working. (Arthur Schreiber)

v1.12.1 2015-08-01

fe9249a Fix TypeError: Cannot read property 'useUTC' of undefined inadvertently introduced in 1.12.0. (Evan Lucas)

v1.12.0 2015-07-31

#288 Upgraded dependencies. (Arthur Schreiber)
#285 Stream Parser using Generators to make Tedious faster and use less memory using the magic of generators. (Arthur Schreiber)

v1.11.5 2015-09-07

#309 Don't overwrite configuration with routing data. (Fix was backported from v1.12.3.) (Arthur Schreiber)
#310 Send correct servername in Login7 after rerouting. (Fix was backported from v1.12.3.) (Arthur Schreiber)

v1.11.4 2015-07-31

Fixed issue with NPM package publishing failing due to npmjs.com API change.
No other change from 1.11.3.

v1.11.3 2015-07-31

#276/#278 Do not let invalid dates pass the data validation check. (Bret Copeland)
Minor fixes

v1.11.2 2015-06-17

#275 Do not pass additional arguments to transaction continuation. (Arthur Schreiber)

v1.11.1 2015-06-17

#253 Fix daylight saving issue for non utc dates. (Stefan Lüchinger)

v1.11.0 2015-03-15

#230 New columns are now nullable by default. This can be disabled using config.options.enableAnsiNullDefault = false. (Lee Houghton)

v1.10.0 2015-02-17

Extended error information (Lee Houghton)
#202 Integrated type checks (Patrik Simek)
#207 Fix issues with Login7 Payload (Alex Robson)
#243 Fix crypto deprecation warning with Node v0.11.14+ (Rob Shaw)
#237 Fix date, time and datetime2 when useUTC is false (Patrik Simek)
Minor fixes

v1.9.0 2015-01-27

#231 Add Connection#saveTransaction to create transaction savepoints. Change Connection#rollbackTransaction to allow manually specifying a transaction or savepoint name. Introduce new Connection#transaction helper to simplify transaction handling, especially when nesting transactions. (Rohit Arjunagi, Arthur Schreiber)

v1.8.1 2015-01-07

#224 Fix Rerouting on TLS Encrypted Connections. (Christopher Anderson)

v1.8.0 2014-11-26

#192 Remove default SSL cipher suite. (Greg Brail)

v1.7.0 2014-10-27

#205 Char and NChar types are now available as input parameters (Kris Klosterman, Patrik Simek)
Fix resolving of default length, scale and precision in bluk insert (Patrik Simek)

v1.6.0 2014-10-27

#209 Added default scale for data types requiring it. (Chris Dibbern)

v1.5.8 2014-10-24

#211 Do not attempt to connect after instance lookup in final state. (Ben Youngblood) Also should fix #185.

v1.5.7 2014-10-15

#206 Allow eliminating request timeouts with options.requestTimeout = 0. (Bret Copeland)

v1.5.6 2014-10-09

#201 Fix rowCollectionOnDone and rowCollectionOnRequestCompletion. (Patrik Simek)

v1.5.5 2014-10-09

#200 Added options.columnNameReplacer. (Bret Copeland)

v1.5.4 2014-10-08

#197 Fix nvarchar(max) in BulkLoad insert. (Bret Copeland)

v1.5.3 2014-10-03

#199 Set keepAlive on connected socket. (ravensteel)

v1.5.2 2014-09-23

Add option to bind to specific local address. (Bryan Ross)
Add support for set xact_abort per-connection. (Bryan Ross)

v1.5.1 2014-09-08

#182 Added support for readonly intent and automatic connection re-routing. (Bryan Ross)

v1.4.3 2014-08-31

#180 Added aliases for some data types ending with N. (Marcin Konicki)

v1.4.2 2014-08-27

#168 Added support for transactions in TDS 7.1 (SQL Server 2000). (Patrik Simek, Bret Copeland)
Fixed a bug when prepared statement has no parameters. (Patrik Simek)

v1.4.1 2014-08-26

#176 Fixed an ignored error when the bulk load schema doesn't match the insert table schema. (Bret Copeland, Patrik Simek)

v1.4.0 2014-08-26

BulkLoad API is stable and documented. Report bugs on the issue tracker. (Bret Copeland)

v1.3.5 2014-08-19

Fixed a bug that caused CREATE FUNCTION statements to throw an error. (Bryan Ross)

v1.3.4 2014-08-19

Added guard against adding columns to BulkLoad after rows have been written. (Bret Copeland)

v1.3.3 2014-08-16

BulkLoad can generate table creation SQL - useful for temporary tables. (Aurélien Gasser)
(Pull Request #173)

v1.3.2 2014-08-14

Added ability for tracking buffer to grow exponentially. Bulk Load now uses this (Aurélien Gasser)
(Pull Request #172)

v1.3.1 2014-08-13

API change to Bulk Insert. Still experimental and subject to change. (Bret Copeland)
(See Commit: c4fd65f)

v1.3.0 2014-08-12

Added experimental support for Bulk Insert. (Bret Copeland)
(See Commit: eb8ae04)

v1.2.2 2014-08-05

Fixed a bug with bigint serialization. (Bret Copeland)
(Issue #170)

v1.2.0 2014-07-20

Changed default behavior for logins. Connections will no longer fall back to the user's default database if the requested database is unavailable and instead will produce an error

Also added fallbackToDefaultDb option to re-enable previous behavior (Bryan J. Ross) (Issue #166)

v1.1.0 2014-07-13

Added support for domain logins (Alex Robson)

v1.0.0 2014-07-03

Start of semantic versioning, and commitment to stable API until v2.0.0.

v0.3.0 2014-06-24

Added support for default connection isolation level (Bryan J. Ross)
(Issue #156)
Added support for returning camel cased columns (Bryan J. Ross)
Added support for building lib on Windows (Bryan J. Ross)

v0.2.4 2014-06-15

Add request timeout (Arthur Schreiber)
Prevent IEEE 754 floating point errors in Numeric and Decimal (Bryan J. Ross)
(Issue #155)

v0.2.2 2014-04-01

Fixed ReferenceError in instance lookup error handler (Patrik Simek)
(Issue #142)

v0.2.0 2014-04-01

Added support for TDS 7.4 (Patrik Simek)
Added request cancelation (Arthur Schreiber)
Added support for UDT, TVP, Time, Date, DateTime2 and DateTimeOffset data types (Patrik Simek)
Added option to choose whether to pass/receive times in UTC or local time (Patrik Simek)
(Issues #95, #108 and #133)
Binary, VarBinary, Image, Numeric, Decimal, SmallMoney and Money are now supported as input parameters (Patrik Simek)
Binary, VarBinary and Image types are now returned as Buffer (Patrik Simek)
Connection errors are now correctly propagated to connect event (Patrik Simek)
Better support for numeric column names and columns with same name (Patrik Simek)
(Issues #76 and #126)
Errors are now instanceof Error / ConnectionError / RequestError (Patrik Simek)
(Issue #120)
Transaction isolationLevel default is now READ_COMMITED (Patrik Simek)
Fixed issue when zero value was casted as null when using BigInt as input parameter (Patrik Simek)
Fixed issue when dates before 1900/01/01 in input parameters resulted in "Out of bounds" error (Patrik Simek)
(Issue #104)
Fixed negative return values (Patrik Simek)
(Issue node-mssql#25)
Fixed compatibility with TDS 7.1 (Patrik Simek)
(Issue #112)

v0.1.5 2013-06-24

Emit connect event with error (if connecting) or emit errorMessage event on socket error. (Daniel Rapp)
(Issue #94)
Emit event after request callback. (Matheus Kautzmann)
(Issue #96)

v0.1.4 2013-04-14

Add placeholder event handlers to suppress crash in final. (Nicholas Penree)
(Issue #80)
Better default values for options in default sql statement. (Kevin Pullin)
(Issue #83)
Expose collected rows in request callback and done* events.
(Issue #73)
Add connection.reset function, to reset connection to initial state.
(Issue #85)
Make encrypted connections work with node v0.10.
(Issue #86)
Honour optional appName property in config.options.
(Issue #91)
Add support for using Real in parameterized statements.
Correct value for Request's completion callback's rowCount argument for statements other than select.

v0.1.3 2013-02-17

Support Text as a parameter type. (Zach Aller)
(Issue #75)
New example, showing insert statement using parameters of different types. (Will Munn)
(Issue #72)
Support for duplicate column names in result sets. (Nadeem)
(Issue #70)

v0.1.2 2013-01-02

Column not accessible by column name when the name is numeric.
(Issue #66)
Support for XML data type in result sets.
(Issue #67)

v0.1.0 2012-11-25

Support GUID, BigInt and Float as a parameter types. (Zach Aller)
Support for windows936 encoding. (lastonesky)
Same format for GUIDs in results and parameters. (Cort Fritz)

v0.0.7 2012-07-21

Support for transactions.
Experimental support for secure connections.
Some support for TDS 7.1, for connecting to SQL Server 2000. (Phil Dodderidge)

v0.0.6 2012-05-27

Remove post-install script hook. It won't run (as is) on Windows, and doesn't really add anything useful.

v0.0.5 2012-05-27

Instead of publishing CoffeeScript files and compiling them at runtime, the CoffeeScript is compiled before publishing. Only Javascript files are pubslished and installed.
Support for preparing and executing SQL.
When the value of tinyint, smallint or int parameters are 0, do not send their value as null.
(Issue #25)
Support for DATABASE_MIRRORING_PARTNER environment change notification.
(Issue #22)
Support for using bit, smalldatetime and datetime types in parameterised statements.
Support for using varchar(max) and nvarchar(max) in parameterised statements.
(Issue #32)
Use iconv-lite instead of iconv. This means that tedious is back to pure Javascript, including its dependencies.

v0.0.4 2012-04-15

On successful connection, set textsize (by default, to 2147483647). This allows long values to be returned for varchar(max), nvarchar(max), varbinary(max), text, ntext, and image datatypes.
Honour the defined locale for char, varchar and text datatypes. iconv is used to perform the conversion, and is included as an optional dependency. If it is not available, then ascii is used as fallback when converting the buffers to strings.
Added support for executing parameterised statements.
(Issue #14)
Added support for calling procedures with parameters.
(Issue #16)
Support connecting by instance name (instead of port).
(Issue #20)
Expose the total number of rows returned, in Request's completion callback.

v0.0.3 2012-02-12

Added support for Order tokens, meaning that select statements with an order clause can now be used.
Added support for more data types in result sets: uniqueidentifier, text, ntext, image, smallmoney, money,
Fixed bug that prevented new Requests from being initiated from a Request's completion callback.

v0.0.2 2012-01-08

Changed the API quite a bit, and documented it.
Removed dependency on buffer-tools package. This was the only package with C++, so it should be easier to use tedious on Windows now.
Added main property to package.json.
Added ReadableTrackingBuffer and WritableTrackingBuffer, making a lot of Buffer building and parsing code a lot simpler.
Added support for more data types in result sets (Ciaran Jessup): bigint, binary, varbinary, varbinary(max), varchar(max), nvarchar(max), real, float.
Simplified error handling for unrecoverable errors.
Use a statemachine for connection state (making it much easier to implement the states documented in the TDS specification).
Make packet size configurable.

v0.0.1 2011-12-04

The initial release.

Tedious is just about useable for simple statements.
Session establishment and authentication work.
Sending SQL statements (in a SQL_BATCH packet) works for some simple statements.
Many simple data types are supported.