changelog.html

---
layout: default
title: ChangeLog
---

<h1>Change Log</h1>

<h3>v1.9.0 <span class="date">2015-XX-XX</span></h3>
<ul>
  <li>
    <a href="https://github.com/pekim/tedious/pull/231">#231</a>
    Add <code>Connection#saveTransaction</code> to create transaction savepoints.
    Change <code>Connection#rollbackTransaction</code> to allow manually specifying
    a transaction or savepoint name. Introduce new <code>Connection#transaction</code>
    helper to simplify transaction handling, especially when nesting transactions.
    (Rohit Arjunagi, Arthur Schreiber)
  </li>
</ul>

<h3>v1.8.1 <span class="date">2015-01-07</span></h3>
<ul>
  <li>
    <a href="https://github.com/pekim/tedious/pull/224">#224</a>
    Fix Rerouting on TLS Encrypted Connections. (Christopher Anderson)
  </li>
</ul>

<h3>v1.8.0 <span class="date">2014-11-26</span></h3>
<ul>
  <li>
    <a href="https://github.com/pekim/tedious/pull/192">#192</a>
    Remove default SSL cipher suite. (Greg Brail)
  </li>
  <li>
    Fix resolving of default length, scale and precision in bluk insert (Patrik Simek)
  </li>
</ul>

<h3>v1.7.0 <span class="date">2014-10-27</span></h3>
<ul>
  <li>
    <a href="https://github.com/pekim/tedious/pull/205">#205</a>
    Char and NChar types are now available as input parameters (Kris Klosterman, Patrik Simek)
  </li>
  <li>
    Fix resolving of default length, scale and precision in bluk insert (Patrik Simek)
  </li>
</ul>

<h3>v1.6.0 <span class="date">2014-10-27</span></h3>
<ul>
  <li>
    <a href="https://github.com/pekim/tedious/pull/209">#209</a>
    Added default scale for data types requiring it. (Chris Dibbern)
  </li>
</ul>

<h3>v1.5.8 <span class="date">2014-10-24</span></h3>
<ul>
  <li>
    <a href="https://github.com/pekim/tedious/pull/211">#211</a>
    Do not attempt to connect after instance lookup in final state. (Ben Youngblood)
    Also should fix <a href="https://github.com/pekim/tedious/issues/185">#185</a>.
  </li>
</ul>

<h3>v1.5.7 <span class="date">2014-10-15</span></h3>
<ul>
  <li>
	  <a href="https://github.com/pekim/tedious/pull/206">#206</a>
	  Allow eliminating request timeouts with <code>options.requestTimeout = 0</code>. (Bret Copeland)
  </li>
</ul>

<h3>v1.5.6 <span class="date">2014-10-09</span></h3>
<ul>
  <li>
	  <a href="https://github.com/pekim/tedious/issues/201">#201</a>
    Fix rowCollectionOnDone and rowCollectionOnRequestCompletion. (Patrik Simek)
  </li>
</ul>

<h3>v1.5.5 <span class="date">2014-10-09</span></h3>
<ul>
  <li>
	  <a href="https://github.com/pekim/tedious/issues/200">#200</a>
	  Added <code>options.columnNameReplacer</code>. (Bret Copeland)
  </li>
</ul>

<h3>v1.5.4 <span class="date">2014-10-08</span></h3>
<ul>
  <li>
	  <a href="https://github.com/pekim/tedious/issues/197">#197</a>
	  Fix nvarchar(max) in BulkLoad insert. (Bret Copeland)
  </li>
</ul>

<h3>v1.5.3 <span class="date">2014-10-03</span></h3>
<ul>
  <li>
	  <a href="https://github.com/pekim/tedious/pull/199">#199</a>
	  Set keepAlive on connected socket. (ravensteel)
  </li>
</ul>

<h3>v1.5.2 <span class="date">2014-09-23</span></h3>
<ul>
  <li>
    Add option to bind to specific local address. (Bryan Ross)
  </li>
  <li>
    Add support for set xact_abort per-connection. (Bryan Ross)
  </li>
</ul>

<h3>v1.5.1 <span class="date">2014-09-08</span></h3>
<ul>
  <li>
    <a href="https://github.com/pekim/tedious/pull/182">#182</a>
    Added support for readonly intent and automatic connection re-routing. (Bryan Ross)
  </li>
</ul>

<h3>v1.4.3 <span class="date">2014-08-31</span></h3>
<ul>
  <li>
    <a href="https://github.com/pekim/tedious/pull/180">#180</a>
    Added aliases for some data types ending with N. (Marcin Konicki)
  </li>
</ul>

<h3>v1.4.2 <span class="date">2014-08-27</span></h3>
<ul>
  <li>
    <a href="https://github.com/pekim/tedious/issues/168">#168</a>
    Added support for transactions in TDS 7.1 (SQL Server 2000). (Patrik Simek, Bret Copeland)
  </li>
  <li>
    Fixed a bug when prepared statement has no parameters. (Patrik Simek)
  </li>
</ul>

<h3>v1.4.1 <span class="date">2014-08-26</span></h3>
<ul>
  <li>
    <a href="https://github.com/pekim/tedious/issues/176">#176</a>
    Fixed an ignored error when the bulk load schema doesn't match the insert table schema. (Bret Copeland, Patrik Simek)
  </li>
</ul>

<h3>v1.4.0 <span class="date">2014-08-26</span></h3>
<ul>
  <li>
    BulkLoad API is stable and <a href="bulk-load.html">documented</a>. 
    Report bugs on the <a href="https://github.com/pekim/tedious/issues">issue tracker</a>. (Bret Copeland)
  </li>
</ul>

<h3>v1.3.5 <span class="date">2014-08-19</span></h3>
<ul>
  <li>
    Fixed a bug that caused CREATE FUNCTION statements to throw an error. (Bryan Ross)
  </li>
</ul>

<h3>v1.3.4 <span class="date">2014-08-19</span></h3>
<ul>
  <li>
    Added guard against adding columns to BulkLoad after rows have been written. (Bret Copeland)
  </li>
</ul>

<h3>v1.3.3 <span class="date">2014-08-16</span></h3>
<ul>
  <li>
    BulkLoad can generate table creation SQL - useful for temporary tables. (Aurélien Gasser)<br>
    (Pull Request <a href="https://github.com/pekim/tedious/pull/173">#173</a>)
  </li>
</ul>

<h3>v1.3.2 <span class="date">2014-08-14</span></h3>
<ul>
  <li>
    Added ability for tracking buffer to grow exponentially. Bulk Load now uses this (Aurélien Gasser)<br>
    (Pull Request <a href="https://github.com/pekim/tedious/pull/172">#172</a>)
  </li>
</ul>

<h3>v1.3.1 <span class="date">2014-08-13</span></h3>
<ul>
  <li>
    API change to Bulk Insert. Still experimental and subject to change. (Bret Copeland)<br>
    (See Commit: <a href="https://github.com/pekim/tedious/commit/c4fd65fa9687ca1521c44864552a7b61e8d58660">c4fd65f</a>)
  </li>
</ul>

<h3>v1.3.0 <span class="date">2014-08-12</span></h3>
<ul>
  <li>
    Added <em><strong>experimental</strong></em> support for Bulk Insert. (Bret Copeland)<br>
    (See Commit: <a href="https://github.com/pekim/tedious/commit/eb8ae04f00c2ab8d49b757e5f835e416c9bde627">eb8ae04</a>)
  </li>
</ul>

<h3>v1.2.2 <span class="date">2014-08-05</span></h3>
<ul>
  <li>
    Fixed a bug with bigint serialization. (Bret Copeland)<br>
    (Issue <a href="https://github.com/pekim/tedious/pull/170">#170</a>)
  </li>
</ul>

<h3>v1.2.0 <span class="date">2014-07-20</span></h3>
<ul>
  <li>
    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 <br /><br />
    Also added <code>fallbackToDefaultDb</code> option to re-enable 
    previous behavior (Bryan J. Ross)
    (Issue <a href="https://github.com/pekim/tedious/pull/166">#166</a>)
  </li>
</ul>

<h3>v1.1.0 <span class="date">2014-07-13</span></h3>
<ul>
    <li>
        Added support for domain logins (Alex Robson)
    </li>
</ul>

<h3>v1.0.0 <span class="date">2014-07-03</span></h3>
<ul>
    <li>
        Start of semantic versioning, and commitment to stable API until v2.0.0.
    </li>
</ul>

<h3>v0.3.0 <span class="date">2014-06-24</span></h3>
<ul>
    <li>
        Added support for default connection isolation level (Bryan J. Ross)<br>
        (Issue <a href="https://github.com/pekim/tedious/pull/156">#156</a>)
    </li>
    <li>
        Added support for returning camel cased columns (Bryan J. Ross)
    </li>
    <li>
        Added support for building lib on Windows (Bryan J. Ross)
    </li>
</ul>

<h3>v0.2.4 <span class="date">2014-06-15</span></h3>
<ul>
    <li>
        Add request timeout (Arthur Schreiber)
    </li>
    <li>
        Prevent IEEE 754 floating point errors in Numeric and Decimal (Bryan J. Ross)<br>
        (Issue <a href="https://github.com/pekim/tedious/pull/155">#155</a>)
    </li>
</ul>

<h3>v0.2.2 <span class="date">2014-04-01</span></h3>
<ul>
    <li>
        Fixed ReferenceError in instance lookup error handler (Patrik Simek)<br>
        (Issue <a href="https://github.com/pekim/tedious/issues/142">#142</a>)
    </li>
</ul>

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

<h3>v0.1.5 <span class="date">2013-06-24</span></h3>
<ul>
    <li>
        Emit connect event with error (if connecting) or emit errorMessage event on socket error. (Daniel Rapp)<br>
        (Issue <a href="https://github.com/pekim/tedious/issues/94">#94</a>)
    </li>
    <li>
        Emit event after request callback. (Matheus Kautzmann)<br>
        (Issue <a href="https://github.com/pekim/tedious/issues/96">#96</a>)
    </li>
</ul>

<h3>v0.1.4 <span class="date">2013-04-14</span></h3>
<ul>
    <li>
        Add placeholder event handlers to suppress crash in final. (Nicholas Penree)<br>
        (Issue <a href="https://github.com/pekim/tedious/issues/80">#80</a>)
    </li>
    <li>
        Better default values for options in default sql statement. (Kevin Pullin)<br>
        (Issue <a href="https://github.com/pekim/tedious/issues/83">#83</a>)
    </li>
    <li>
        Expose collected rows in request callback and done* events.<br>
        (Issue <a href="https://github.com/pekim/tedious/issues/73">#73</a>)
    </li>
    <li>
        Add connection.reset function, to reset connection to initial state.<br>
        (Issue <a href="https://github.com/pekim/tedious/issues/85">#85</a>)
    </li>
    <li>
        Make encrypted connections work with node v0.10.<br>
        (Issue <a href="https://github.com/pekim/tedious/issues/86">#86</a>)
    </li>
    <li>
        Honour optional appName property in config.options.<br>
        (Issue <a href="https://github.com/pekim/tedious/issues/91">#91</a>)
    </li>
    <li>
        Add support for using Real in parameterized statements.
    </li>
    <li>
        Correct value for Request's completion callback's rowCount argument for statements
        other than select.
    </li>
</ul>

<h3>v0.1.3 <span class="date">2013-02-17</span></h3>
<ul>
    <li>
        Support Text as a parameter type. (Zach Aller)<br>
        (Issue <a href="https://github.com/pekim/tedious/issues/75">#75</a>)
    </li>
    <li>
        New example, showing insert statement using parameters of different types. (Will Munn)<br>
        (Issue <a href="https://github.com/pekim/tedious/issues/72">#72</a>)
    </li>
    <li>
        Support for duplicate column names in result sets. (Nadeem)<br>
        (Issue <a href="https://github.com/pekim/tedious/issues/70">#70</a>)
    </li>
</ul>

<h3>v0.1.2 <span class="date">2013-01-02</span></h3>
<ul>
  <li>
    Column not accessible by column name when the name is numeric.<br>
    (Issue <a href="https://github.com/pekim/tedious/issues/66">#66</a>)
  </li>
  <li>
    Support for XML data type in result sets.<br>
    (Issue <a href="https://github.com/pekim/tedious/issues/67">#67</a>)
  </li>
</ul>

<h3>v0.1.0 <span class="date">2012-11-25</span></h3>
<ul>
  <li>
    Support GUID, BigInt and Float as a parameter types. (Zach Aller)
  </li>
  <li>
    Support for windows936 encoding. (lastonesky)
  </li>
  <li>
    Same format for GUIDs in results and parameters. (Cort Fritz)
  </li>
</ul>

<h3>v0.0.7 <span class="date">2012-07-21</span></h3>
<ul>
  <li>
    Support for transactions.
  </li>
  <li>
    Experimental support for secure connections.
  </li>
  <li>
    Some support for TDS 7.1, for connecting to SQL Server 2000. (Phil Dodderidge)
  </li>
</ul>

<h3>v0.0.6 <span class="date">2012-05-27</span></h3>
<ul>
  <li>
    Remove post-install script hook.
    It won't run (as is) on Windows, and doesn't really add anything useful.
  </li>
</ul>

<h3>v0.0.5 <span class="date">2012-05-27</span></h3>
<ul>
  <li>
    Instead of publishing CoffeeScript files and compiling them at runtime,
    the CoffeeScript is compiled before publishing.
    Only Javascript files are pubslished and installed.
  </li>
  <li>
    Support for preparing and executing SQL.
  </li>
  <li>
    When the value of
    <code>tinyint</code>, <code>smallint</code> or <code>int</code>
    parameters are 0, do not send their value as null.<br>
    (Issue <a href="https://github.com/pekim/tedious/issues/25">#25</a>)
  </li>
  <li>
    Support for <code>DATABASE_MIRRORING_PARTNER</code> environment change notification.<br>
    (Issue <a href="https://github.com/pekim/tedious/issues/22">#22</a>)
  </li>
  <li>
    Support for using
    <code>bit</code>, <code>smalldatetime</code> and <code>datetime</code>
    types in parameterised statements.
  </li>
  <li>
    Support for using <code>varchar(max)</code> and <code>nvarchar(max)</code> in parameterised statements.<br>
    (Issue <a href="https://github.com/pekim/tedious/issues/32">#32</a>)
  </li>
  <li>
    Use iconv-lite instead of iconv.
    This means that tedious is back to pure Javascript, including its dependencies.
  </li>
</ul>

<h3>v0.0.4 <span class="date">2012-04-15</span></h3>
<ul>
  <li>
    On successful connection, set textsize (by default, to 2147483647).
    This allows long values to be
    returned for <code>varchar(max)</code>, <code>nvarchar(max)</code>, <code>varbinary(max)</code>,
    <code>text</code>, <code>ntext</code>, and <code>image</code> datatypes.
  </li>
  <li>
    Honour the defined locale for
    <code>char</code>, <code>varchar</code> and <code>text</code> 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.
  </li>
  <li>
    Added support for executing parameterised statements.<br>
    (Issue <a href="https://github.com/pekim/tedious/issues/14">#14</a>)
  </li>
  <li>
    Added support for calling procedures with parameters.<br>
    (Issue <a href="https://github.com/pekim/tedious/issues/16">#16</a>)
  </li>
  <li>
    Support connecting by instance name (instead of port).<br>
    (Issue <a href="https://github.com/pekim/tedious/issues/20">#20</a>)
  </li>
  <li>
    Expose the total number of rows returned, in Request's completion callback.
  </li>
</ul>

<h3>v0.0.3 <span class="date">2012-02-12</span></h3>
<ul>
  <li>
    Added support for Order tokens, meaning that select statements with an order clause can now be used.
  </li>
  <li>
    Added support for more data types in result sets:
    <code>uniqueidentifier</code>,
    <code>text</code>,
    <code>ntext</code>,
    <code>image</code>,
    <code>smallmoney</code>,
    <code>money</code>,
  </li>
  <li>
    Fixed bug that prevented new Requests from being initiated from a Request's completion callback.
  </li>
</ul>

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

<h3>v0.0.1 <span class="date">2011-12-04</span></h3>
<p>
  The initial release.
</p>

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